Comment by codingdave
8 days ago
Ignore hype cycles. Let the hype die down, and use tech when it has proven itself. Your run-of-the-mill business doesn't try to stay on the leading edge. When not working in the "startup" world, it becomes a good guideline that if you need to be challenged and informed and parse the hype in order to use a new tech... then you probably should not use it. Boring tech is stable tech.
"just use postgres" should be tattood on every junior engineer right out of college
I don't really get why Postgres is touted as "boring" technology. It's literally the "exciting" SQL server.
Surely you mean MySQL / MariaDB.
With Postgres I literally have to re-read docs every time there is a major version upgrade because I need to remind myself how to dump the database and re-import it into the new version because it's 2025 and Postgres still hasn't come up with a way to not have you do this.
Run your cluster on Debian. Make a backup. Run pg_upgradecluster. In a week, throw away the backup.
(You should be checking for regressions and behavior changes in your app, too, but you always need to do that. Have a QA database.)
4 replies →
Running and using MySQL is so much more trouble and limitations, it's not even funny any longer. I for myself have concluded, if I have the choice, I will never again choose MySQL.
pg_upgrade has worked fine for years now, no need for manual dump/restore
https://www.postgresql.org/docs/current/pgupgrade.html
1 reply →