Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

DBD::SQLite 3.0 7 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Can you please also implement the new last_insert_id thing that DBI has? I know there is already a func thing that you can use, but it's nice to have something that works with multiple DBDs.
    • Err, any idea how I do that? The DBI::DBD docs don't say anything about it.
      • I don't know exactly (familiar with neither C nor DBI's internals), but at least DBD::mysql and DBD::Pg implement it. grep its tree for dbd_db_last_insert_id.

        See also http://groups.google.com/groups?selm=20030307221500.GQ352%40dansat.data-plan.com

  • Maybe not today, but I know that for new projects I'll definitely choose the newer version. I'm not sure I'd want to move existing projects there due to file format issues (how did you address that, btw? or did you?).

    Haven't gotten to use SQLite at work as much as I might have liked, but I've been using DBD::SQLite extensively for my master's thesis work. As I said before, I owe you a nice meal.

    --
    J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
    • I'm not sure I'd want to move existing projects there due to file format issues.

      Converting an SQLite 2 database to SQLite 3 is a matter of doing: sqlite foo.db .dump | sqlite foo.db.new; mv foo.db{,.old}; mv foo.db{.new,}
  • Where do I send the check?
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.