General discussion

SQLite for production sites?

3

234

At what point do you think a SQLite backed website has exceeded its limits?

I've read references that say how robust it is etc, and at work, we had one that came with an Open Source system which ended up with 100,000 records (though struggled). Plus, it's soooo convenient not having to set up MySQL etc.

Any thoughts?

Not an expert of the scalability of databases, but have you seen Cloudflare's D1? Seems promising.

https://blog.cloudflare.com/introducing-d1/