News for hackers. Stuff that matters.
Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by mtmail on Sunday September 02, 2018 @06:41PM (#17899086)
We use it extensively for 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/f...

Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by xaranke on Sunday September 02, 2018 @09:59PM (#17899767)
Very cool. Out of curiosity, what would be the best way to get involved in Nominatim?
Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by mtmail on Monday September 03, 2018 @08:47AM (#17902290)
Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by xaranke on Tuesday September 04, 2018 @07:48PM (#17913894)
Cool, will take a look. Thanks!