3 ms·
Nailed it - except one massive feature missed IMO is pl/pgsql. As a language it’s a bit clunky* but once you learn it, and you start moving database logic into
by doctor_eval 5y ago
Nailed it - except one massive feature missed IMO is pl/pgsql.
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.
- __app_dev__ 5y agoYeah 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.