Home Explore Help
Sign In
Strannik-j
/
sqlite
mirror of https://github.com/sqlite/sqlite.git
Watch 1
Star 0
Fork 0
Files Issues 0 Wiki
Branch: master
Branches Tags
sqlite
/
ext
/
wasm
stephan 21d90a1607 Ensure that the ext/wasm fiddle build undefines certain shell feature flags which it cannot use but might be inherited from the top-level makefile. 2 weeks ago
..
SQLTester a525d635a9 Minor doc cleanups in SQLTester.mjs and confirm that the tests pass with both OPFS VFSes. 1 month ago
api cab9574668 Ensure that the OPFS VFS's xOpen() writes back the read-only flag to the output flags. Resolves the problem reported in [forum:cf37d5ff1182c31081 | forum post cf37d5ff1182c31081]. 1 month ago
common 01f07a61e4 Doc updates in JS code. No functional changes. 5 months ago
fiddle add19478c1 Fix fiddle build broken by recent build-level reworks. Remove a stale reference to an old CSS file. 1 month ago
jaccwabyt e24cd27c39 Minor doc touchup in the JS bits. 10 months ago
sql 49cb8d7314 Minor cleanups in OO API #1. Add Sudoku SQL to batch-runner.js's list. 2 years ago
tests db8939f481 Add several convenience links to the OPFS VFS concurrency tester app for launching it with various combinations of options. 4 months ago
EXPORTED_FUNCTIONS.fiddle.in 278d3faf1f Fiddle: replace db export routine with a C-side one which works for both Emscripten FS-hosted and OPFS-hosted db files. Minor code-adjacent cleanups. 2 years ago
GNUmakefile 6ac6bedc80 Teach ext/wasm/GNUmakefile to use tool/emcc.sh and fix a syntax error in tool/emcc.sh.in. Work around a JimTCL incompatibility in tool/mkshellc.tcl. 1 month ago
README-dist.txt 2f5330036d Correct the handling of the worker1 and promiser JS files in the face of the bundler-friendly changes. Those files require separate, bundler-friendly copies. 1 year ago
README.md ab12b750de Correct a recently-introduced falsehood in ext/wasm/README.md regarding ssh port forwarding. 1 year ago
batch-runner-sahpool.html 68003d9f18 Add a basic batch-mode SQL runner for the SAH Pool VFS, for use in comparing it against WebSQL. Bring the WebSQL batch runner up to date, noting that it cannot run without addition of an "origin trial" activation key from Google because that's now the only way to enable WebSQL in Chrome (that part is not checked in because that key is private). Minor code-adjacent cleanups. 11 months ago
batch-runner-sahpool.js 68003d9f18 Add a basic batch-mode SQL runner for the SAH Pool VFS, for use in comparing it against WebSQL. Bring the WebSQL batch runner up to date, noting that it cannot run without addition of an "origin trial" activation key from Google because that's now the only way to enable WebSQL in Chrome (that part is not checked in because that key is private). Minor code-adjacent cleanups. 11 months ago
batch-runner.html cd0df83c15 Apply considerable acrobatics to get the JS/WASM deliverables building to and loadable from a directory other than the one which contains the app-level code. Requires an only-slightly-leaky abstraction of passing a URL argument when loading sqlite3.js but provides much greater flexibility in where the JS/WASM files are located. 2 years ago
batch-runner.js 68003d9f18 Add a basic batch-mode SQL runner for the SAH Pool VFS, for use in comparing it against WebSQL. Bring the WebSQL batch runner up to date, noting that it cannot run without addition of an "origin trial" activation key from Google because that's now the only way to enable WebSQL in Chrome (that part is not checked in because that key is private). Minor code-adjacent cleanups. 11 months ago
c-pp.c 405ae974ee Further wasm build cleanups and tweaks. No functional changes. 1 month ago
demo-123-worker.html cd0df83c15 Apply considerable acrobatics to get the JS/WASM deliverables building to and loadable from a directory other than the one which contains the app-level code. Requires an only-slightly-leaky abstraction of passing a URL argument when loading sqlite3.js but provides much greater flexibility in where the JS/WASM files are located. 2 years ago
demo-123.html cd0df83c15 Apply considerable acrobatics to get the JS/WASM deliverables building to and loadable from a directory other than the one which contains the app-level code. Requires an only-slightly-leaky abstraction of passing a URL argument when loading sqlite3.js but provides much greater flexibility in where the JS/WASM files are located. 2 years ago
demo-123.js 68003d9f18 Add a basic batch-mode SQL runner for the SAH Pool VFS, for use in comparing it against WebSQL. Bring the WebSQL batch runner up to date, noting that it cannot run without addition of an "origin trial" activation key from Google because that's now the only way to enable WebSQL in Chrome (that part is not checked in because that key is private). Minor code-adjacent cleanups. 11 months ago
demo-jsstorage.html fd31ae3bf9 Rename several demo/test files and include more of them in the end-user dist archive. 2 years ago
demo-jsstorage.js 8948fbee29 Move the sqlite3.capi.wasm namespace to sqlite3.wasm. This causes a tiny bit of naming confusion with the sqlite3.wasm *file*, but seems to make more sense than having it as a sub-namespace of capi. 2 years ago
demo-worker1-promiser.c-pp.html 84016759dd Resolve duplicate loading of promiser v2 demo code (a side effect of having done precisely what it was told to do). Consolidate demo-worker1-promiser(-esm).html/(m)js variants into central copies processed with c-pp. 8 months ago
demo-worker1-promiser.c-pp.js 84016759dd Resolve duplicate loading of promiser v2 demo code (a side effect of having done precisely what it was told to do). Consolidate demo-worker1-promiser(-esm).html/(m)js variants into central copies processed with c-pp. 8 months ago
demo-worker1.html fd31ae3bf9 Rename several demo/test files and include more of them in the end-user dist archive. 2 years ago
demo-worker1.js 4e8e33ba84 Minor cleanups in demo JS code, per forum feedback. 1 year ago
dist.make 6e6dfd6a23 When running the 'dist' target in ext/wasm for an SEE-capable build, ensure that the resulting zip file and directory name include '-see'. 7 months ago
example_extra_init.c ef22012b6e Minor doc tweak for the previous commit. 1 year ago
fiddle.make 21d90a1607 Ensure that the ext/wasm fiddle build undefines certain shell feature flags which it cannot use but might be inherited from the top-level makefile. 2 weeks ago
index-dist.html ffa0fa69b6 wasm promiser.v2 is essentially working but the demo code is double-loading the module for as-yet-undetermined reasons. 8 months ago
index.html 613c2ee21f Minor wasmfs speedtest1 build tweaks. Disable one wasmfs demo which was broken by Emscripten-side changes. 1 month ago
mkwasmbuilds.c 6a8336987a wasm: move the makefile-eval-generated fiddle rules into mkwasmbuilds.c. Squelch some warnings from grep when running 'make clean' on a clean tree. 1 month ago
module-symbols.html c3b7e1c4e8 Add a doc link for the new sqlite3_js_posix_create_file(). 1 year ago
scratchpad-wasmfs.html bb9549e0be More work on the wasmfs build and its test apps. 1 year ago
scratchpad-wasmfs.mjs bb9549e0be More work on the wasmfs build and its test apps. 1 year ago
speedtest1-wasmfs.html 8ba619b5f5 Minor wasm build cleanups. 1 year ago
speedtest1-wasmfs.mjs 69cce89425 wasm: replace much of the eval makefile spaghetti with equivalent code generated from a small C app. It turns out that's easier to read and write than doing the same thing from shell or tcl code, due entirely to C's lack of need for escaping dollar signs. 1 month ago
speedtest1-worker.html 68003d9f18 Add a basic batch-mode SQL runner for the SAH Pool VFS, for use in comparing it against WebSQL. Bring the WebSQL batch runner up to date, noting that it cannot run without addition of an "origin trial" activation key from Google because that's now the only way to enable WebSQL in Chrome (that part is not checked in because that key is private). Minor code-adjacent cleanups. 11 months ago
speedtest1-worker.js 6b36d0b461 Make explicit which JS APIs are for internal use only by moving the JS-bound internal-use-only functions out of client-visible reach and renaming the WASM-exported ones from sqlite3_wasm... to sqlite3__wasm... (with two underscores). These have always been documented as internal-use-only, so this is not a breaking change except for clients which have ignored the docs. 10 months ago
speedtest1.html ab8b22a03d Remove some dead JS code and tweak some docs. 1 year ago
split-speedtest1-script.sh fbf0f488cf batch-runner.js: move generated SQL files into ./sql and start adding hand-written ones (like the Mandelbrot) to that set. 2 years ago
test-opfs-vfs.html cd0df83c15 Apply considerable acrobatics to get the JS/WASM deliverables building to and loadable from a directory other than the one which contains the app-level code. Requires an only-slightly-leaky abstraction of passing a URL argument when loading sqlite3.js but provides much greater flexibility in where the JS/WASM files are located. 2 years ago
test-opfs-vfs.js 5cc4ab93f2 Fix an exception misuse in test-opfs-vfs.js. 1 year ago
tester1-worker.html 2492b6c0fb sqlite3.oo1.Stmt.finalize() now throws if sqlite3_finalize() returns non-zero. This is intended to address the INSERT RETURNING case covered in [forum:36f7a2e7494897df|forum post 36f7a2e7494897df]. 1 year ago
tester1.c-pp.html 65f7942d06 Add JS bundler-friendly JS build. Minor test code cleanups. 1 year ago
tester1.c-pp.js cab9574668 Ensure that the OPFS VFS's xOpen() writes back the read-only flag to the output flags. Resolves the problem reported in [forum:cf37d5ff1182c31081 | forum post cf37d5ff1182c31081]. 1 month ago
wasmfs.make fabae7a134 Minor makefile doc fixes. No functional changes. 1 month ago

