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 ]

sigzero (5768)

sigzero
  (email not shown publicly)

I am the proverbial "accidental" programmer. I have found that I really like Perl and programming so I am pursuing that route now. I am the Debian systems administrator and junior Perl programmer for a company called Inspire.

Journal of sigzero (5768)

Monday March 13, 2006
10:31 PM

How are you using SQLite?

[ #28982 ]

It occurred to me that there might be some surprising uses for SQLite in the Perl realm.

How are you using it?

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.
  • What about what I'd LIKE to do with it?

    What I'd like to have is the CPAN index available as a SQLite database, plus the CPANTS dependency maps, plus the CPAN Testers statistics.

    And then I want a Data::Package::SQLite class, that grabs all of these files every few days, lets me load them with a DBIx::Class loader, and work with them sanely.

    And then finally there might be a simple way to programmatically get access to all the CPAN metadata floating around, but which is most certainly not simple and easy to us
  • I use it for various things. Works well as a simple backend DB in Maypole, and various apps we use at work. I'm even considering using it as a configuration file format - but that's one of my more outlandish ideas...

    --
    -- "It's not magic, it's work..."
  • I wrote a web app for my wife to use and it needed a DB. It also needed to run on her Windows machine. My machine runs Debian (Ubuntu actually) so I was keen to use cross-platform components everywhere. I did the development and testing on Linux then installed the Apache+Perl+mod_perl+kitchen_sink for Win32 from Randy Kobes [uwinnipeg.ca] and the SQLite PPM from his repository on the target Windows machine. Everything Just Worked and setting up the database on Windows was a simple as copying one file from Linux

  • I'm using it to solve an interesting database scaling problem. Basically per-user quarantine storage for spam. This doesn't scale too well in a traditional database as you get a single index across one huge table clustered on (userid, column) and that index becomes very very hard to maintain and optimise. By giving every user their own DB I get around this issue, and it's very VERY fast.
  • sqlite3 the_house.db 'VACUUM;'