SQLite Archive Files

9 hours ago

SQLite Archive is a file container based on SQLite database, storing files in a table with fields for name, mode, mtime, size, and data (usually compressed with Deflate).
It treats the database as a single file object, making it portable and usable as a queryable wire-transfer format, unlike client/server databases.
Key advantages include flexibility to store relational data, transactional updates, incremental modifications, SQL querying, and potential to bypass firewall censorship.
It is supported by SQLite CLI tools (sqlite3.exe) for management, and applications can use extensions like sqlar.c for compression/decompression functions.
Disadvantages include larger size compared to ZIP or Tarballs (about 1% bigger than ZIP), limited to Deflate compression, and being a newer, less-known format.
Example usage includes creating, listing, and extracting archives via command-line options, with applications able to insert or extract records using SQL functions.

Hasty Briefsbeta