Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Each user's account gets their own SQLite file.

So now you need one database connection per user...



And? It's SQLite; it's a file handle and some cache, not a connection pool.


Depending on how you define "account", that can be quite reasonable. In a B2B application, each business customer could get their own SQLite database, and the number of SQLite connections would likely be quite manageable, even though some customers have many users.


Without knowing details about the app, it's hard to know if that would matter. If a small number of concurrent users would ever be using it, I would think it would be NBD.


If by connection you mean in-process database.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: