News for hackers. Stuff that matters.

A comment on SQLite the only database you will ever need in most cases. Parent comment

Re:SQLite the only database you will ever need in most cases by chillfox on Wednesday February 15, 2023 @11:48PM (#34815161)
Most business have daily downtime where the entire business is closed as in not business hours. Being sensitive to downtime is more common for companies that has some kind of online service as their primary product, but most companies are not online companies, or even global companies with offices across all the time zones.

Even for online business some downtime might be acceptable or even preferred. I used to work for a company that made most of it's money through a website and it would take the site offline for 8 hours a few weeks before important events to run a full scale load test on the production infrastructure.

Another place I worked we had to schedule downtime even when updating applications that were designed for zero downtime.

I have never worked a place that didn't allow for downtime or even heard of such a place other than the big tech companies.

[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by fomine3 on Thursday February 16, 2023 @12:07AM (#34815287)
scheduled maintenance downtime at night != unplanned failure downtime at random time
[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by chillfox on Thursday February 16, 2023 @02:03AM (#34815888)
Correct, but in the context of deploys I would hope they are not random failures, but rather planned events that you do when you have updates to... deploy.
[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by maxthegeek1 on Thursday February 16, 2023 @04:32PM (#34826631)
Yes, but you also don't want to have to deploy in the middle of the night in order to avoid downtime during peak hours.

Not only is that a pain for whoever is monitoring the deployment, but now if the deployment breaks something you're going to have to go wake up all of the relevant stakeholders, if you even know who they are.

Not to say late night deployments are never justified, but definitely not something devs want to be doing regularly.

[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by chillfox on Friday February 17, 2023 @10:24PM (#34843559)
There’s alternatives like making rollbacks really easy, and then automating it.
[ Parent | on HN ]