Drupal Databases: The Next Generation

Image by palestrina55 via Flickr

It sounds kind of like Star Trek, but trust me, this is a lot more exciting!  Drupal 7 will access databases using PDO (PHP Data Objects), which allows Drupal to support many different Database Servers in the future (and will bring us one step closer to Drupal running on a SQLite3 flat-file database, woohoo!).

A few people covered the patch arriving in core.  And now, even after this major 343.92 KB has been committed, there is still work to be done!  A task list posting on g.d.o lists 11 issues (both bugs and features) that now need to be implemented because this patch has hit core.  It feels like FormAPI all over again 🙂

Reblog this post [with Zemanta]
Show CommentsClose Comments


  • akahn
    Posted August 26, 2008 at 9:01 am 0Likes

    What is the advantage of using SQLite? I always thought the concept was neat but I don’t know what the actual advantages are over a traditional database server. Is it a performance benefit?

  • eatme
    Posted August 27, 2008 at 12:21 am 0Likes

    > Is it a performance benefit?

    Im pretty sure its a significant performance hit.

    But it will make deployment for small projects and quick tests insanely simple.

    You could also set up a drupal site on the free server space most ISPs provide.

  • Robin
    Posted August 27, 2008 at 6:51 am 0Likes

    There is an older speed test here: http://www.sqlite.org/speed.html

    That shows that sometimes SQLite is faster than MySQL. Remember, in the end MySQL is reading from disk as well, so, there isn’t much performance difference (blah, caching, blah blah blah).


  • kscheirer
    Posted August 27, 2008 at 4:54 pm 0Likes

    I think the reason people are excited about sql lite is that its entirely file-based, theres no server or process that needs to be running. So on a shared host, you just need to be able to write a file or two, and you can have you DB backend.

    generally sqlite is less powerful than mysql, but it can run really well in low-processing-power environments. That speed test is for fairly old versions of mysql and sqlite, I wonder what the current numbers are?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Our time: 6:29pm PDT