صفحهٔ اصلی گشت‌و‌گذار راهنما
ورود
Strannik-j
/
sqlite
mirrorاز https://github.com/sqlite/sqlite.git
دنبال کردن 1
ستاره دار 0
انشعاب 0
پرونده‌ها مشکلات 0 ویکی
درخت: 2fb488d10a
شاخه‌ها تگ‌ها
sqlite
/
ext
/
wasm
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. 2 ماه پیش
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]. 2 ماه پیش
common 01f07a61e4 Doc updates in JS code. No functional changes. 6 ماه پیش
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. 5 ماه پیش
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. 1 سال پیش
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'. 8 ماه پیش
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. 1 ماه پیش
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. 1 سال پیش
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