[Tile-serving] [openstreetmap/osm2pgsql] Flex backend: hstore column for all flex tables (#1109)

[mboeringa]

Thinking about the flex backend and its usage, one thing that struck me as likely being missing in the current setup (correct me if I am wrong, I haven't attempted to use it yet!), is an hstore column on all generated flex backend custom tables.

While I appreciate that you can define the columns through Lua scripts, adding an hstore column to each dedicated table, adds a significant benefit and flexibility otherwise not easily achieved: the ability to customize a table's columns in a SQL statement via creation of (temporary) views that extract extra columns from hstore via the PostgreSQL hstore syntax.

This has the advantage that you can manage table contents through SQL instead of having to hack into Lua scripts, and thus adds another level of "flexibility" to the use of the flex backend.

E.g. I could well see an organization like HOT adding a custom table for hospitals, and then create custom views on it with dedicated information based on hstore extracted specific attributes for a region or project, that are not defined in Lua.

-- 
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/1109
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200407/8b924fa5/attachment-0001.htm>