← Back to context

Comment by lateforwork

3 months ago

It can be compressed, see https://sqlite.org/sqlar.html

Please do not use second resolution mtime (cannot represent the high accuracy mtime that modern OSs use, so packing and unpacking , or causes differences eg in rsync), or build anything new using DEFLATE (it is slow and cannot really be made fast).

This seems completely orthogonal? This is an alternative to zip and tar built on SQLite:

> An "SQLite Archive" is a file container similar to a ZIP archive or Tarball but based on an SQLite database.

Your parent comment said that when you're using SQLite as an application format, the content in the database don't get compressed. These two things have nothing to do with each other.