Choice between MySQL and Firebird? – post of the day
Which one of the two would you choose and why?
Tag: mysql
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) ]
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
Sun, MySQL and the return of integrated solutions
Post in ZDNet mentions Firebird. Check the excerpt from the full article:
There are many open source projects that offer respectable database technology including Axion, Firebird, MaxDB, PostgreSQL, Ingres and quite a number of others including an old friend, MUMPS (I was a software engineer at a company that created MUMPS-based solutions in the late Jurassic period)! If Sun tries to “squeeze” the users of MySQL, it is likely that these organizations will simply move to another platform and say goodbye to MySQL and Sun. Do you agree with my line of reasoning?
Sun buys MySQL
Sun Microsystems Announces Agreement to Acquire MySQL. More information here.
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. Read more
Firebird is the best in embedded area
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. ”
Open Source Code Contains Security Holes – Firebird moribund ??
From the FUD department Here is one sponsored article
The somewhat moribund Firebird project, for example, is listed with 195 identified defects, of which it has verified zero and fixed zero