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

[Paul Norman]

What advantages would JSONB have over hstore?

JSONB is actually possible right now, declare a column as it, and use a lua transform which produces a string which casts cleanly to jsonb.

ClearTables does something similar [creating an array](https://github.com/pnorman/ClearTables/blob/3abfd71f0c46dd59408ef1bcbf965bc6230b24b2/common.lua#L117-L127) which is used for [ref tags](https://github.com/pnorman/ClearTables/blob/3abfd71f0c46dd59408ef1bcbf965bc6230b24b2/transportation.lua#L95) to fill a [`text[]` column](https://github.com/pnorman/ClearTables/blob/3abfd71f0c46dd59408ef1bcbf965bc6230b24b2/cleartables.yaml#L141-L142)

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/533#issuecomment-188748642
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20160225/28e4a4d1/attachment.html>