4

I have used PostgreSQL with small projects and MySQL is running in production environment. No issues with them. I have been hearing of Firebird which is again a solid RDBMS in the open-source area.

How reliable, ANSI-SQL compliant and stable it is when compared to PostgreSQL? How

Improve this question
1

1 Answer 1

Reset to default
6

FirebirdSQL is quite mature and reliable.

Its biggest weakness however (in my opinion) is the lack of a proper manual that covers all features of the current release. Currently if you want to know if a specific feature is available you first need to go through the Interbase manuals, than through the Firebird 1.0 release notes than the Firebird 1.5 release notes, than the Firebird 2.0 release notes and finally the Firebird 2.5 release notes (and 3.0 is more or less on the doorstep)

Btw: using a different DBMS in development than in production is usually a very bad idea. Especially if the development DB - as in your case - offers a lot more SQL features than the production DBMS.

Improve this answer
2
  • I beg to differ. Developing, at least partially, on a different DBMS keeps your code portable and stops you from using some non standardized/shared features.
    – Franz Kafka
    Commented Sep 5, 2012 at 14:01
  • 2
    @FranzKafka: why not used non-standardized features if they make your application faster or easier to develop? Trying to develop a DBMS independent solutions usually means the application runs equally slow on all platforms.
    – user1822
    Commented Sep 7, 2012 at 12:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.