[openstreetmap/openstreetmap-website] Add Docker Compose Support for Development Environment (#2409)

Andy Allan notifications at github.com
Thu Feb 4 10:33:38 UTC 2021


@gravitystorm commented on this pull request.



> @@ -0,0 +1,7 @@
+FROM postgres:11
+
+# Add db init script to install OSM-specific Postgres functions/extensions.
+ADD docker/postgres/openstreetmap-postgres-init.sh /docker-entrypoint-initdb.d/
+
+# Custom database functions are in a SQL file.
+ADD db/functions/functions.sql /usr/local/sbin/osm-db-functions.sql

Unfortunately yes, we still need it. The `tile_for_point` SQL function is not needed for day-to-day operations (and so not required for the tests), since we calculate the tile using the QuadTile gem before storing it, and we again use the QuadTile gem to generate the (giant) select queries.

But there's also the database migrations where the columns were added, and those migrations backfill the tile columns using the SQL function. 

I have much else to say about ancient migrations, but for now, we can't just drop the SQL function entirely.

-- 
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/openstreetmap-website/pull/2409#discussion_r570115583
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20210204/b472dfa9/attachment.htm>


More information about the rails-dev mailing list