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