News for hackers. Stuff that matters.
Re:SQLite small blob storage: 35% Faster Than the Filesystem by asmosoinio on Wednesday June 14, 2017 @12:41AM (#14550693)
Interesting and very relevant to the discussion!

Hmm... Does SQLite have some geo data or 2d coordinate lookup capabilities as well?

Re:SQLite small blob storage: 35% Faster Than the Filesystem by shawn-butler on Wednesday June 14, 2017 @03:01AM (#14551113)
Try SpatialLite[0] if you need advanced geometry capabilities. Has R-Tree spatial indexes if you use SQLite 3.6+, and rudimentary MBR index for prior versions. Has rudimentary support for curves as well.

[0]: https://www.gaia-gis.it/fossil/libspatialite/index

Re:SQLite small blob storage: 35% Faster Than the Filesystem by justinclift on Wednesday June 14, 2017 @06:06AM (#14551666)
As a data point, one of our users figured out how to load the SpatiaLite extension for DB Browser for SQLite (on Windows), then wrote up step by step instructions:

https://github.com/sqlitebrowser/sqlitebrowser/wiki/SpatiaLi...

(people had been asking previously, but we had no idea. ^\o/^)

Re:SQLite small blob storage: 35% Faster Than the Filesystem by i_feel_great on Wednesday June 14, 2017 @01:04AM (#14550751)
There is some mention of that here: https://www.sqlite.org/rtree.html
Re:SQLite small blob storage: 35% Faster Than the Filesystem by mynewtb on Wednesday June 14, 2017 @02:53AM (#14551075)
GeoPackage is a great geodata format on sqlite. Also check out spatialite.