search

osmcode / osm-postgresql-experiments

Experimental code for importing OSM data into PostgreSQL/PostGIS
GNU General Public License v3.0
7 stars 4 forks source link

FDW from osmium formats #1

Open nextstopsun opened 5 years ago

nextstopsun commented 5 years ago

Is it possible to use osmium lib to create a postgresql foreign data wrapper for osm data? So one could wrap PBF, XML, OPL etc. as a postgres table. Not quite an importer, but an automation tool.

The one I know of crashes postgres.

joto commented 5 years ago

I have thought about this and had a quick look into the FDW thing, but I couldn't understand the interface for FDWs. I am not sure how easy it would be to write something like this. And while it looks "cool" to have something like this, I am not sure how useful it would actually be for just importing data.

It would be more interesting to have a real "OSM database", something you can do queries on, not just read a file from start to finish, and tie that into PostgreSQL, but this would be harder still.