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.
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
Hmm... Does SQLite have some geo data or 2d coordinate lookup capabilities as well?