Re: [sqlite] Compress/uncompress inline
Yes, they do not add up much to the original size in bytes, but any encoding function would make it (like encoding into hex). - Original Message - From: "Dennis Volodomanov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 23, 2004 1:38 AM Subject: RE: [sqlite] Compress/uncompress inline 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
RE: [sqlite] Compress/uncompress inline
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
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
[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