Drizzle Wants to Make MySQL Sizzle
There’s some potentially interesting changes coming to the world of MySQL. And no, it’s got nothing to do with the recent acquisition by Sun Microsystems.
Drizzle is a new project from Brian Aker, MySQL’s director of architecture, which aims to take MySQL and strip out the fat, leaving a faster InnoDB and UTF8-supporting database designed for today’s web apps.
Drizzle will get rid of query caches, stored procedures, permissions, views, and triggers; it will offer only simplified field types and it will be optimized for the small subset of features that are commonly used in web apps.
It isn’t intended to replace MySQL, but it could end up being, as Simon Willison suggests, MySQL’s Firefox.
Today’s web apps are generally written with frameworks like Ruby on Rails, Django and the like, all of which include things like sanitized database queries and more. So bother with prepared statements or other expensive (performance-wise) database server tools?
The project is still young and there’s no code to download yet, nor any hard and fast performance numbers, but it definitely looks like one to keep an eye on.