Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
    
stackoverflow.com/questions/1635273/postgres-vs-firebird or Google "postgres vs firebird" –  DrColossos Jul 24 '11 at 12:40
add comment

1 Answer

up vote 5 down vote accepted

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.

share|improve this answer
    
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 Sep 5 '12 at 14:01
    
@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. –  a_horse_with_no_name Sep 7 '12 at 12:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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