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 erik_seaberg on Wednesday February 15, 2023 @09:28PM (#34814209)
If you install your own copy, you are on call for it, and the colo is unlikely to offer much help. You also have to set up monitoring or you won’t even know when it fails. Then there’s replication. Backups. All this stuff is work that PaaS vendors are ready to automate away, if my time is expensive for the org.

For fun, sure, dink around and learn as long as there are no customers to affect.

[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by canadianfella on Wednesday February 15, 2023 @09:57PM (#34814426)
Can’t you just run a script that sets all that up for you? Just like any other programming task?
[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by erik_seaberg on Thursday February 16, 2023 @01:00AM (#34815606)
I suppose Terraform could do it (I’m pleasantly surprised to see it has a PagerDuty plugin), but it’s a lot more to write than a PaaS API, and you probably can’t borrow a specialist SRE/DBA for a small fraction of his salary.
[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by riku_iki on Wednesday February 15, 2023 @10:18PM (#34814558)
from another hand, vendor can screw things up and you don't have control over it.
[ Parent | on HN ]
Re:SQLite the only database you will ever need in most cases by pdimitar on Thursday February 16, 2023 @08:04AM (#34818130)
You are not wrong but for each personal project this upfront cost is 2 hours maximum, with accumulated 5-6 more over the course of the next 3-6 months.

Not a huge sacrifice. Though I do get the argument of "I want to pay $5 and it to just work" and I've done so part of the times. Just pointing out that the upfront investment in doing it on your own is not so big.

[ Parent | on HN ]