Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature] [BE] Scaling up - using a separate Sqlite DB file for each user #28

Open
baiqiushi opened this issue Jun 2, 2024 · 0 comments

Comments

@baiqiushi
Copy link
Contributor

Currently, we use one single Sqlite DB file to host all data across users.
This approach does not scale up apparently.

A simple idea to scale up the system is to create a standalone DB file for each user.
If a particular user has too many logged queries history, we can hardcode a size budget (e.g., 1 million) and rotating the queries log.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant