use Perl

• insert id (Score:2)

  by Juerd (1796)

  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.
  • Re:insert id (Score:2)

    by Matts (1087)

    Err, any idea how I do that? The DBI::DBD docs don't say anything about it.
    • Re:insert id (Score:2)

      by Juerd (1796)

      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
      • Re:insert id (Score:2)

        by Matts (1087)

        Got it working. Thanks.
• This is going to help me (Score:2)

  by jdavidb (1361)

  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
  • Re:This is going to help me (Score:2)

    by Juerd (1796)

    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,}
• Far out (Score:1)

  by zatoichi (4897)

  Where do I send the check?