Ask HN: Have you ever used PL/pgSQL – the PostgreSQL programming language?

Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by tcbasche on Sunday September 02, 2018 @06:14PM (#17898976)

Having used Oracle's PL/SQL, I can't really see a use case for this kind of language. Your application logic should be kept within your application, not on your database.

The exception to this of course being unless your application is already on your database.

[ Parent | on HN ]

Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by iracic on Monday September 03, 2018 @04:30AM (#17901272)

There is. When you need to treat your data without network delays. When performance is essential. When you can't express it efficiently with non-procedural SQL or need to have access with several technologies (can think of it as service on db level). Depending of environments, deploying changes can be much easier than patching app side.

[ Parent | on HN ]

Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by tcbasche on Thursday September 06, 2018 @07:17PM (#17930482)

That is a very good point :) I definitely did not consider the performance benefits. You learn something new every day!

[ Parent | on HN ]