Pickle > Shelve > Small SQL Databases

[Tim Roberts]

Gerhard Häring <gerhard.haering at gmx.de> wrote:
>
><plug>
>PySQLite might perhaps be an even better option, it's embedded (no
>server), it's reasonably fast, and it supports more than just the most
>basic SQL, unlike some other popular RDBMS installed at web hosts ;-)
>
>http://pysqlite.sf.net/
></plug>

Hey, that is a very cool product!

I had not encountered SQLite before.  I downloaded it just to take a peek,
and I noticed the doc said that the DML was mostly compatible with
Postgres, so I took a dump of my non-trivial Postgres database and fed it
directly into SQLite.  As the README said, it objected to a few PG syntax
extensions, but to my rather great surprise, it basically sucked up the
whole database.  It imported all the tables and all the data, and I was
able to perform some rather sophisticated queries without trouble.

I'm very impressed.  It took a long time to do the import, but the
resulting data file was much smaller than my PG files.  I can think of a
number of interesting applications for this.

Thanks for the pointer.
--
- Tim Roberts, timr at probo.com
  Providenza & Boekelheide, Inc.