2012 LinuxQuestions.org Members Choice AwardsThis forum is for the 2012 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2012. This is your chance to be heard! Voting ends on February 4th.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
This was the year when I discovered some of the goodies PostgreSQL has to offer, like common table expressions (CTE), window functions, the variety of data types, and some really great extensions, e.g. hstore which allows to store a set of key/value pairs in a single column. Not to mention some other cool stuff like foreign data wrappers (allows to access some other data source like it was a table inside database), ability to write stored procedures in various languages (Python!), LISTEN/NOTIFY, etc, which I have yet to try.
I voted Firebird because it's a professional open-source RDBMS with a small footprint, good performance, very high level of SQL standards compliance, a great developer team, a very active and supportive user community, multi-platform availability, offering various client-server packages as well as an embedded engine (private to the process that loads it), and, and... Did I forget something? I'm sure I did!
MySQL. Why does everyone insist on choosing Firebird or PostgreSQL? I can't really say anything bad about either, since I haven't tried them yet.
If all you do is develop database applications for a living, you'd know exactly why Firebird is a better choice over MySQL. MySQL is fine for the odd database, but if your entire corporation depends on power & capability, IMHO Firebird is a MUCH better choice.
After finishing our 12th Firebird based medium-sized project, serving daily more than 8000 users online, handling a couple of TB data, i have no reason to find a better database backend for our solutions. Full-text search was something i missed, but then i solved the problem with an alternative way.
Last edited by Nagy Szilveszter; 12-23-2012 at 12:35 PM.