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 March 13, 2002
07:23 AM

DBD::SQLite

[ #3482 ]

DBD::SQLite 0.11 is now on CPAN. This upgrades to SQLite 2.4.0, adding views and a few other niceties. I also had to fix the transaction model because running under mod_perl with Apache::DBI it continuously locked up solid. This was because under AutoCommit=0, I would immediately do a "BEGIN TRAN", which locked the database, and even when I issued a commit, it would do "COMMIT TRAN" followed by another "BEGIN" immediately. So now it only does "BEGIN TRAN" when you actually execte some SQL, and just flags whether I'm in a transaction or not. I believe this is how DBD::Sybase does it too.

I also found a couple of bugs in the core SQLite library, which I mailed the author about and he said he'd fix them in the next release (they're nothing major - just cause compiler warnings).


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

DBD::SQLite 8 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • I wonder what the performance is on huge (over 1 GB) unindexed tables, say using a basic 'select'.

    I also wonder if there are any free vector/text based solutions out there (besides csv/dbm).

    Thanks for the info. I *do* take interest in these posts, in case our Oracle server is taken from us. :(

    • I wonder what the performance is on huge (over 1 GB) unindexed tables, say using a basic 'select'.

      Why don't you find out for me?
      • Damn. I was hoping you already had something set up. :)

        If I get a chance, I'll give it a shot in the next couple of weeks.

        Oh, and in case anyone wants a rough comparison of an RDMS versus a commercial text-based solution (in our case, it was BRS by Dataware Technologies), we had eight databases joined, at roughly 4 GB per database, and I could get about 100,000 results in less than a second. With Oracle, I hit my IO limits on a single unindexed 1GB table before I get results.

        And you only think I'm e

  • Want me to make a PPM available for this? (I have a few already at the OI SF site [sourceforge.net].) I just built DBD::SQLite on NT 4.0 with VC++ and all tests passed, superfine. I'm getting ready to run the SPOPS tests using it as well, but I'm sure they'll be ok too.
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.