2 ms·
I am so happy to see official support for this, particularly the work they are putting into the persistence options. There is a new browser API called the "Orig
by samwillis 4y ago
I am so happy to see official support for this, particularly the work they are putting into the persistence options. There is a new browser API called the "Origin-Private FileSystem" that provides a sandboxed, domain specific, block level filesystem. It is exactly this type of use case, a client side database, that it is designed for, and in fact it is essential to make most use cases of client side WASM SQLite useful.
Essentially, the OPFS enables true ACID compliance, without it you have to "stop the world" and serialise the SQLite db to a string for saving in IndexedDB.
The trifactor of the Origin-Private FileSystem, WASM and SQLite is the missing link to make so many progressive web apps possible.
WASM SQLite persistance options: https://sqlite.org/wasm/doc/trunk/persistence.md https://sqlite.org/wasm/doc/trunk/persistence.md
- Scaevolus 4y agoWe can finally resurrect WebSQL after 12 years! :-)
- sgbeal 4y ago> The trifactor of the Origin-Private FileSystem, WASM and SQLite is the missing link to make so many progressive web apps possible. FWIW, that's exactly our sentiment within the sqlite team. People have been using sqlite with browser-side JS since at least as far back as 2012, but availability of OPFS was the catalyst which piqued our interests in jumping on the WASM bandwagon.