News for hackers. Stuff that matters.
Re:SQLite small blob storage: 35% Faster Than the Filesystem by incanus77 on Wednesday June 14, 2017 @01:22PM (#14554273)
Also, to clarify a bit on why spatial capabilities weren't part of the MBTiles spec: when rendering maps, you assemble tiles for a given zoom scale in the vertical and horizontal directions, like a checkerboard. The unique tuple defining a particular square on the map is z/x/y — zoom level, horizontal, vertical. So stuffing these into SQLite and uniquely keying across z/x/y there makes for fast retrieval at render time.

There are no comments on this comment yet.