You can of course take a SQL dump that is version-independent, but if you're serious about creating backups, you want to take backups of the actual on-disk format of the WAL, because that's more efficient and also the only practical way to get point-in-time recovery. (For the efficiency, you could alternatively also take ZFS snapshots, which will work independently of the Postgres version, but those also don't give you PITR.) The WAL format is a Postgres implementation detail and therefore tools wanting to read and write it need maintenance whenever the format changes (which can happen on major version releases).
On the other hand I spent 25 years selling desktop software and never once had an annual review. I never had to submit an application for time off. I never had to ask permission for a dentist appointment. If the weather was good I could take the day off and go for a bike ride. I didn’t attend any scrum meetings nor did I have to argue about what framework to use with a PM who couldn’t code FizzBuzz.
i feel like i'm being gaslit into believing that coding was ever hard or the bottleneck.
Typing and thinking in English is demonstrably slower than in code/the abstract (Haskell for me.)
And no, I didn't write English plans before AI. Or have a stream of English thought in my head. Or even pronounce code as I read and wrote it. That's low-skill stuff.
It's the opposite. Coding was, and is, still hard. If you don't believe me go do an Advent of Code challenge after day 15. LLMs have tricked everyone into believing coding is easy.
I'm confused though. I have never like spent hours at a time coding at my job or side projects. And yet I keep building stuff..
I tried LLMs because of AI fomo by my CEO. "Opus 4.whatever is a stepwise improvement - I am convinced all coders who don't go all-in on AI will be obsolete soon." Multiple times I tried. Every time Claude creates crap and I have to spend a bunch of time correcting it in a loop. Or basically scripting it. And it's like..I never spent this much time thinking or actively working before.
So I'm back to being natty and I am delivering more and have more time during the workday to spend with my wife and kid and video games etc.
reply