On 13 May 2014, at 7:20am, Alain Meunier wrote: > I would like to know if some of you know a good compression tool to run with > sqlite. > > I worry about the size because other implementations (hamsterdb) shave approx > 40-50% of the sqlite size for the same datas. > > I saw about zipvfs but will it be maintained in the future ? Are there > efficient alternative ?
There are two versions of your question: one for compression of a database which is only going to be read from now on and another for compression of a database which has to support writing. hwaci, Richard Hipp's own company, support both ZIPVFS and CEROD: http://www.hwaci.com/sw/sqlite/zipvfs.html http://www.hwaci.com/sw/sqlite/cerod.html which do both things. Since the guy who runs that company is also the main man behind SQLite itself, there's a good chance that support will continue. When comparing database sizes and compression factors you should bear in mind that different DBMSs access data at different speeds and require more or fewer indexes to do it at the same speeds. In other words, publishing a simpler '40% of file size' doesn't tell the whole story. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
