Re: [sqlite] Binary data in SQLite3
Thanks. - Original Message - From: "Roger Binns" <[EMAIL PROTECTED]> To: Sent: Monday, February 19, 2007 1:51 AM Subject: Re: [sqlite] Binary data in SQLite3 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 jose isaias cabrera wrote: Can SQLite3 save binary data? http://sqlite.org/datatype3.html Look for blobs. I would like to save zip files on it. Is this possible? Yes. There is a limit of 2GB per item and there is no random access api to retrieve part of a blob - you have to get the whole thing in one go. In general better practise is to store the zip files in the filesystem and store the name of the file in SQLite. If so, is there a place where I can read or get some examples about it? Blobs are just another SQLite datatype so you manipulate them in exactly the same way as you do other types. http://sqlite.org/docs.html The topic also comes up fairly frequently on this list. You can examine the list archives for previous discussion. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFF2Uj0mOOfHg372QQRAhPJAKDY/M/aash7JD7xlOGp0m/xwwHbjgCeJXj9 kiUUCu+a/POfb1PzP4Nf3Yw= =Tb74 -END PGP SIGNATURE- - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Binary data in SQLite3
thanks. - Original Message - From: "P Kishor" <[EMAIL PROTECTED]> To: Sent: Monday, February 19, 2007 1:36 AM Subject: Re: [sqlite] Binary data in SQLite3 On 2/19/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: Greetings! Can SQLite3 save binary data? I would like to save zip files on it. Is this possible? If so, is there a place where I can read or get some examples about it? blobs http://www.sqlite.org/datatype3.html -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ - collaborate, communicate, compete = - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Binary data in SQLite3
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 jose isaias cabrera wrote: > Can SQLite3 save binary data? http://sqlite.org/datatype3.html Look for blobs. > I would like to save zip files on it. Is > this possible? Yes. There is a limit of 2GB per item and there is no random access api to retrieve part of a blob - you have to get the whole thing in one go. In general better practise is to store the zip files in the filesystem and store the name of the file in SQLite. > If so, is there a place where I can read or get some > examples about it? Blobs are just another SQLite datatype so you manipulate them in exactly the same way as you do other types. http://sqlite.org/docs.html The topic also comes up fairly frequently on this list. You can examine the list archives for previous discussion. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFF2Uj0mOOfHg372QQRAhPJAKDY/M/aash7JD7xlOGp0m/xwwHbjgCeJXj9 kiUUCu+a/POfb1PzP4Nf3Yw= =Tb74 -END PGP SIGNATURE- - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Binary data in SQLite3
On 2/19/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: Greetings! Can SQLite3 save binary data? I would like to save zip files on it. Is this possible? If so, is there a place where I can read or get some examples about it? blobs http://www.sqlite.org/datatype3.html -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ - collaborate, communicate, compete = - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Binary data in SQLite3
Greetings! Can SQLite3 save binary data? I would like to save zip files on it. Is this possible? If so, is there a place where I can read or get some examples about it? Thanks. josé - To unsubscribe, send email to [EMAIL PROTECTED] -