wasm_sqlite_with_stats VS sql.js

Not by default, you can test it out here[1].

I documented how to compile an extension into the wasm build here[2], I assume something like that would work for fts? But I'm not sure exactly.

[1]: https://sqlite.org/fiddle/

[2]: https://github.com/llimllib/wasm_sqlite_with_stats/tree/buil...

I wrote up how to compile SQLite to WASM and also include an extension: https://github.com/llimllib/wasm_sqlite_with_stats

You can play with the wasm-compiled extension at the version of the sandbox I compiled here: https://llimllib.github.io/wasm_sqlite_with_stats/

I tried to be thorough with the writeup, so hopefully it helps somebody if that's something they need.

I put thorough instructions here because it wasn't documented anywhere that I could find.

SQLite was one of the first large C code bases to be ported to the web. Alon Zakai (@kripken, the creator of emscripten), made the first commit to sql.js at the start of 2012 [0]. I got involved two years later, and have been maintaining sql.js since. A lot was added since 2012, but the initial core api with 3 functions 'open', 'exec', and 'close' still works today.

https://github.com/kripken/sql.js/commit/cebd80648dbd369b348...