• 8 Posts
  • 255 Comments
Joined 2 years ago
cake
Cake day: June 17th, 2023

help-circle
  • Exactly. It’s not just downtime to worry about, either. It’s disks filling up. It’s hardware failure. It’s DNS outages. It’s random DDoS attacks. It’s automated scans of the internet targeting WordPress. It’s OS, php and database upgrades. It’s setting up graphing, monitoring, alerting and being on-call 24/7 to deal with the issues that come up.

    If these businesses are at all serious, pay for professional hosting and spend your time running the business.











  • I’ve spend more than a decade supporting both Postgres and MongoDB in production.

    While they each have quirks, I prefer the quirks of Postgres.

    I just spent a massive amount of time retooling code to deal with a MongoDB upgrade. The code upgrade is so complex because that’s where the schema is defined. No wonder MongoDB upgrades are easier— the database has externalized a lot of complexity that now becomes some coders problem to deal with.


  • For minor version upgrades, the database remains binary compatible. Nothing to do.

    The dump/restore required during major upgrades allows format changes which enable new features and performance improvements without dragging around cruft forever to stay backwards compatible.

    For professionals running PostgreSQL clusters in production there is a way to cycle in the new server version with zero user-visible downtime.