Aug 20

Important Links for Mysql, PostGreSQL, Firebird, EnterpriseDB, Ingres #2

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 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 …..

This link also compares fb with potgre and favors fb as the author’s background is borland

Why Postgress is better than firebird

Firebird is not as good as PostgresQL (Score:0) By Anonymous Reader on 2004.12.03 2:21 (#102703) And here is why:

  1. Firebird has no temp table support.

  2. 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.

  3. Firebird databases grow out of control and have to be backed up restored on a regular basis.

  4. 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.

  5. 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.

  6. Postgres has many rich procedural languages including perl,TCL,Java and C# in the works.

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.

I converted all my apps from Firebird 1.5 to Postgresql 7.4 and I would never use Firebird again on Unix or Windows

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

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>