search

GFDRR / osm-analytics-cruncher

Backend code for osm-analytics
https://github.com/hotosm/osm-analytics
0 stars 0 forks source link

Extract data into a dedicated data storage mechanism #8

Open tiagojsag opened 7 years ago

tiagojsag commented 7 years ago

Context

we will have a new API to serve the analytics data decoupled from the actual map tiles.

Proposal

The current data is served in map tiles format, which internally uses sqlite structure. Since the analytics API has significantly different requirements than the current client code, a different data storage mechanism might be used instead. Potential solutions include ElasticSearch or PostgreSQL + PostGIS, but others might also be explored.

nerik commented 7 years ago

Note: we are already able to serve stats in the API using the raw mbtiles sqlite3 db.