Browse: Home / / Drupal Databases: The Next Generation

Drupal Databases: The Next Generation

By Robin Monks on August 24, 2008

Peggy's Cove harbour #1Image by palestrina55 via Flickr

It sounds kinda 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]
  • Share/Bookmark

Posted in | Tagged , , , , | 6 Responses

6 responses to “Drupal Databases: The Next Generation”

  1. Drupal Databases: The Next Generation
    Drupal Databases: The Next Generation
    August 24, 2008 at 9:53 pm |

    [...] Go to the author’s original blog: Drupal Databases: The Next Generation [...]

  2. akahn
    akahn
    August 26, 2008 at 9:01 am |

    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?

  3. eatme
    eatme
    August 27, 2008 at 12:21 am |

    > 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.

  4. Robin
    Robin
    August 27, 2008 at 6:51 am |

    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).

    Robin

  5. kscheirer
    kscheirer
    August 27, 2008 at 4:54 pm |

    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?

  6. Drupal Published Date equals Effective Date fix | Elastic Life
    Drupal Published Date equals Effective Date fix | Elastic Life
    December 28, 2008 at 7:14 pm |

    [...] Drupal Databases: The Next Generation [...]

Leave a Reply