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 manigandham on Tuesday December 25, 2018 @12:57AM (#18756175)
That's your call. If you're going to be storing 100gb of images then put them somewhere else, but this post is about using SQLite as a file format so storing binary files inside is not a problem.
[ Parent | on HN ]
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 ]