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.
Not an expert of the scalability of databases, but have you seen Cloudflare's D1? Seems promising.
I hadn't, but thanks for the tip. Looks very interesting.