Re: [sqlite] Binary data in SQLite3

2007-02-19 Thread jose isaias cabrera


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

2007-02-19 Thread jose isaias cabrera


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

2007-02-18 Thread Roger Binns
-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

2007-02-18 Thread P Kishor

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

2007-02-18 Thread jose isaias cabrera


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]
-