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 itake on Wednesday February 15, 2023 @08:19PM (#34813643)
Yes... and all I see here is downtime. How do we do this without services failure? With a postgres db, you can spin up and down ec2 instances to your hearts content. Every 1-4 years, you can upgrade your db by using a replica with no down time.
[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by sroussey on Wednesday February 15, 2023 @09:00PM (#34813972)
Depends on what you are doing. But a hobby project should definitely just do downtime, lol.

If your db does lots of work, I buy new ones, install them in the datacenter, bring them up from backup.

BTW: you skipped a step for a busy database: warming it up with shadow traffic.

Under certain scale just switching like you describe will cause just as much downtime.

[ Parent | on HN ]