The 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-optimize...

Thank you for sharing! I just created an issue: https://github.com/adamziel/wordpress-wasm/issues/19