It is far cheaper and much more reliable to just buy some file storage space.
Last I looked 4 TB of NVMe is about $1,000.00. This is not the old days when a 5 1/2 inch full height 40 MEGABYTE drive cost a bundle. Geez, I remember when I got a bunch of CDC Wren IV 300 MB drives at the whopping 50% discounted price of $6,000.00 each. Compsurfing those dozen drives shook the building for two weeks! Nowadays one can procure 100 TB of RAID-6 for about the price of one of those Wren IV drives... Why would anyone fart about with added complication and the concomittant increased unreliability when storage is so damn cheap? --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Warren Young >Sent: Wednesday, 10 April, 2019 09:05 >To: SQLite mailing list >Subject: Re: [sqlite] compressed sqlite3 database file? > >On Apr 9, 2019, at 11:39 PM, Peng Yu <pengyu...@gmail.com> 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_a >nd_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 >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