Database identifiers, quoting and case sensitivity
Exploring database delimited identifiers and case sensitivity: the effect of quoting table and field names in the various DBMS.
Article by Lorenzo Alberton
Tag: oracle
Dot Net Performance of Firebird 2.1
Comparing the performance of several operations in FB2.1, OraXE and SQLServerXE using the vendor specific .NET data access drivers, I discovered Firebird was about 3 times faster than the others which were both nearly the same speed.
Me on Marc Fleury on Sun purchase of MySQL – replaceable lamp bricks
The last post was supposed to be this one, but I got distracted on how I found it
“Whether you’re using Postgres, SQLite, Oracle, Microsoft SQL Server, HSQLD, Firebird, Derby, or whatever, you’re benefiting from the popularity of MySQL. If you’re still using Progress, dBase, or Sybase, maybe not.
My point is that MySQL did for databases what Netscape did for the internet, what Apache did for web servers, what Star Office did for alternate word processors, what Sendmail did for email servers, and what JBoss did for J2EE.”
[ED Here is my reply :Bricks can be replaced in the lamp
Why they always forget the MTA or DNS?
They are critical parts of the clusters
Sendmail is replaced by postfix or qmail if you are a sane person (in ubuntu postfix is by default)
Apache is replaced by lighttpd and nginix – better webservers IMHO
mysql by firebird or postgresql
linux kernel is good enough and is better than win or solaris (if you want wamp or samp)
php can be replaced by ruby or perl or python (if it becames bloated like java in version 6.x) ]
MySQL, Oracle, DB2, PgSQL and Firebird versus Leap Years and Division by Zero
Some Leap Years and Division by Zeoro example in different database systems
Evaluating open-source DBs -Firebird Enterprise ready ?
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.
New challenges, new synthax
Are Proprietary Databases Doomed?
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]
Facts about databases – blog post of the day
Use Firebird SQL Server, if you have the luxury to choose among many database systems.