General discussion

SQLite for production sites?

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?

stephen
stephen
0
3
378
alex
alex
Moderator

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

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

stephen
stephen

I hadn't, but thanks for the tip. Looks very interesting.

aymmuazu
aymmuazu

Hmmmm....