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

use Perl Log In

Log In

[ Create a new account ]

Matts (1087)

Matts
  (email not shown publicly)

I work for MessageLabs [messagelabs.com] in Toronto, ON, Canada. I write spam filters, MTA software, high performance network software, string matching algorithms, and other cool stuff mostly in Perl and C.

Journal of Matts (1087)

Friday July 16, 2004
08:38 AM

DBD::SQLite 3.0

[ #19884 ]

All tests successful.
Files=24, Tests=355, 6 wallclock secs ( 3.12 cusr + 0.91 csys = 4.03 CPU)

Woot!

Now I'm going to extend it a bit - SQLite 3.0 allows some nice things like busy handlers which I'd like to add before release.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 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?