-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 MBR wrote: > The Open Source project BitPim uses SQLite.
I wrote that code. The rationale is at http://bitpim.svn.sourceforge.net/viewvc/bitpim/trunk/bitpim/dev-doc/database.html > In the output > I found numerous references to columns of type indirectBLOB. Generally the "indirect" is because the value is stored in another table. The BLOB bit is so that SQLite doesn't attempt to make any affinity conversions (it generally prefers to mangle things into integers which is fatal for phone numbers) . This is only deep and meaningful to BitPim itself. It has import and export functionality if you want the actual data. The SQLite database is structured so that Python dictionaries are can be used in the rest of the code. Each entry has arbitrary fields each of which can have any number of ordered values. Any entry can be looked up for any point in the past. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAknK1rcACgkQmOOfHg372QRZXgCglblMxRPuS4vxa+OCecDUV2mI 3UEAoIgP0TTe0TWSURFrYCTekOGi1h9x =Q1JI -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
