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

[mboeringa]

> I think it is save to assume that people who are able to formulate complicated SQL queries over hstore columns are able to change a Lua script to add a hstore column.

I think this is a bit to much looked on it from skilled programmer's perspective. There are _many_ people, e.g. in government agencies using something like QGIS, who only have some basic knowledge of SQL, but aren't really versed in programming.

Adding a column to a view based on hstore also doesn't require overly "complicated SQL", it is just

`tags -> 'golf' AS my_golf_field`

based on the current 'tags' name of the hstore column in a 'openstreetmap-carto' / osm2pgsql import.

I still think having an hstore column by default would benefit a lot of users just accessing the data from a simple database / data store perspective, and that aren't interested in building their own custom style, but just want to use the output of the default 'openstreetmap-carto' or some other style.

-- 
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#issuecomment-610277664
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200407/f2e1dab3/attachment.htm>