SQLite Forum

Thousands of SQLite Databases for each user
Login
I am planning on giving each user their own SQLite DB, rather than storing everything on one large database (e.g. MySQL/Postgres).

I see Internet threads online advising against this because it makes it harder to horizontally scale.

Has anyone had experience with something like this? I don't see why it would be hard to scale as it is just singular files that can be easily replicated.

I am currently storing everything on individual flat files, for thousands of users on my site and looking to use something more reliable - postgres just seems like overkill.