Remix.run Logo
flakeoil 5 days ago

The author of the article says he could not have implemented the app without SQLite, but nowhere in the article does he explain why he could do it with SQLite and not with MySQL/PostgreSQL.

> Feed Your Email is only possible as a service because of SQLite—if I had to maintain three Postgres instances and a couple of web instances and a couple of worker instances, I would have felt like it was too much hassle and cost too much money, and given up.

What's the issue to run MySQL instead and all on one server? You can do it for $5-10 on a Hetzner server.

hellcow 4 days ago | parent [-]

For me the big sell is never needing to deal with massive DB version upgrades to get new features. It’s zero maintenance.

The SQLite DB file format has been backwards-compatible for decades. Update the client and that’s it—you’re using the newest version.