{"id":69416,"date":"2021-08-20T14:23:03","date_gmt":"2021-08-20T18:23:03","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/important-links-for-mysql-postgresql-firebird-enterprisedb-ingres-2\/"},"modified":"2025-05-11T20:19:39","modified_gmt":"2025-05-11T20:19:39","slug":"important-links-for-mysql-postgresql-firebird-enterprisedb-ingres-2","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69416","title":{"rendered":"Important Links for Mysql, PostGreSQL, Firebird, EnterpriseDB, Ingres #2"},"content":{"rendered":"

Firebird and postgresql:http:\/\/www.linuxjournal.com\/node\/7010
Important comment: easy to migrate from oracle to firebird than to postgre or mysql. From interbase to firebird will be better as they are similar.<\/p>\n

http:\/\/forums.devshed.com\/firebird-sql-development-61\/mysql–vs–firebird-sql-62269.html : Firebird is far better choice than mysql
As for Performance, MySQL will outperform Firebird on almost all tests on local machine……
On a Network Server a properly designed Firebird Server will outperform MySQL on any Test and the network-Traffic generated by Mysql will be many times higher than FirebirdSo you decide the one you need according to your needs …..<\/p>\n

This link also compares fb with potgre and favors fb as the author’s background is borland<\/p>\n

Why Postgress is better than firebird<\/h2>\n

Firebird is not as good as PostgresQL (Score:0) By Anonymous Reader on 2004.12.03 2:21 (#102703) And here is why:<\/p>\n

    \n
  1. Firebird has no temp table support.<\/li>\n
  2. \n

    Firebird uses several SQL modes i.e DSQL which only works client side and PSQL which only works in procs. All sql works in Postgres functions.Try creating a table or a user in a Firebird proc…ooops can’t be done.<\/p>\n<\/li>\n

  3. \n

    Firebird databases grow out of control and have to be backed up restored on a regular basis.<\/p>\n<\/li>\n

  4. \n

    Firebird has a concept of a OAT (oldest active transaction counter) if this counter gets stuck all transactions get held up and your DB size goes through the roof and performance goes to the basement.<\/p>\n<\/li>\n

  5. \n

    Firebird has virtually no built in functions and flakey UDFs must be used. Postgres on the other hand has every function you can think of.<\/p>\n<\/li>\n

  6. \n

    Postgres has many rich procedural languages including perl,TCL,Java and C# in the works.<\/p>\n<\/li>\n<\/ol>\n

    I could go on…. Version 8 of Postgres which will be released soon adds point in time recovery, Try except error handling in functions, table spaces and more.<\/p>\n

    I converted all my apps from Firebird 1.5 to Postgresql 7.4 and I would never use Firebird again on Unix or Windows<\/p>\n

    From: http:\/\/sitestree.com\/?p=4714
    Categories:2
    Tags:
    Post Data:2008-08-04 23:03:04<\/p>\n

        Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a>\n    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> \n    In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a>\n    <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a>\n    8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>\n    Shop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a>\n    Medium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n<\/code><\/pre><\/p>\n","protected":false},"excerpt":{"rendered":"
    Firebird and postgresql:http:\/\/www.linuxjournal.com\/node\/7010 Important comment: easy to migrate from oracle to firebird than to postgre or mysql. From interbase to firebird will be better as they are similar. http:\/\/forums.devshed.com\/firebird-sql-development-61\/mysql–vs–firebird-sql-62269.html : Firebird is far better choice than mysqlAs for Performance, MySQL will outperform Firebird on almost all tests on local machine……On a Network Server a properly … <\/p>\n
    Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1973,1917],"tags":[],"class_list":["post-69416","post","type-post","status-publish","format-standard","hentry","category-c-misc","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":69416,"position":0},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69412,"url":"http:\/\/bangla.sitestree.com\/?p=69412","url_meta":{"origin":69416,"position":1},"title":"Comparison: FireBird, MySQL, PostGreSQL #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"PosTGRESQL Provides better query responsetime than firebird and MySql. Firebird stands somewhere in the middle. A little longer response time than PostGreSql.http:\/\/benchw.sourceforge.net\/benchw_results_open3.html Several PostGreSQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_postgres_history.html Several MySQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_mysql_indexes.html A good comparison among these databases will be found at:http:\/\/www.geocities.com\/mailsoftware42\/db\/ Mentionable comments PostGreSQL Supports 400+GB DB.One\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69422,"url":"http:\/\/bangla.sitestree.com\/?p=69422","url_meta":{"origin":69416,"position":2},"title":"Speed: Firebird vs. PostGreSql #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Please read.According to this article postgresql faster than firebird. But I also got information\/tests where firebird is faster than postgresql. http:\/\/archives.postgresql.org\/pgsql-advocacy\/2003-06\/msg00280.php However, Speed may not be the only factor to select a database product. We can improve raw speed in many alternate ways, hardware solutions, ram, faster storage, faster CPU.\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69410,"url":"http:\/\/bangla.sitestree.com\/?p=69410","url_meta":{"origin":69416,"position":3},"title":"Firebird as an Alternative to Oracle\/MS SQL Server\/Interbase\/Access #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Note:Firebird can be a very good alternatives to Oracle\/MSSql Server\/Interbase. First of all, it is free. It can be good enough for upto medium level of enterprises. Supported database size is more than 11 terabytes. For a single table 20GB. It also implements ACID properties well enough. Implements two phase\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69424,"url":"http:\/\/bangla.sitestree.com\/?p=69424","url_meta":{"origin":69416,"position":4},"title":"FireBird GUI Tools #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"GUI Tools for Firebird DB management ------------------------------------CommercialThese are very good tools IBExpert - Developer Studio Interbase firebird development studio - develop\/design EMS sql mgmt studion for interbase\/firebirdails.html -- http:\/\/www.soft32download.com\/software\/EMS-SQL-Manager-2005-for-InterBase-Firebird-download-details.html xstarter FBIB - good management tools--scheduling of works -- http:\/\/www.xstarter.com\/firebird-interbase-job-scheduler.htmlFree----Development and Administration ToolsDbVisualizer Free JDBStudioibviewibexpert free personal edition limitedIBSQL not great\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69418,"url":"http:\/\/bangla.sitestree.com\/?p=69418","url_meta":{"origin":69416,"position":5},"title":"Why PostGress better than FireBird: This comparison may not be accurate though. #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Postgres Vs Interbase\/Firebird (Score:0) By Anonymous Reader on 2004.12.03 18:23 (#102740) http:\/\/www.vitavoom.com\/postgresql.htmlFirebird has not true text type you must use the clumsy blobs and weird blob subtypes.Postgres is much closer for enterprise use than Firebird.almost all of this applies to Firebird as well as interbase.PostgreSQL vs InterbasePostgreSQL... * ... has\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69416"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69416\/revisions"}],"predecessor-version":[{"id":78148,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69416\/revisions\/78148"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69416"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}