Thanks, now I now that someone's done it, so perhaps will attempt
something similar on my own :-) Your encode/decode functions - are they
the same as in SQLite v2?

Regards, 

   Dennis

// MCP, MCSD
// Software for animal shelters
// http://www.smartpethealth.com

-----Original Message-----
From: Miguel Angel Latorre [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 22, 2004 6:10 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Compress/uncompress inline

I've done it adding some compression user functions, compress and
decompress (using zlib), also the encode and decode binary functions
were added so I could throw some sql in ascii and have the engine
compress it:
for example:
insert into table (field1) values (compress (decode (ascii data)))

----- Original Message -----
From: "Dennis Volodomanov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 22, 2004 1:39 AM
Subject: [sqlite] Compress/uncompress inline


Hello all,

Is it possible to have some sort of a zip-unzip (compress-uncompress)
function built-in when writing/reading the SQLite v3 databases, like the
encode()/decode() functions were in v2? Has anyone implemented this? Is
it available, for example, like the encryption at a charge?

If nobody implemented this, could you please point out to me what should
be modified to add compress-uncompress code, i.e. at which stage should
this be done?

Thanks in advance,

   Dennis

// MCP, MCSD
// Software for animal shelters
// http://www.smartpethealth.com




Reply via email to