3 ms·
I really don't understand the sqlite fad, you can run postgres on the same instance and get a much more capable database but also have the freedom to expand to
by siliconc0w 3y ago
I really don't understand the sqlite fad, you can run postgres on the same instance and get a much more capable database but also have the freedom to expand to a tiered architecture if you want.
For personal things I just use an EC2 instance w/ docker compose.
- adamckay 3y agoBecause Postgres is another thing you have to run, maintain and monitor, and you have to make a judgement whether that extra complexity is worth it - for a lot of simple projects, it's not. SQLite is a library you use in your application process that writes to a file. There's a bit of care you have to do to ensure you back up that file safely, but there's no extra monitoring or maintenance above what you do for your app anyway. I agree that running Postgres isn't terribly difficult, but no matter how simple you try to make a small Postgres instance, SQLite is simpler.
- AlexITC 3y agoI run a setup that's very similar to the author's one, but, I run postgres. For a simple setup, postgres maintenance is practically null.