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