The thread is on joelonsoftware.com and the question is about open source databases :
Quick issue, everyone. My company currently uses SQL Server, but we’re going to look at open-source databases because of MS’s crooked licensing rules (to be honest, they only have one SQL license, and are running it on a two-processor machine). They don’t want to shell out the extra $6,000 for another one, and I don’t blame them.
We need a reliable database for handling lots of data (e-commerce site with about 70,000 products). The ability to use stored procedures is a big thing. Although it’s not a huge deal, it’d be nice to be able to automate jobs for maintenance/updating (product stock, for example). I’m aware of both MySQL and Postgres, and a few others that don’t seem to be “enterprise-ready” as it were (Firebird? SqlLite?).
« Hide it
Here is the full thread on nhibernat and the quote
“However, the thing that finally made us switch from SQLite to Firebird was the fact that it only support one open transaction at a time. This makes it essentially useless for multithreaded/multiuser applications. SQLite is excellent for some tasks, but if you have more than one thread/process accessing the database at the same time you really should consider using another database. ”
This post wants to be:
1. A quick glance at the new “common table expression” (aka hierarchical queries) in Firebird 2.1
2. A call to action for other opensource databases
Times of change are upon the database market. The major established database companies are being challenged by open source upstarts like MySQL and PostgreSQL. [Add firebird to the list too]
Use Firebird SQL Server, if you have the luxury to choose among many database systems.