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)

Wednesday July 21, 2004
04:22 PM

In Prep for TPC...

[ #19982 ]

I thought I'd bring you all this gift:

The uploaded file
 
    DBD-SQLite-1.00.tar.gz
 
has entered CPAN as
 
  file: $CPAN/authors/id/M/MS/MSERGEANT/DBD-SQLite-1.00.tar.gz
  size: 423215 bytes
   md5: f45880ccd6dffe8bd2c785e0c064a02a
 
No action is required on your part
Request entered by: MSERGEANT (Matt Sergeant)
Request entered on: Wed, 21 Jul 2004 21:18:42 GMT
Request completed:  Wed, 21 Jul 2004 21:19:34 GMT
 
Thanks,
--
paused, v460

Changes:

1.00
        - Port to sqlite3 API
        - Support bind types SQL_BLOB, SQL_NUMBER, SQL_TEXT etc
        - Support $dbh->last_insert_id()
        - Added timeout API

(I forgot to document the timeout API though - oops)

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.
  • Won't this break all the aplications that install DBD::SQLite off of cpan and expect it to be able to read a version 2 database?
    • Yup! I just upgraded from .27 to 1.0, hoping to solve a sqllite/Moveable Type bug, and.... well, I'm glad I exported my postings first! Question: Are there any utilities for converting version 1 dbs?
      • This document [sqlite.org] on the sqlite website that was linked to in a previous journal entry seems to suggest:
        sqlite OLD.DB .dump | sqlite3 NEW.DB
        • Isn't the point of sqlite the fact that it's embedded? Because I don't seem to have any sqlite command line on my server. (I am, of course, now in the process of installing one).
        • OK, it's not that hard. Here's a few more of the steps on a linux machine:

          go to sqlite.org and download sqlite v.3 from

          http://www.sqlite.org/download.html

          Download version 2 as well

          gunzip sqlite*.gz

          copy sqlite3-3.0.3.bin to /usr/bin as sqlite3

          copy sqlite-2.8.15.bin to /usr/bin as sqlite

          chmod 755 sql*

          Then, with the two different programs properly named, the command above works quite well:

                    sqlite OLD.DB .dump | sqlite3 NEW.DB
    • That's why there are big warnings when you run Makefile.PL if you have <1.0 installed.

      There's little else I can do without investing a HUGE amount of time into it, and nobody is paying me to do that :-)
      • Yup, I saw the warnings. That's why I made sure to export my databases so it wasn't a total disaster :-) Since the translation to the new format is relatively simple (now that I've figured it out), maybe a web page with simple upgrade instructions and more detailed warnings could be set up? Something along the lines of CAUTION: Upgrading will make previous databases unreadable without manulal intervention. See http://sqlite.perl.org for details. I'll volunteer to write a draft of the web page if you thi
      • Oops! Bad formatting. I meant to say this:

        Yup, I saw the warnings. That's why I made sure to export my databases so it wasn't a total disaster :-)

        Since the translation to the new format is relatively simple (now that I've figured it out), maybe a web page with simple upgrade instructions and more detailed warnings could be set up? Something along the lines of

        CAUTION: Upgrading will make previous databases unreadable without manulal intervention. See http://sqlite.perl.org for details.

        I'll volunteer to
  • Running MT 2.66 with DBI::SQLite 1.0 screws the dates all up.

    This is true whether I create a new database or upgrade from an old database.

    Take a look at http://www.demsformars.com/ and you'll see some truly amazing dates.