Re: [sqlite] blob :: storing files within sqlite3

2008-04-24 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 João Macaíba wrote: > I've installed sqlite3 through a binary package. How can I know what is > the maximum length permited to a blob column ? The sqlite3_limit C api can tell you (introduced in 3.5.8). Unless compiled with a non-default value for

Re: [sqlite] blob :: storing files within sqlite3

2008-04-24 Thread Eduardo Morras
At 09:57 24/04/2008, you wrote: >Hi. > >I intend to use sqlite3 to store files. > >I've tested inserting an 7.6MB file in a blob column but it returns a >SQLite3::TooBigException. I'm using ruby API. > >I've installed sqlite3 through a binary package. How can I know what is >the maximum length

Re: [sqlite] blob :: storing files within sqlite3

2008-04-24 Thread John Stanton
My guees is that you have encountered a limitation in the Ruby wrapper. Can you write the BLOB in chunks using your interface? João Macaíba wrote: > Hi. > > I intend to use sqlite3 to store files. > > I've tested inserting an 7.6MB file in a blob column but it returns a >

[sqlite] blob :: storing files within sqlite3

2008-04-24 Thread João Macaíba
Hi. I intend to use sqlite3 to store files. I've tested inserting an 7.6MB file in a blob column but it returns a SQLite3::TooBigException. I'm using ruby API. I've installed sqlite3 through a binary package. How can I know what is the maximum length permited to a blob column ? Is there any