4 ms·
I can't say it's "any level of scale," but I used this for https://diyband.net https://diyband.net and it was very straightforward for the needs of a hobby-scal
by irskep 3y ago
I can't say it's "any level of scale," but I used this for https://diyband.net https://diyband.net and it was very straightforward for the needs of a hobby-scale web site.
The pitfalls are:
1. It's SQLite, with everything that entails. The schema migration story is "SSH into your production machine and run your migration scripts."
2. Every deploy to a new machine involves downloading your database from S3. Zero-downtime deploys aren't possible because you need to pause writes, sync, and then download the DB to the new container or whatever. If your database is gigabytes (mine is kilobytes), this could be a deal breaker.
Honestly, if managed databases were as cheap as SQLite hosting, I'd just use a managed database, because the SQLite ops workflows are too weird. But I'm confident in the reliability and performance of the site, and it is genuinely cheaper to not run a managed database, which is important for hobby projects.
(Standard internet comment disclaimer that I am a fallible human who might have missed something or am somehow doing it wrong...)
- ramraj07 3y agoToo many teams I know still log into the database to migrate manually for many SaaS apps and the most well intentioned apps still have unexpected downtime so I don't see how a minute of scheduled downtime at 3 am can be a bad thing!