accentor / web

Web frontend for the Accentor music server
Other
4 stars 0 forks source link

Look into using an actual (reactive?) database instead of vuex (for model data) #776

Open chvp opened 2 years ago

chvp commented 2 years ago

https://github.com/dexie/Dexie.js

I think quite a few performance issues might be solved this way, since we can offload complex calculations to the browser while still keeping things reactive. We never (want to) use reactivity below the object level, so that wouldn't result in any problems either AFAICT.

chvp commented 1 year ago

Or even https://developer.chrome.com/blog/sqlite-wasm-in-the-browser-backed-by-the-origin-private-file-system/ (https://www.npmjs.com/package/@sqlite.org/sqlite-wasm)

robbevp commented 1 year ago

That link doesn’t work for me, but sqlite is a lot easier, since I (we both?) are more familiar with sql than with dexie/indexedDB, so that would definitely be a win.

Might even be relevant/handy to standardise on a way to structure the schema of sqlite in the different clients? (Web, macOS/iOS, android?)

On 5 Jul 2023, at 10:40, Charlotte Van Petegem @.***> wrote:

Or even https://developer.chrome.com/blog/sqlite-wasm-in-the-browser-backed-by-the-origin-private-file-system/

— Reply to this email directly, view it on GitHub https://github.com/accentor/web/issues/776#issuecomment-1621300942, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALR2ULVPHIN2EVGLAMXRYFDXOUSAVANCNFSM5VLYB2QA. You are receiving this because you are subscribed to this thread.