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.
Re:SQLite small blob storage: 35% Faster Than the Filesystem
by justinclift on Friday June 16, 2017 @06:16AM
(#14567757)
As a data point, many of the links on that page to the mapbox.com website are 404. :(
Original post: https://developmentseed.org/blog/2010/oct/08/portable-map-ti...