DBD::SQLite: Migration to SQLite 3.0

From: Matt Sergeant (matt_at_sergeant.org)
Date: 07/17/04

  • Next message: Jeff Zucker: "Re: DBD::SQLite: Migration to SQLite 3.0" 
    To: dbi-users@perl.org
Date: Sat, 17 Jul 2004 10:51:55 +0100

    Hi guys,

    Anyone who has read my journal will know that I now have DBD::SQLite
    ported to SQLite 3.0, which provides better datatypes, better
    concurrency, proper blob support, etc.

    Now the big problem is that sqlite 3.0 is incompatible with sqlite 2.x
    (which the current CPAN version of DBD::SQLite is based on), and if you
    try and open an old database it will fail horribly. So we have an
    upgrade problem.

    Potential solutions:

      - Rename it DBD::SQLite3. I don't like this solution because the API
    remains the same, and so anyone who wants to upgrade will have to
    change their code. This is specially relevant for CPAN modules which
    use DBD::SQLite.

      - Provide some sort of porting tool. Not sure the best way to do this
    - the sqlite docs recommend just doing a dump from the old format and
    an import into the new, but that will require both versions installed.

      - Ignore the problem - it might be painful for the few people who use
    DBD::SQLite, but it's a one-time pain.

      - Provide lots of warnings if Makefile.PL detects an old version
    installed. This is my favoured solution, not least because it means
    minimal work for me (if you suggest an alternate solution do bear this
    in mind - I do this stuff for free).

    What are your thoughts?

    Make sure you CC me in all replies as I don't subscribe, but keep posts
    on-list so they are archived.

    Matt.

  • Next message: Jeff Zucker: "Re: DBD::SQLite: Migration to SQLite 3.0"

    Relevant Pages