[Tile-serving] [openstreetmap/osm2pgsql] Can Flex styles run arbitrary SQL against the database? (#1415)

[Ryan Lambert]

I'm knowingly using the "experimental" feature, doesn't that implicitly sign some liability waiver?!  Jokes aside, I do not want to use osm2pgsql in a way that causes avoidable frustration in the future. I have no intention of running arbitrary SQL while osm2pgsql is processing, my goal is running post processing code.  The osm2pgsql command has all the details needed to determine (in Lua) which post-processing SQL script(s) should be ran.

Does the connection string used by osm2pgsql get exposed in a way that lua-dbi could reuse the connection string?  If so, is there a way to run a Lua function only after osm2pgsql processing has finished?  I couldn't find any way to only run a function post-processing.

I currently use psql to run the post-processing scripts to create views, generated columns, etc., it sounds like continuing on that path is the best option right now.  I already load a meta-table to Pg from Lua with information about the data loaded, I can add more information to that table to drive the logic within the database instead of 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/discussions/1415#discussioncomment-359934
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210211/a49eadff/attachment.htm>