I think most SaaS can work well SQLite. Prove me wrong
I think most SaaS vendors over-complicate things, especially in the beginning of the startup journey. Using simple technologies like SQLite can significantly reduce the complexity of the project, when compared to other database technologies.
what do you think?
More tooling on Postgres. Why would you use SQLite? It’s great for embedded applications but if yours is networked why cobble together some networked SQLite when you can just use Postgres or another database built for that purpose?
One word: Authentication. SQLite doesn't have the same kinds of database-level authentication out of the box that PostgreSQL, SQL Server etc do, and this is a big deal for compliance nuts (which is where a lot of the reliable money is in SaaS these days).
You can custom compile it in, to be fair. https://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth....
You'd be hard pressed to find a less controversial opinion for HN.
Curious if anyone has actually hit a scale where SQLite cannot handle their workload? What do you actually do at the point?
As a stupid example, lets say you’ve reached a write bottleneck.
Yes, especially if they are very read heavy. Probably wouldn't go with sqlite for say a analytics saas app. And I probably would think about wether there are some functions in for example postgresql that aren't as good in sqlite. But yea most saas can probably run on sqlite.
It's like a repeat of c++ or python. If you can find folks & tooling for what you want to accomplish then go for it. I don't think founders who actually have paying customers concern themselves with what works best per cent of compute spend rather what allows them to improve the product, while as an outsider it may seem that they can reduce costs by choosing X over Y.
My SaaS business runs on SQLite, and it has been working like a champ. Backups are dead simple, and I don't have to worry about uptime, configs, network latency, and all that.
Postgres is great, and I used it in my previous business, but sometimes, it's an overkill.
Using managed technologies such as PostgreSQL will be simpler and often cheaper than SQLite, if you'll have to manage it yourself, incl. scaling, backups, updates.
If you slice per separate physical database file per customer and your clients aren't big corporations that might have lots of concurrent writes.
Probably ! I use SQLIte for most of my web services, I have yet to hit a point where I need to scale them out
Post a contact email? I'd love to reach out about this exact topic!