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

Reply via email to