README-dist.txt

This is the README for the sqlite3 WASM/JS distribution.

Main project page: https://sqlite.org

Documentation: https://sqlite.org/wasm

This archive contains the following deliverables for the WASM/JS
build:

- jswasm/sqlite3.js is the canonical "vanilla JS" version.

- jswasm/sqlite3.mjs is the same but in ES6 module form

- jswasm/*-bundler-friendly.js and .mjs are variants which are
intended to be compatible with "bundler" tools commonly seen in
node.js-based projects. Projects using such tools should use those
variants, where available, instead of files without the
"-bundler-friendly" suffix. Some files do not have separate
variants.

- jswasm/sqlite3.wasm is the binary WASM file imported by all of the
above-listed JS files.

- The jswasm directory additionally contains a number of supplemental
JS files which cannot be bundled directly with the main JS files
but are necessary for certain usages.

- The top-level directory contains various demonstration and test
applications for sqlite3.js and sqlite3.mjs.
sqlite3-bundler-friendly.mjs requires client-side build tools to make
use of and is not demonstrated here.

Browsers will not serve WASM files from file:// URLs, so the test and
demonstration apps require a web server and that server must include
the following headers in its response when serving the files:

Cross-Origin-Opener-Policy: same-origin
Cross-Origin-Embedder-Policy: require-corp

The core library will function without those headers but certain
features, most notably OPFS storage, will not be available.

One simple way to get the demo apps up and running on Unix-style
systems is to install althttpd (https://sqlite.org/althttpd) and run:

althttpd --enable-sab --page index.html