News for hackers. Stuff that matters.

A comment on SQLite WASM in the Browser Backed by the Origin Private File System. Parent comment

Re:SQLite WASM in the Browser Backed by the Origin Private F... by littlecranky67 on Thursday January 12, 2023 @02:45PM (#34359281)
You can't write to SQLite from multiple processes either, so you mitigate that exactly the same way you do for a desktop app (i.e. show "Can't access DB for writing because other instance is running")
[ Parent | on HN ]
Re:SQLite WASM in the Browser Backed by the Origin Private F... by bourgeoismedia on Thursday January 12, 2023 @10:20PM (#34363573)
You can write from multiple processes and this is enabled by default (see PRAGMA locking_mode [1]). If you've got multiple writers you might have to occasionally handle SQLITE_BUSY and retry.

[1] https://www.sqlite.org/pragma.html#pragma_locking_mode

[ Parent | on HN ]