https://softwarerecs.stackexchange.com/questions/45010/transparent-file-compression-apps-for-macos
I work on Mac. Would this be worthwhile to try? Does the transparent compression work at the file system level or at the directory level? Would it have a slight chance to corrupt the existent files on the disk (e.g., power outrage during compression)? On Wed, Apr 10, 2019 at 11:02 AM Wout Mertens <[email protected]> wrote: > As I said in my previous email, I have a 13GB database that transparently > compresses to 800MB. Not sure if it got through, didn't get replies to my > last two emails. > > Wout. > > On Wed., Apr. 10, 2019, 5:04 p.m. Warren Young <[email protected]> wrote: > > > On Apr 9, 2019, at 11:39 PM, Peng Yu <[email protected]> wrote: > > > > > > 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? > > > > Transparent file compression is a feature of several filesystems: NTFS, > > ZFS, Btrfs, and more: > > > > > > > https://en.wikipedia.org/wiki/Comparison_of_file_systems#Allocation_and_layout_policies > > > > If you can enable this feature on your existing system or switch to one > of > > the filesystems that do support it, you don’t need a non-default SQLite > > configuration. > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Regards, Peng _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
