On May 4, 2005 09:31 pm, Henrik Bruun wrote: > Does Sqlite support reading/writing BLOB data in chunks? I'm > considering storing very large items (200MB+) in BLOB fields. Many > other DB libraries have ways to access these large binary items in > blocks and I was hoping Sqlite had such a facility too. Any > recommendations on realistic row size limits? I have found some > messages indicating the need to modify the *.h files to support larger > row sizes, again any recommendations. > > Henrik Bruun
Wouldn't the best method be to store the data on disk, and store the path to said file in a TEXT column? -- Thomas Fjellstrom [EMAIL PROTECTED]
