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 permited to a blob column ?
>
>Is there any recomendation on how could I store the files ? Split it
>into permited length pieces ?

Don't store the files in the Blob, just a 
absolute/relative path to the file or a 
compressed/zipped file. If you choose the 
compressed file, you can put in more than one 
file if you add the number of the file.

>Thanks in advance.

HTH

>-- João Macaíba.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to