4 ms·
Some ideas for persisting the SQLite database in IndexedDB: https://github.com/jlongster/absurd-sql https://github.com/jlongster/absurd-sql
by franky47 4y ago
Some ideas for persisting the SQLite database in IndexedDB:
https://github.com/jlongster/absurd-sql https://github.com/jlongster/absurd-sql
- samwillis 4y agoThe tldr, is that AbsurdSQL uses IndexedDB to make WASM SQLite ACID compliant. The alternative is to pause writes and dump the whole db as a string to indexeddb, very slow, and not durable. AbsurdSQL is an incredible hack, but is a hack at best. There is a new api, File System Access and the “origin private file system”[0], coming to browsers that has been design specifically with WASM SQLite in mind. I believe the Chrome team have been collaborating with the SQLite team to ensure it will work well. Once this drops it’s going to bring a lot of innovation. 0: https://web.dev/file-system-access/#accessing-files-optimized-for-performance-from-the-origin-private-file-system https://web.dev/file-system-access/#accessing-files-optimize...
- adamziel 4y agoThank you for sharing! I just created an issue: https://github.com/adamziel/wordpress-wasm/issues/19 https://github.com/adamziel/wordpress-wasm/issues/19