Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
104 events for the month beginning 2023-07-01 by user stephan
Following month ↑|
2023-07-31
| ||
| 13:52 | Experimentally change the JNI sqlite3_trace_v2() callback type to have more convenient access to the current Java-side sqlite3_stmt at the cost of some uncomfortably fiddly current-statement tracking in the JNI layer. Subject to change. (check-in: 459db332 user: stephan tags: jni) | |
| 12:10 | Add some JNI-internal metrics, accessible via passing -v when running Tester1.java. Document an OpenJDK bug which leads to incorrect -Xlint:jni warnings. (check-in: a5d68a6b user: stephan tags: jni) | |
| 10:55 | Correct a mis-cast in the JNI wrapper which just happened to accidentally work. Update JNI binding of sqlite3_context_db_handle() to return the bound-at-open() db instance instead of a new/temp proxy object. (check-in: 9faca5d9 user: stephan tags: jni) | |
| 10:42 | Add another test for JNI-bound scalar UDFs. (check-in: 8b322d92 user: stephan tags: jni) | |
| 10:22 | Update some internal docs for the past two checkins. Add a way to dump out some debug info about the current JNI environment. (check-in: ac9b8bb1 user: stephan tags: jni) | |
| 10:08 | Refactor the busy-handler-specific JNI hook type to use the generic hook type. (check-in: d9efdc6d user: stephan tags: jni) | |
| 09:45 | Refactor the collation-specific JNI hook type to use the generic hook type. (check-in: 02c1d3b6 user: stephan tags: jni) | |
| 09:28 | Internal JNI doc tweaks. (check-in: f4aa2c82 user: stephan tags: jni) | |
| 07:15 | Consolidate triplicated xDestroy()-calling code. Remove some unnecessary casts. (check-in: 24c0763d user: stephan tags: jni) | |
|
2023-07-30
| ||
| 18:41 | Internal JNI API renaming. (check-in: fcfc0706 user: stephan tags: jni) | |
| 17:24 | Internal JNI refactoring towards consolidating support for callbacks with and without finalizers. (check-in: 120983a5 user: stephan tags: jni) | |
| 13:47 | Mark the Java wrapper classes of the C-native types as 'final' (cannot be subclassed). (check-in: 4fd3d936 user: stephan tags: jni) | |
| 13:30 | Minor tweaks and optimizations in the JNI bindings. (check-in: 41fb5898 user: stephan tags: jni) | |
| 11:36 | Bind sqlite3_collation_needed() to JNI. Related adjacent cleanups and fixes. (check-in: 16ff1676 user: stephan tags: jni) | |
| 10:47 | Internal JNI refacoring to support the pending sqlite3_collation_needed() callback. Correct a bug in the linked-list handling of PerDbStateJni which triggered an assert(). (check-in: 7ac6614e user: stephan tags: jni) | |
| 09:45 | Incremental checkin to minimize the diff while narrowing in on an assertion caused by refactoring. (check-in: 2d7a91b1 user: stephan tags: jni) | |
| 08:12 | Consolidate some warnings for java callbacks which must not throw but do. (check-in: 5e592ed2 user: stephan tags: jni) | |
| 07:44 | Bind sqlite3_update_hook() to JNI. (check-in: a5bbaa90 user: stephan tags: jni) | |
| 06:44 | Bind sqlite3_rollback_hook() to JNI. (check-in: 5f8ee440 user: stephan tags: jni) | |
| 06:00 | Add commit hook failure to JNI tests. (check-in: be4459b4 user: stephan tags: jni) | |
| 05:50 | Bind sqlite3_commit_hook() to JNI. (check-in: c687297f user: stephan tags: jni) | |
| 04:31 | Bind sqlite3_progress_handler() to JNI. Add some metrics to Tester1.java. (check-in: 437ecfe8 user: stephan tags: jni) | |
| 03:54 | Add tests for SAHPoolUtil.exportFile() and importDb(). (check-in: 4aa88b8f user: stephan tags: trunk) | |
|
2023-07-29
| ||
| 15:53 | SAHPoolUtil.importDb() now accepts either a byte array or ArrayBuffer. (check-in: 3848f04e user: stephan tags: trunk) | |
|
2023-07-28
| ||
| 18:44 | Internal JNI binding docs. (check-in: 991c6619 user: stephan tags: jni) | |
| 18:02 | Fix an incorrect file path in ext/jni/README.md (check-in: bcefa2df user: stephan tags: jni) | |
| 11:52 | Correct a recently-introduced falsehood in ext/wasm/README.md regarding ssh port forwarding. (check-in: 2a3f3a9c user: stephan tags: trunk) | |
| 10:37 | Minor java cleanups recommended by a modern IDE. (check-in: f92a9bba user: stephan tags: jni) | |
| 10:01 | Add Java tests which ensure that xFinal() is called with no aggregate context when the result set is empty. (check-in: 7ac8c66a user: stephan tags: jni) | |
| 09:54 | Tweaks to the Java-side UDF docs. (check-in: 48e0079d user: stephan tags: jni) | |
| 09:25 | More Java docs about making use of the aggregate context. Change the JNI mapping to set the sqlite3_context::aggregateContext member directly, instead of via a superflous setter, because that way is faster. (check-in: 7af0cb99 user: stephan tags: jni) | |
| 01:51 | More docs and cleanups related to the aggregate UDF state. Correct the OOM check to behave properly if xFinal() is called without a matching xStep(), xValue(), or xInverse(). (check-in: ff53f1cc user: stephan tags: jni) | |
| 01:19 | Add an OOM check to the previous check-in. Minor internal API renaming. (check-in: 6b56e4d6 user: stephan tags: jni) | |
| 01:12 | Add support making use of sqlite3_aggregate_context() (in a roundabout way) from Java to accumulate state within aggregate and window UDFs. (check-in: 64057498 user: stephan tags: jni) | |
|
2023-07-27
| ||
| 22:53 | Reformulate jni tests to not require the -ea jvm flag to enable assert(). (check-in: dc356667 user: stephan tags: jni) | |
| 22:42 | Add locking test for BusyHandler and clear up new -Xlint:jni warnings introduced by the busy-handler binding. (check-in: 7dcde2bf user: stephan tags: jni) | |
| 22:05 | Bind sqlite3_busy_handler(). Correct mapping of pointers for, and cleanup of, JNI-level per-db state. (check-in: 52474779 user: stephan tags: jni) | |
| 20:32 | Replace some www: interwiki references in the JNI readme with their full URLs to make the doc more portable. (check-in: 63ce0c9b user: stephan tags: jni) | |
| 20:12 | Merge trunk into jni branch for compiler warning fixes. (check-in: 0514fd34 user: stephan tags: jni) | |
| 20:02 | Initial check-in of JNI (Java Native Interface) bindings for the core C API. (check-in: b5374b9e user: stephan tags: jni) | |
| 17:50 | Dynamically determine whether the wasm.xWrap() argc check can be applied, depending on how the wasm environment exposes its exports. (check-in: fd59226b user: stephan tags: trunk) | |
| 15:00 | Dynamically determine whether the wasm.xWrap() argc check workaround for JSPI is necessary, instead of baking it in to JSPI builds. (Edit: closing jspi branch. Introducing JSPI would require making parts of the C API wrapper async.) (Closed-Leaf check-in: 86bb464f user: stephan tags: jspi) | |
| 01:38 | Accommodate a breaking change in emcc 3.1.44. (check-in: 2c5dd341 user: stephan tags: trunk) | |
| 01:35 | Accommodate a breaking change in emcc 3.1.44. (check-in: 4ce38603 user: stephan tags: jspi) | |
|
2023-07-26
| ||
| 18:11 | Initial experimentation with getting JSPI (JavaScript Promise Integration) support working. It builds, but requires disabling func argument count validation checks on sqlite3.wasm.xWrap()-processed exports and it crashes cryptically in wasm when the tests are run. (check-in: 5b178f92 user: stephan tags: jspi) | |
| 11:41 | Remove the batch SQL runner from the JS build's 'all' target, as it's long-since unused and adds noticable build time. Add makefile comments about JSPI. (check-in: b8f708e3 user: stephan tags: trunk) | |
| 11:11 | Add SAHPoolUtil.getFileNames() method, and tests for it, per forum feedback. Add a test to demonstrate that two SAH pools can coexist so long as they have different names. (check-in: 72dc3f8c user: stephan tags: trunk) | |
| 07:57 | Reformulate [907dfc4a7aa1] using awk instead of sed for better cross-platform portability. (check-in: 82ff7cc6 user: stephan tags: trunk) | |
|
2023-07-25
| ||
| 12:26 | Reformulate a (sed -i) construct in ext/wasm/GNUmakefile to account for Mac's sed -i being different than GNU's. (check-in: 907dfc4a user: stephan tags: trunk) | |
|
2023-07-24
| ||
| 15:41 | Resolve an ES6 module export construct which is incompatible with node.js, as reported in forum post b9680fa9ad. (check-in: 80927c39 user: stephan tags: trunk) | |
|
2023-07-23
| ||
| 22:14 | When writing the filename header in a opfs-sahpool file, ensure that all remaining bytes in that part of the header are zeroed out to avoid the downstream problems reported in forum post d50ec48a293988a5. (check-in: c1b080e3 user: stephan tags: trunk) | |
|
2023-07-22
| ||
| 19:57 | Add the opfs-sahpool sqlite3_vfs implementation to JS, offering an alternative to the other OPFS VFS (with tradeoffs). (check-in: d2e602cd user: stephan tags: trunk) | |
|
2023-07-21
| ||
| 10:51 | Minor internal cleanups in the opfs-sahpool VFS. (Closed-Leaf check-in: 74ad31e2 user: stephan tags: opfs-sahpool) | |
| 09:10 | Internal cleanups in the async part of the JS library bootstrap phase. (check-in: b6d57ab6 user: stephan tags: opfs-sahpool) | |
|
2023-07-20
| ||
| 23:25 | Minor internal cleanups in JS code. (check-in: 21a2ca9f user: stephan tags: opfs-sahpool) | |
| 09:06 | Filter the OPFS VFSes out of the sqlite3-node.mjs build. Add another level of subdirectory to the sahpool to later enable transparent support of client-provided files under the VFS's root dir. Rework the awkward sahpool-via-oo1 mapping. (check-in: 080a4d0a user: stephan tags: opfs-sahpool) | |
|
2023-07-19
| ||
| 17:47 | More internal refactoring and docs for opfs-sahpool. (check-in: 64ccf617 user: stephan tags: opfs-sahpool) | |
| 17:46 | Update the development-over-ssh docs for the wasm build. (check-in: 500109bd user: stephan tags: opfs-sahpool) | |
| 13:31 | Major restructuring of opfs-sahpool to improve maintainability and hopefully make it easier to reuse these pieces in the upcoming JSPI-based VFS experiment. (check-in: 534481cd user: stephan tags: opfs-sahpool) | |
| 11:33 | Appearance and legibility improvements for tester1.js. (check-in: 4fd3ed1b user: stephan tags: opfs-sahpool) | |
| 08:18 | Internal refactoring in opfs-sahpool. Move OPFS tests to the end of tester1.c-cpp.js. (check-in: 6bd5a741 user: stephan tags: opfs-sahpool) | |
|
2023-07-18
| ||
| 19:47 | More opfs-sahpool tests. (check-in: 60713fa9 user: stephan tags: opfs-sahpool) | |
| 19:27 | Fix a shadowed var in opfs-sahpool and add more tests. (check-in: 9c8a73af user: stephan tags: opfs-sahpool) | |
| 18:52 | Further refactoring of opfs-sahpool and start integrating it into tester1.c-pp.js. (check-in: 91c78923 user: stephan tags: opfs-sahpool) | |
| 16:24 | Major restructuring of the opfs-sahpool bits to better support multiple instances per app (each sandboxed from each other). Eliminate the pesky promise resolution race condition when two such instances are loaded in parallel. (check-in: 95e5fa49 user: stephan tags: opfs-sahpool) | |
| 12:09 | Refactor opfs-sahpool to support multiple instances, each with a separate VFS name and directory. (check-in: d036eaf6 user: stephan tags: opfs-sahpool) | |
|
2023-07-17
| ||
| 07:43 | Another -DSQLITE_TEMP_STORE=3 to 2 change for the wasm build. (check-in: 5ad8f998 user: stephan tags: opfs-sahpool) | |
| 07:14 | sahpool vfs: rename defaultCapacity to initialCapacity, per feedback. (check-in: 2c9c95d0 user: stephan tags: opfs-sahpool) | |
| 07:13 | Change wasm build's -DSQLITE_TEMP_STORE=3 to -DSQLITE_TEMP_STORE=2, primarily so that clients can optionally shift temp files from memory to OPFS storage. (check-in: 764430e8 user: stephan tags: opfs-sahpool) | |
|
2023-07-16
| ||
| 21:07 | Remove an extraneous JS script import. (check-in: 5a205b25 user: stephan tags: opfs-sahpool) | |
| 20:42 | Add sqlite3-vfs-opfs-sahpool.js to ext/wasm/api/README.md. (check-in: 58d05201 user: stephan tags: opfs-sahpool) | |
| 20:20 | Minor doc tweaks. (check-in: 0cb0d7a9 user: stephan tags: opfs-sahpool) | |
| 19:29 | Correct a missing assignment. Minor doc additions. (check-in: 1c4957d0 user: stephan tags: opfs-sahpool) | |
| 19:20 | Doc tweaks only, no code changes. (check-in: 044c28df user: stephan tags: opfs-sahpool) | |
| 17:51 | Add a way to remove the opfs-sahpool's persistent state from OPFS or unlink() an individual file. Doc cleanups. (check-in: 80982daa user: stephan tags: opfs-sahpool) | |
| 16:52 | Move SAH pool configuration options from the library-level config to a config passed to the VFS install routine. Extend and document the PoolUtil object. (check-in: d2ed9955 user: stephan tags: opfs-sahpool) | |
| 14:07 | speedtest1.js: only install opfs-sahpool if it's provided via --vfs flag, to avoid locking errors in concurrent speedtest1 tabs with other VFSes. Add opfs-sahpool reserveMinimumCapacity(). (check-in: aa94c8ab user: stephan tags: opfs-sahpool) | |
| 12:02 | During "opfs" VFS init, check for URL param opfs-disable and, if set, do not install the VFS. Added per forum suggestion to provide a way to help rule out misinteraction between the "opfs" and "opfs-sahpool" VFSes. (check-in: 29905b7a user: stephan tags: opfs-sahpool) | |
| 11:49 | Micro-optimizations in opfs-sahpool. (check-in: 52f23db9 user: stephan tags: opfs-sahpool) | |
| 10:02 | Redefine what the opfs-sahpool installation promise resolves to. Fix addCapacity(). Add utility methods to import/export files. (check-in: 809c6f4d user: stephan tags: opfs-sahpool) | |
|
2023-07-15
| ||
| 21:08 | Minor cleanups in the opfs-sahpool VFS. (check-in: 279e0907 user: stephan tags: opfs-sahpool) | |
| 19:08 | Correct opfs-sahpool VFS after the pebkac involving the previous speedtest1 runs. Make that VFS explicitly opt-in to avoid certain unfortunate locking situations. (check-in: 41bf1fe3 user: stephan tags: opfs-sahpool) | |
| 16:30 | speedtest1 JS: only add --memdb flag by default if no --vfs is provided. (check-in: 676ffe62 user: stephan tags: opfs-sahpool) | |
| 11:37 | Rename opfs-sahpool removeCapacity() to reduceCapacity(). (check-in: fff68e9f user: stephan tags: opfs-sahpool) | |
| 11:23 | opfs-sahpool VFS now seems to work, in that it runs fine (and blazingly fast) in speedtest1. Add sqlite3.config options for the high-level configurable parts of opfs-sahpool. (check-in: 5d92d5f4 user: stephan tags: opfs-sahpool) | |
| 01:02 | More work on porting the sahpool bits. Revert to random backing-store names because it works better with the capacity-reduction algorithm. (check-in: b4e005fd user: stephan tags: opfs-sahpool) | |
|
2023-07-14
| ||
| 23:02 | Switch opfs-sahpool to use deterministic backing-store file names. Delay VFS registration until after the pool's files are all opened. Fail vfs init if the client's OPFS API has an async FileSystemSyncAccessHandle.close() method (indicating that it's outdated). (check-in: 7c6697ed user: stephan tags: opfs-sahpool) | |
| 21:48 | Integrate the opfs-sahpool VFS into the JS build and get it loading (but it's still far from functional). (check-in: ef96e6b5 user: stephan tags: opfs-sahpool) | |
| 21:17 | Initial sketches for an alternate OPFS VFS which uses a pool of pre-opened SyncAccessHandles to bypass the need for a dedicated I/O worker and the COOP/COEP HTTP response headers. Currently completely non-functional. (check-in: a93de9f2 user: stephan tags: opfs-sahpool) | |
| 21:06 | Minor internal cleanups in the OPFS VFS. (check-in: 984d491e user: stephan tags: trunk) | |
| 12:21 | Minor wasm build cleanups. (check-in: 816b503f user: stephan tags: trunk) | |
|
2023-07-13
| ||
| 18:35 | Reintroduce WASMFS+OPFS support, albeit as a separate (less portable) WASM build. (check-in: 7e4c594e user: stephan tags: trunk) | |
| 18:13 | Minor cleanups related to reintroducing wasmfs support. (Closed-Leaf check-in: 6918a927 user: stephan tags: wasmfs-2023) | |
| 17:27 | More work on the wasmfs build and its test apps. (check-in: 953b8557 user: stephan tags: wasmfs-2023) | |
| 16:33 | Get speedtest1 wasmfs variant running again. (check-in: 0f77e031 user: stephan tags: wasmfs-2023) | |
| 14:08 | Significant surgery on the wasm build on the way to incorporating wasmfs as a first-class build option. (check-in: 215c37fc user: stephan tags: wasmfs-2023) | |
| 10:41 | More work on the wasmfs build. Resolve the inconsistent argument type passed to sqlite3InitModule() in such builds. (check-in: 4850a9e2 user: stephan tags: wasmfs-2023) | |
| 04:54 | Minor cleanups in the wasmfs build. (check-in: f64477f2 user: stephan tags: wasmfs-2023) | |
| 04:26 | Get wasmfs build and its bare-bones test app working again, albeit currently in ES6 mode only. (check-in: 647761ed user: stephan tags: wasmfs-2023) | |
| 03:46 | Replace 'self' with 'globalThis' in some JS test code. (check-in: 53eeffc9 user: stephan tags: trunk) | |
| 01:51 | JS: change the default OPFS VFS journal mode from PERSIST to DELETE, as DELETE is faster in current browsers. (check-in: a061a43e user: stephan tags: trunk) | |
| 01:48 | Remove obsolete ext/wasm/api/sqlite3-wasi.h. (check-in: f661a6e0 user: stephan tags: trunk) | |
|
2023-07-12
| ||
| 09:30 | Internal JS doc fix. (check-in: 7c5ea022 user: stephan tags: trunk) | |
| 09:16 | Correct handling of the speedtest1 --without-rowid flag in the HTML front-end to speedtest1.wasm. Reduce default speedtest1-with-OPFS workload size in ext/wasm/index.html to speed up manual testing. (check-in: 2daba2cd user: stephan tags: trunk) | |