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: mysql
Data load speed test , Mysql vs Firebird
Take an Open Source Database Survey
Do you know which open source feature is the most important? Do you know which open source database rocks and which one sucks? Is MySQL better than Postgres? Is Ingres worth considering? How does Firebird compare? Have you used, or have you considered using, an open source database?
Take a survey. It’s only 15 questions so it takes just a few minutes.
I’ll post a link where you can get the results once they have been compiled and prepared.
Sun to Begin Close Sourcing MySQL – time for alternatives like firebird
“From the MySQL User’s Conference, Sun has announced, and former CEO Marten Mickos has confirmed, that Sun will be close sourcing sections of the MySQL code base.”
Read the rest of the article on slashdot
There are many posts about firebird too
Also another interesting blog about this community split
The fastest way to insert 100K records
I’m doing some performance tests today with our three different database backends: MySql, Firebird and SQL Server.
Firebird vs Postgresql
We have similar databases running on MySql, Postgresql and Firebird. One of the reasons for moving away from MySql was that the UTF8 support didn’t work properly.
Read the rest of the article here http://nikolajlindberg.blogspot.com/2008/03/firebird-vs-postgresql.html
LIMIT in SELECT statements in Firebird
The question is, is there a MySQL/PostgreSQL equivalent of LIMIT clause in Firebird?
Choice between MySQL and Firebird? – post of the day
Which one of the two would you choose and why?
Playing with Django and Firebird
I’ve been messing around with Django for a while now and having fun. It reminded me of why and how I got started in this field.
[ED:There is an nice firebird mention ]
Using Apache, Webware and Firebird as the database I set out to build something.
Firebird? Yes anything to avoid the MySQL bandwagon. I couldn’t say for sure now, but at the time Firebird was far superior to MySQL. The Firebird team didn’t think that ACID properties, foreign key constraints, stored procedures etc. were just some esoteric optional extras for something with pretensions to being an RDBMS.
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) ]