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

[Peter]

Hi @pnorman,  thanks for reply!  "What advantages would JSONB have over hstore?", hum... Is not a kind of "optional flavor",

*  today [JSON](http://www.json.org/) is a [*de facto* standard](https://en.wikipedia.org/wiki/De_facto_standard) for all web applications;  and [*de jure*](https://en.wikipedia.org/wiki/De_jure) since [ECMA-404](http://www.ecma-international.org/publications/files/ECMA-ST/ECMA-404.pdf) in 2013 and [RFC 7159](https://tools.ietf.org/html/rfc7159) in 2014. <br/>Is also the [W3C standard for linked data](http://json-ld.org/), for [tabular metadata](https://www.w3.org/TR/tabular-data-model/), and the a *de facto* standard for many no-SQL databases as Zorba and MongDB... So, JSON also enhances flexibility, user-community, conectivity and [data interchange](https://en.wikipedia.org/wiki/Electronic_data_interchange).

* The [database  support (functions, convertions and operations)](http://www.postgresql.org/docs/9.5/static/functions-json.html)  is so better!!

* The queries will be simple, and stored data so efficient with [JSONB](http://www.postgresql.org/docs/9.5/static/datatype-json.html).

* ... etc. PS: see also [convertions at this answer](http://stackoverflow.com/a/35617429/287948).

And is not  a proposal to convert (duplicating information and CPU time), but to produce directly tables with JSONB, and perhaps review the *database model* to enhance the database flexibility and simplifying data model.

 

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