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

Storage performance, offline, local first #68

Open
dohsimpson opened this issue Feb 19, 2025 · 1 comment
Open

Storage performance, offline, local first #68

dohsimpson opened this issue Feb 19, 2025 · 1 comment

Comments

@dohsimpson
Copy link
Owner

Current storage backed by json file prevents offline usage, also makes multi user update difficult without constant synchronization. Furthermore, await for async update calls make ui feel unresponsive, and it creates situations where clicking the complete button multiple times would register multiple completions, this wouldn't have happened, even though we can disable the completion button as a workaround, better fix is to update local data and return right away, instead of waiting for network call to finish.

And another reason is persisting json file is not scalable, the performance is going to be slower and slower over time. Preferrably, we should opt to a local first reactive data store backed by a real db.

@AsocPro
Copy link

AsocPro commented Feb 20, 2025

I'm just going to throw it out there that I would love SQLite from an operation perspective. Its easy to backup/restore since its just one file and keeps the app self contained into one container with a data volume mount. That being said another database isn't a deal breaker just a personal preference for ease of use.

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

2 participants