I just read through http://www.sqlite.org/datatype3.html, and it's now
starting to make sense to me. Wow! My mental model of what's going on
under the covers just underwent a major readjustment. Thanks for
pointing me at that page.
Mark
Griggs, Donald wrote:
> Hi Mark,
>
> There's a good reason for your difficulty -- Sqlite uses dynamic typing:
> http://www.sqlite.org/datatype3.html
>
> As far as I know, the term "IndirectBlob" is not defined within sqlite
> and is likely a term from the BitPim developers.
>
> Sqlite allows one to use most anything as a type -- "BlobThatAteNewYork"
> would work quite nicely.
>
> >From sqlite's point-of-view, if a BLOB contains structure, it's
> structure known only to the calling application.
>
> Hope this helps,
> Donald
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of MBR
> Sent: Wednesday, March 25, 2009 6:09 PM
> To: [email protected]
> Subject: [sqlite] Documentation on SQLite indirectBLOB?
>
> 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
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
