Re:SQLite in the browser with WASM/JS - OFFICIAL
by k__ on Friday October 28, 2022 @07:46PM
(#33379453)
Isn't that model (without the wasm part) alread possible with pouchdb/couchdb?
Re:SQLite in the browser with WASM/JS - OFFICIAL
by harryvederci on Saturday October 29, 2022 @05:15AM
(#33382361)
I haven't looked into those, but I'm happily using SQLite already, and this would mean I won't have to swap it for something else to achieve the same thing.
Re:SQLite in the browser with WASM/JS - OFFICIAL
by ris58h on Sunday October 30, 2022 @03:04AM
(#33391938)
> If I understand things correctly this is the missing piece: persistence. So if the user goes offline and makes changes, those will persist so they can be synced when the user goes online again.
1. You can persist data with localStorage/IndexDB, can't you? 2. There is nothing in the article about syncing. There is no out-of-the-box solution, as I can see.
Re:SQLite in the browser with WASM/JS - OFFICIAL
by harryvederci on Sunday October 30, 2022 @08:14AM
(#33393746)
> You can persist data with localStorage/IndexDB, can't you?
I guess so, but given the situation that I'd already be using WASM SQLite in the client's browser, then I'd have to implement that part myself, or use something like Absurd SQL. I'd rather use the implementation made by the creator of SQLite.
> There is nothing in the article about syncing.
Correct, that's something I'll have to do myself. I don't see any issues there though, I'd just need to verify the user is authorised to make those changes, which in my specific use case seems pretty trivial.
(All of this is as far as I understand things, I could be completely wrong.)