Re:Optimizing Large-Scale OpenStreetMap Data with SQLite
by bspammer on Sunday July 07, 2024 @09:23AM
(#40897531)
Wouldn’t creating an index for each tag cost a lot of disk space? There are hundreds (thousands?) of OSM tags. I like their approach of combining a FTS table with a normal JSON query for ad-hoc queries.
[ Parent
| on HN ]
Re:Optimizing Large-Scale OpenStreetMap Data with SQLite
by jtarchie on Monday July 08, 2024 @11:06AM
(#40906085)
The FTS table also has the extra benefit of different tokenizers -- porter, unicode, trigram, etc. It allows less precise searches to happen but still returns some results. I liked this because I wanted the best effort, not exact results for some user queries.