2022-09-08 15:30:59 +00:00
<!doctype html>
< html lang = "en-us" >
< head >
< meta charset = "utf-8" >
< meta http-equiv = "Content-Type" content = "text/html; charset=utf-8" >
< link rel = "shortcut icon" href = "data:image/x-icon;," type = "image/x-icon" >
< link rel = "stylesheet" href = "common/testing.css" / >
< title > sqlite3 WASM Testing Page Index< / title >
< / head >
< body >
2022-12-02 11:35:21 +00:00
< style >
header {
background: #044a64;
color: white;
padding: 0.5em;
border-radius: 0.25em;
}
< / style >
2022-09-08 15:30:59 +00:00
< header id = 'titlebar' > < span > sqlite3 WASM test pages< / span > < / header >
< hr >
< div > 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 < em > this< / em > page be run
using:< / div >
2022-09-27 09:17:37 +00:00
< blockquote > < pre > althttpd -enable-sab -page index.html< / pre > < / blockquote >
2022-09-26 11:38:58 +00:00
< div > and the individual tests be started in their own tab.
Warnings and Caveats:
2022-09-08 15:30:59 +00:00
< ul class = 'warning' >
2023-02-10 11:05:16 +00:00
< li > All of these pages must be served via an HTTP
server. Browsers do not support loading WASM files via
file:// URLs.< / li >
< li > Any OPFS-related pages or tests require:
< ul >
< li > That the web server emit the so-called
< a href = 'https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Cross-Origin-Opener-Policy' > COOP< / a >
and
< a href = 'https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Cross-Origin-Embedder-Policy' > COEP< / a >
headers. < a href = 'https://sqlite.org/althttpd' > althttpd< / a > requires the
< code > -enable-sab< / code > flag for that.
< / li >
< li > A very recent version of a
Chromium-based browser (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 (v111 as of 2023-02-10).
< / li >
< / ul >
2022-09-08 15:30:59 +00:00
< / li >
< / ul >
< / div >
2022-09-26 11:38:58 +00:00
< div > The tests and demos...
2022-09-08 15:30:59 +00:00
< ul id = 'test-list' >
2022-10-13 16:48:35 +00:00
< li > Core-most tests
< ul >
< li > < a href = 'tester1.html' > tester1< / a > : Core unit and
regression tests for the various APIs and surrounding
utility code.< / li >
2022-10-16 15:38:03 +00:00
< li > < a href = 'tester1-worker.html' > tester1-worker< / a > : same thing
2022-11-19 05:26:45 +00:00
but running in a Worker.< / li >
2022-11-19 16:16:40 +00:00
< li > < a href = 'tester1-esm.html' > tester1-esm< / a > : same as
< code > tester1< / code > but loads sqlite3 in the main thread via
an ES6 module.
< / li >
< li > < a href = 'tester1-worker.html?esm' > tester1-worker?esm< / a > :
same as < code > tester1-esm< / code > but loads a Worker Module which
then loads the sqlite3 API via an ES6 module. Note that
not all browsers permit loading modules in Worker
threads.
< / li >
2022-10-13 16:48:35 +00:00
< / ul >
< / li >
2022-09-21 12:25:40 +00:00
< li > High-level apps and demos...
< ul >
2022-10-26 15:34:51 +00:00
< li > < a href = 'fiddle/index.html' > fiddle< / a > is an HTML front-end
2022-09-21 12:25:40 +00:00
to a wasm build of the sqlite3 shell.< / li >
< li > < a href = 'demo-123.html' > demo-123< / a > provides a
2022-09-26 11:38:58 +00:00
no-nonsense example of adding sqlite3 support to a web
page in the UI thread.< / li >
< li > < a href = 'demo-123-worker.html' > demo-123-worker< / a > is
the same as < code > demo-123< / code > but loads and runs
sqlite3 from a Worker thread.< / li >
2022-10-19 07:34:36 +00:00
< li > < a href = 'demo-jsstorage.html' > demo-jsstorage< / a > : very basic
2022-09-26 11:38:58 +00:00
demo of using the key-value VFS for storing a persistent db
in JS < code > localStorage< / code > or < code > sessionStorage< / code > .< / li >
2022-10-19 07:34:36 +00:00
< li > < a href = 'demo-worker1.html' > demo-worker1< / a > :
Worker-based wrapper of the OO API #1. Its Promise-based
wrapper is significantly easier to use, however.< / li >
< li > < a href = 'demo-worker1-promiser.html' > demo-worker1-promiser< / a > :
a demo of the Promise-based wrapper of the Worker1 API.< / li >
2022-09-21 12:25:40 +00:00
< / ul >
< / li >
< li > speedtest1 ports (sqlite3's primary benchmarking tool)...
< ul >
< li > < a href = 'speedtest1.html' > speedtest1< / a > : a main-thread WASM build of speedtest1.< / li >
2022-12-03 02:42:21 +00:00
< li > < a href = 'speedtest1.html?vfs=kvvfs' > speedtest1?vfs=kvvfs< / a > : speedtest1 with the kvvfs.< / li >
2023-07-12 09:16:18 +00:00
< li > < a href = 'speedtest1-worker.html?size=15' > speedtest1-worker< / a > : an interactive Worker-thread variant of speedtest1.< / li >
< li > < a href = 'speedtest1-worker.html?vfs=opfs&size=10' > speedtest1-worker?vfs=opfs< / a > : speedtest1-worker with the
2022-09-21 12:25:40 +00:00
OPFS VFS preselected and configured for a moderate workload.< / li >
2023-07-15 11:23:57 +00:00
< li > < a href = 'speedtest1-worker.html?vfs=opfs-sahpool&size=10' > speedtest1-worker?vfs=opfs-sahpool< / a > :
speedtest1-worker with the OPFS-SAHPOOL VFS preselected
and configured for a moderate workload.
< / li >
2022-09-21 12:25:40 +00:00
< / ul >
< / li >
< li > The obligatory "misc." category...
< ul >
2022-10-28 11:40:46 +00:00
< li > < a href = 'module-symbols.html' > module-symbols< / a > gives
a high-level overview of the symbols exposed by the JS
module.< / li >
2023-07-26 11:41:41 +00:00
<!-- li><a href='batch - runner.html'>batch - runner</a>: runs batches of
SQL exported from speedtest1.< / li-- >
2022-09-21 12:25:40 +00:00
< li > < a href = 'test-opfs-vfs.html' > test-opfs-vfs< / a >
(< a href = 'test-opfs-vfs.html?opfs-sanity-check&opfs-verbose' > same
2022-10-16 23:33:24 +00:00
with verbose output and sanity-checking tests< / a > ) 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.
2022-09-21 12:25:40 +00:00
< / li >
2022-11-21 03:50:52 +00:00
< li > < a href = 'tests/opfs/concurrency/index.html' > OPFS concurrency< / a >
tests using multiple workers.
< / li >
2022-09-21 12:25:40 +00:00
< / ul >
2022-09-17 15:08:22 +00:00
< / li >
2023-07-13 17:27:05 +00:00
< li > < strong > WASMFS< / strong > -specific tests which require that
the WASMFS build is available on this server (it is not by
default) and that this server emits the COOP/COEP headers.
2022-12-17 11:14:35 +00:00
< ul >
2023-07-13 17:27:05 +00:00
< li > < a href = 'scratchpad-wasmfs.html' > scratchpad-wasmfs< / a > :
experimenting with WASMFS/OPFS-based persistence.
< / li >
< li > < a href = 'speedtest1-wasmfs.html?flags=--size,15' > speedtest1-wasmfs< / a > :
2022-12-17 11:14:35 +00:00
a variant of speedtest1 built solely for the wasmfs/opfs
2023-07-13 17:27:05 +00:00
feature.
< / li >
2022-12-17 11:14:35 +00:00
< / ul >
2023-07-13 17:27:05 +00:00
< / li >
2022-09-08 15:30:59 +00:00
<!-- li><a href='x.html'></a></li -->
< / ul >
< / div >
< style >
#test-list { font-size: 120%; }
< / style >
< script > / / A s s i g n a d i s t i n c t t a r g e t t a b n a m e f o r e a c h t e s t p a g e . . .
document.querySelectorAll('a').forEach(function(e){
2023-01-29 05:09:39 +00:00
e.target = e.href.replace(/^http*:\/\/[^/]+\//, '');
2022-09-08 15:30:59 +00:00
});
< / script >
< / body >
< / html >
