I’d argue that Sun needs to tighten the reins on MySQL development, not let them go. Going forward, MySQL will need to work hard if it wants to stay in front of the low-end database business. It’s no longer the reigning speed king; if fast, SQL-based storage is all you care about, SQLite is a better alternative. And competing open source databases like PostgreSQL and Firebird offer better feature sets for exactly the same price as MySQL.
Read full article in Infoworld.
Exploring database delimited identifiers and case sensitivity: the effect of quoting table and field names in the various DBMS.
Article by Lorenzo Alberton
I’ve run some data load tests with various databases using DBMonster, so connecting to databases through JDBC on a WindowsXP personal computer.
Here are the results, in both cases I loaded 100 rows in the parent table and 1000 in the child table, with foreign keys enabled.
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.
“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
I’m doing some performance tests today with our three different database backends: MySql, Firebird and SQL Server.
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
The question is, is there a MySQL/PostgreSQL equivalent of LIMIT clause in Firebird?
Which one of the two would you choose and why?
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.