Below is the list of test pages for the sqlite3 WASM builds. All of them require that this directory have been "make"d first. The intent is that this page be run using:

and the individual tests be started in their own tab. Warnings and Caveats:

• Some of these pages require that the web server emit the so-called COOP and COEP headers. althttpd requires the -enable-sab flag for that.
• Any OPFS-related pages require very recent version of Chrome or Chromium (v102 at least, possibly newer). OPFS support in the other major browsers is pending. Development and testing is currently done against a dev-channel release of Chrome (v107 as of 2022-09-26).
• Whether or not WASMFS/OPFS support is enabled on any given page may depend on build-time options which are off by default.

The tests and demos...

• Core-most tests
  • tester1: Core unit and regression tests for the various APIs and surrounding utility code.
  • tester1-worker: same thing but running in a Worker.
• High-level apps and demos...
  • fiddle is an HTML front-end to a wasm build of the sqlite3 shell.
  • demo-123 provides a no-nonsense example of adding sqlite3 support to a web page in the UI thread.
  • demo-123-worker is the same as demo-123 but loads and runs sqlite3 from a Worker thread.
  • demo-jsstorage: very basic demo of using the key-value VFS for storing a persistent db in JS localStorage or sessionStorage.
  • demo-worker1: Worker-based wrapper of the OO API #1. Its Promise-based wrapper is significantly easier to use, however.
  • demo-worker1-promiser: a demo of the Promise-based wrapper of the Worker1 API.
• speedtest1 ports (sqlite3's primary benchmarking tool)...
  • speedtest1: a main-thread WASM build of speedtest1.
  • speedtest1-kvvfs: speedtest1 with the kvvfs.
  • speedtest1-worker: an interactive Worker-thread variant of speedtest1.
  • speedtest1-worker-opfs: speedtest1-worker with the OPFS VFS preselected and configured for a moderate workload.
• The obligatory "misc." category...
  • module-symbols gives a high-level overview of the symbols exposed by the JS module.
  • batch-runner: runs batches of SQL exported from speedtest1.
  • test-opfs-vfs (same with verbose output and sanity-checking tests) is an sqlite3_vfs OPFS proxy using SharedArrayBuffer and the Atomics APIs to regulate communication between the synchronous sqlite3_vfs interface and the async OPFS impl.