I know of two options: The proprietary https://sqlite.org/zipvfs/doc/trunk/www/readme.wiki and this extension that you have to call on strings yourself: https://github.com/siara-cc/Shox96_Sqlite_UDF
Furthermore, some filesystems allow transparent compression, like ntfs, bcachefs, zfs and btrfs. I have a 13GB DB that takes up 850MB on btrfs. Wout. On Wed, Apr 10, 2019 at 7:39 AM Peng Yu <pengyu...@gmail.com> wrote: > I have some TSV table in .gz format of only 278MB. But the > corresponding sqlite3 database exceeds 1.58GB (without any index). Is > there a way to make the database file of a size comparable (at least > not over 5 times) to the original TSV table in the .gz file? Thanks. > > -- > Regards, > Peng > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users