3 ms·
We use it extensively for http://nominatim.org/ http://nominatim.org/ It's superior when writing loops or even recursive queries that usually require follow-up
by mtmail 8y ago
We use it extensively for http://nominatim.org/ http://nominatim.org/ It's superior when writing loops or even recursive queries that usually require follow-up queries (and thus multiple back-and-forths between your app and the database). Debugging and test-driven development on the other hand is hard. So is versioning functions and updating them. I'd only recommend it if all other options of improving the performance of database queries were tried.
https://github.com/openstreetmap/Nominatim/blob/master/sql/functions.sql https://github.com/openstreetmap/Nominatim/blob/master/sql/f...
- xaranke 8y agoVery cool. Out of curiosity, what would be the best way to get involved in Nominatim?
- mtmail 8y agoThe email list https://lists.openstreetmap.org/listinfo/geocoding https://lists.openstreetmap.org/listinfo/geocoding List of small https://github.com/openstreetmap/Nominatim/issues?q=is%3Aissue+is%3Aopen+label%3Asimple https://github.com/openstreetmap/Nominatim/issues?q=is%3Aiss... and larger projects https://wiki.openstreetmap.org/wiki/Google_Summer_of_Code/2018/Project_Ideas#Nominatim https://wiki.openstreetmap.org/wiki/Google_Summer_of_Code/20...
- xaranke 8y agoCool, will take a look. Thanks!