[conspire] Fun from Oracle, or: is it time to switch from MySQL to Postgres?

Rick Moen rick at linuxmafia.com
Wed Mar 7 13:57:46 PST 2012

Quoting Adrien Lamothe (alamozzz at yahoo.com):

> Just installed the latest Debian MySQL updates and was shown the
> following public service announcement. I'm glad Ruby on Rails makes it
> so easy to switch databases; looks like it may be about time for
> Postgres.

Depending on your needs, there are two other easier and more natural
migration targets:

MariaDB:  Extremely compatible community branch (as opposed to fork) of MySQL
and lead-maintained by Monty Widenius, architect/founder of MySQL.  They
maintain ongoing high compatibility and make sure they are a drop-in
replacement.  Adds XtraDB and Aria storage engines.  GPL v. 2.

Drizzle:  Lightweight and simplified ('slimmed down') fork of MySQL 6.0
from mid-2008 by Brian Aker.  Features removed:  Stored Procedures,
Views, Triggers (well, not entirely), Query Cache, and Prepared
Statements.  Simplified set of field types.  GPL v. 2 & 3, BSD licence.

I'm intending to move my server's very minimal database functions for 
some Web pages (mostly BALE) over to Drizzle as soon as I can test it.

Not that there's ever been anything wrong with PostgreSQL, which has
long been excellent.

More information about the conspire mailing list