Hacker News new | ask | show | jobs
by jimbokun 7 days ago
Where do you store the SQLite database files? What is your strategy for partitioning your data into SQLite files? One per user or…?
1 comments

> Where do you store the SQLite database files?

What? On the server, where else would you put it?

You only have one server?

Then that approach will work. If you need to scale beyond that, you need some way to route the request to the server with the right data. And what if a request needs data that was stored on two different servers?

Those are the kinds of questions I had in mind.