[Tile-serving] [openstreetmap/osm2pgsql] Enhance with a datamodel option, using JSONB (#533)

[Paul Norman]

> Do you have a UML class diagram of tables generated by osm2pgsql?

No, and the tables generated depend on the style file. If you *really* want a diagram, run it and put the schema through a tool. 

> Perfect! Can you show an little draft with this lua script? In principle the transform can be also after usual tables build, a psql script... But a previous transform save some memory and CPU time.

https://github.com/ClearTables/ClearTables/blob/v0.0.4/util.lua#L48-L59 is what I do with hstore, and then it gets cast with the COPY command. The same can be done with json or jsonb.

-----

After talking to others, I'm closing this.

The slim table schema is an internal implementation detail of osm2pgsql, so outside use is not a concern.

For the rendering tables, it is already possible to have a jsonb column. The submitter is using examples unrelated to the osm2pgsql. Our rendering tables don't have foreign keys, serials, unique constraints, or links between them. An example showing current tables and proposed changes would have been more convincing as it would have been relevant to osm2pgsql.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/533#issuecomment-271695343
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170110/073cbf11/attachment.html>