Java JDBC using SQLite/Working with BLOBs

From Wikibooks, open books for an open world
< Java JDBC using SQLite
Jump to: navigation, search

Storing and retrieving binary large objects, BLOBs, from SQLite is perhaps one of the more problematic areas of SQLite itself since early versions had no direct access mechanism for this, and very little in the way of support functionality. However, BLOBs, by their very nature, can be stored and retrieved programmatically since they are, after all, nothing more than suitably arranged byte arrays. Previously, the biggest limitation was in the size of a data row in versions of SqlLite prior to 3.0 which was set at a meagre 1 MB. Versions 3.0 and higher have no such limitation.

Preparation of a table space[edit]

Insertion of BLOBs[edit]

Retrieval of BLOBs[edit]

Other considerations[edit]

{to be continued Sjc (talk) 19:33, 7 October 2009 (UTC)}