3 ms·

Very few people know plpgsql. Like all stored proc languages (Oracle PL/SQL, etc.) it looks and feels like something out of the 80's. It's annoying to deploy,

• doctor_eval 4y ago
  It’s easy to make it feel more modern (select ffs from stop_using_all_caps). But it’s an ideal DSL for data manipulation. It’s not particularly annoying to debug - there are logging, and even single step debugging tools available - and it’s so much easier to test than writing unit tests to do the same thing. I agree it’s painful to deploy, but as I’ve discovered this is a tooling problem; it’s not at all intrinsic to the medium. It’s certainly possible to create tooling to make it easier, and who knows? Maybe I’ll have something to show HN one day. > Many developers today barely know SQL. If true - a very big if - it’s an inditement of the industry and the incentives we use, not a reason to avoid something that makes code faster, safer and smaller. Objections to using these languages are a lot more about willingness to learn and try new (old) things, than they are about the capabilities of the platform.