Hello!
В сообщении от Tuesday 20 January 2009 12:24:41 [email protected] написал(а):
> For now we are just wondering how to use SQlite facilities, and if it's
> not sufficient, maybe we would think of the opportunity to developp a tiny
> compression algorithm by ourselves, or not... There is no requirement of
> on-the-fly compression / decompression because it's for archive only
> (fortunately !).
You can build SQLite with zlib and are using compress/uncompress sql functions.
sqlite> select uncompress(compress('A same very big string'));
A same very big string
I did reduce my databases more then 2x by using compression for one or two
fields. Of cource resuilt
is dependent of your dataset.
Best regards, Alexey.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
