Strannik-j/sqlite: SQLite mirror @ 2fb488d10af0068581b9096225d1a68c9563562f

stephan 7398e279a7 Remove a flaky JS test which has a result depending on unrepredictable context. That same feature is more reliably tested at a later point in the same script.		1 月之前
..
SQLTester	a525d635a9 Minor doc cleanups in SQLTester.mjs and confirm that the tests pass with both OPFS VFSes.	3 月之前
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].	3 月之前
common	01f07a61e4 Doc updates in JS code. No functional changes.	7 月之前
fiddle	add19478c1 Fix fiddle build broken by recent build-level reworks. Remove a stale reference to an old CSS file.	3 月之前
jaccwabyt	e24cd27c39 Minor doc touchup in the JS bits.	1 年之前
sql	49cb8d7314 Minor cleanups in OO API #1. Add Sudoku SQL to batch-runner.js's list.	2 年之前
tests	db8939f481 Add several convenience links to the OPFS VFS concurrency tester app for launching it with various combinations of options.	6 月之前
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 年之前
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.	2 月之前
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.	2 年之前
README.md	ab12b750de Correct a recently-introduced falsehood in ext/wasm/README.md regarding ssh port forwarding.	1 年之前
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.	1 年之前
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.	1 年之前
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 年之前
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.	1 年之前
c-pp.c	405ae974ee Further wasm build cleanups and tweaks. No functional changes.	3 月之前
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 年之前
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 年之前
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.	1 年之前
demo-jsstorage.html	fd31ae3bf9 Rename several demo/test files and include more of them in the end-user dist archive.	2 年之前
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 年之前
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.	10 月之前
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.	10 月之前
demo-worker1.html	fd31ae3bf9 Rename several demo/test files and include more of them in the end-user dist archive.	2 年之前
demo-worker1.js	4e8e33ba84 Minor cleanups in demo JS code, per forum feedback.	1 年之前
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'.	9 月之前
example_extra_init.c	ef22012b6e Minor doc tweak for the previous commit.	1 年之前
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 月之前
index-dist.html	ffa0fa69b6 wasm promiser.v2 is essentially working but the demo code is double-loading the module for as-yet-undetermined reasons.	10 月之前
index.html	613c2ee21f Minor wasmfs speedtest1 build tweaks. Disable one wasmfs demo which was broken by Emscripten-side changes.	3 月之前
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.	3 月之前
module-symbols.html	c3b7e1c4e8 Add a doc link for the new sqlite3_js_posix_create_file().	1 年之前
scratchpad-wasmfs.html	bb9549e0be More work on the wasmfs build and its test apps.	1 年之前
scratchpad-wasmfs.mjs	bb9549e0be More work on the wasmfs build and its test apps.	1 年之前
speedtest1-wasmfs.html	8ba619b5f5 Minor wasm build cleanups.	1 年之前
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.	3 月之前
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.	1 年之前
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.	1 年之前
speedtest1.html	ab8b22a03d Remove some dead JS code and tweak some docs.	2 年之前
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 年之前
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 年之前
test-opfs-vfs.js	5cc4ab93f2 Fix an exception misuse in test-opfs-vfs.js.	1 年之前
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 年之前
tester1.c-pp.html	65f7942d06 Add JS bundler-friendly JS build. Minor test code cleanups.	2 年之前
tester1.c-pp.js	7398e279a7 Remove a flaky JS test which has a result depending on unrepredictable context. That same feature is more reliably tested at a later point in the same script.	1 月之前
wasmfs.make	fabae7a134 Minor makefile doc fixes. No functional changes.	3 月之前

		
				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