News for hackers. Stuff that matters.

A comment on SQLite as an Application File Format (2014). Parent comment

Re:SQLite as an Application File Format (2014) by out_of_protocol on Tuesday December 25, 2018 @03:08AM (#18756514)
Counterpoint: tiled maps, which are basically loads and loads of images, can be stored on disk as

- Direcory structure

- Zip file

- Tar file

- Sqlite db

Out of these, sqlite is the most compact, by far (also the fastest)

[ Parent | on HN ]
Re:SQLite as an Application File Format (2014) by fatboy on Tuesday December 25, 2018 @10:04AM (#18757647)
We just transitioned our tiled images from using a directory structure to SQLite.

Having a single file per very large image (for mobile) makes transferring them to the phone over USB around ten times as fast. I wish I’d done it years ago.

[ Parent | on HN ]