Hi all,
No offense meant, I respect people's choices and this is just a question.
Many forum users seem to choose (or consider doing so) Firebird. I have been using MySQL and PostgreSQL (both open source) for years and I cannot help but wonder, why Firebird? While one could argue that the future of MySQL is uncertain given it's potential acquisition by Oracle, PostgreSQL is available under a BSD license and is a well established SQL RDBMS.
While I was writing an application for easily accessing MySQL, PostgreSQL, and Firebird using the same ZeosLib interface I noticed that: (1) there are differences between the Firebird protocol in successive minor releases; (2) there are differences between the SQL language used in Firebird vs. MySQL and PostgreSQL; and (3) regular expressions are unavailable in Firebird 2.1 (should be in 2.5). Bottom line, Firebird seems to be (still) under heavy development.
Why would you choose Firebird rather than MySQL or PostgreSQL for your Lazarus/FPC applications?
Any constructive response is greatly appreciated.