Re:In Praise of PostgreSQL
by __app_dev__ on Thursday August 05, 2021 @10:00PM
(#28082465)
Yeah I haven't used pl/pgsql but it reminds me of Oracle's pl/sql which is very powerful.
At first the Oracle version felt clunky to me too but then after taking time to learn it I also found moving complex app logic to SQL allowed me to make complex app changes much quicker. I have use that method of development now for years in a variety of apps and databases and it works great.
As a language it’s a bit clunky* but once you learn it, and you start moving database logic into the database, suddenly everything is 25% LOC, often literally 100x faster, and easier to understand.
As an added bonus, when I’ve moved very complex data transforms into pl/pgsql, the non-programmer technical people can now read the logic and have more than once pointed out problems (with solutions).
* it helps a lot if you write your SELECT and other statements in lowercase. Feels barbaric I know, but reading shoutycode all day gives me a headache.