SQLite Forum

Thousands of SQLite Databases for each user
Login
Appreciate the response!

I do have a central DB but that is more for smaller things and probably gets written to (< 100 times a day) - it is mostly used for reads. 

Each user would have their own unique SQLite database, stored under their unique directory.

In terms of horizontally scaling (in the future), I was thinking of just having a few identical servers under a load balancer. Since the DBs are mostly for reads, whenever someone writes to an SQLite file it would just get replicated across the other instances - which should be pretty quick I believe since it's just one file for that user.

If it ever turns out to not be that efficient, I would probably just use DynamoDB

Would that work?