The Open Source project BitPim uses SQLite. I'm trying to examine the
database BitPim creates. At http://www.sqlite.org/download.html I found
sqlite-3_6_11.zip, which is a pre-compiled Windows command-line SQL
interface.
I ran:
sqlite3 bitpim.db
then typed:
.dump
and saved the output to see what's in the database. The result is a set
of SQL queries that can be used to recreate the database. In the output
I found numerous references to columns of type indirectBLOB. When I
look at the data that gets inserted into those columns, it's pretty
clear that the value in those columns is of the form:
/tableName/,/recordId/,/recordId/,...
But I've been unable to find documentation on the keyword 'indirect' or
'indirectBLOB' anywhere on the web, including
http://www.sqlite.org/docs.html. Can anyone here tell me where to find
that documentation?
Mark Rosenthal
[email protected] <mailto:[email protected]>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users