SQLite

Timeline
Login

50 most recent check-ins

2026-03-11
15:17
Replace several comment-based switch-fall-through notices with attribute based ones, as suggested in forum post b6ab8dc547. (leaf check-in: 2b0209a3bd ... user: stephan tags: trunk)
14:43
Improved defenses against mischief. (check-in: 8bdc0d485e ... user: drh tags: trunk)
2026-03-10
22:43
Fix harmless compiler warnings. (check-in: d7b4a4a3d3 ... user: drh tags: trunk)
21:07
Fix the behavior dot-commands that appear as command line arguments to the CLI so that their effect persists into subsequent commands on the command line. This fix also improves error messages caused by command line arguments. (leaf check-in: 236ab102df ... user: drh tags: branch-3.52)
21:01
Fix the behavior dot-commands that appear as command line arguments to the CLI so that their effect persists into subsequent commands on the command line. This fix also improves error messages caused by command line arguments. Forum post 2026-03-10T19:26:06z. (check-in: ff084ae341 ... user: drh tags: trunk)
18:13
Revamp the QRF insert-mode optimization of [659ff6ab55802507]. The control value is now nMultiInsert. Multiple rows are added to each INSERT statement until the number of bytes in that statement exceeds the nMultiInsert value. The CLI uses a default value of 3000, which provides a good balance between speed and prepare-statement size. The output from ".dump" now loads nearly 2x faster in some cases. (check-in: 55b0ce9f93 ... user: drh tags: trunk)
15:46
Bug fix to the ".dump" command in the CLI: Temporarily disable character limit to QRF so as not to truncate values in the generated output. (check-in: 72414aff72 ... user: drh tags: branch-3.52)
15:43
Bug fix to the ".dump" command in the CLI: Temporarily disable character limit to QRF so as not to truncate values in the generated output. (check-in: f6787e4b50 ... user: drh tags: trunk)
14:02
Enhance QRF with the mxTuple field, which if greater than 1 causes the QRF_STYLE_Insert style to group as many as mxTuple adjacent rows into a single INSERT statement. The field is accessible using the -mxtuple option in the TCL interface, and the --mxtuple option in ".mode". The output of the ".dump" and ".fullschema" commands responds to the current --mxtuple setting. (check-in: 659ff6ab55 ... user: drh tags: trunk)
2026-03-09
14:04
Remove an obsolete pragraph from the header comment on the fileio.c extension. (check-in: 17613b72f3 ... user: drh tags: trunk)
13:53
In QRF, fix line-wrap indentation for "line" mode when using a non-standard column separator. (check-in: 00c96cca3d ... user: drh tags: trunk)
12:11
Fix a problem with RIGHT JOIN and expressions on indexes. (check-in: 9c64a31248 ... user: drh tags: branch-3.52)
11:49
Fix a problem with RIGHT JOIN and expressions on indexes. Forum post e3dba5426a. (check-in: f27d578eda ... user: dan tags: trunk)
2026-03-08
19:36
Fix the completion.c TVF so that the xNext method reports errors it encounters while running queries. (check-in: 96a82dda7a ... user: drh tags: branch-3.52)
19:31
Fix the completion.c TVF so that the xNext method reports errors it encounters while running queries. (check-in: eebcdcceef ... user: drh tags: trunk)
18:53
In the decimal.c extension, set a default MAX_DIGITS to 100 million. Do not allow integer overflow of the N parameter to the internal decimal_round() function. (check-in: a4807bb5f4 ... user: drh tags: branch-3.52)
18:50
In the decimal.c extension, set a default MAX_DIGITS to 100 million. Do not allow integer overflow of the N parameter to the internal decimal_round() function. (check-in: d0e23423d1 ... user: drh tags: trunk)
17:07
Consolidate the opfs and opfs-wl tester1 tests using the preprocessor. (check-in: 77846c8c7a ... user: stephan tags: trunk)
16:03
Upgrade ext/wasm/c-pp-lite.c to its newer sibling because we've reached the older one's limits. This renames c-pp-lite.c to libcmpp.c to maintain both the SCM- and code lineage but that may end up looking a bit weird because the diff between the two is vast. (check-in: 2e2339bd9e ... user: stephan tags: trunk)
12:42
JS doc updates. (check-in: 699295f84e ... user: stephan tags: trunk)
10:51
Increase the version number on trunk to 3.53.0 (check-in: 0152b445ff ... user: drh tags: trunk)
10:48
Add parens around an expression in the CLI shell to account for operator precedence, as reported in forum post 856ff7a2f1. (check-in: a334868f27 ... user: drh tags: branch-3.52)
10:44
Continue fixes to 3.52 on a branch. (check-in: d99d42c885 ... user: drh tags: branch-3.52)
08:32
Merge opfs-wl into trunk, not so much for the "opfs-wl" VFS, which is stil tentative (working fine but with little perceived benefit), but for the "opfs" VFS cleanups which necessarily happened around it. (check-in: bcaa876c6d ... user: stephan tags: trunk)
08:09
Update the tester1 SEE tests to account for opfs-wl. (closed check-in: 616d32c838 ... user: stephan tags: opfs-wl)
07:58
Refactor tester1 OPFS test to support both the "opfs" and "opfs-wl" VFSes. (check-in: 17ac8d7bdf ... user: stephan tags: opfs-wl)
07:02
Add parens around an expression in the CLI shell to account for operator precedence, as reported in forum post 856ff7a2f1. (check-in: da3ad170ae ... user: stephan tags: trunk)
05:53
Expose sqlite3_bind_zeroblob() to JS/WASM. (check-in: 0c5d4fe0bd ... user: stephan tags: trunk)
2026-03-07
22:37
Use the UINT64_C() macro rather than the LLU suffix on integer literals for portability to older Microsoft compilers. Forum thread 0a9ffaff6fcdedb3. (check-in: 27be26566f ... user: drh tags: trunk)
21:07
Give the fuzzcheck test program access to all the same extensions that dbsqlfuzz has access to. (check-in: d9c23b49e3 ... user: drh tags: trunk)
17:50
Fix harmless compiler warnings on Windows. (check-in: 358d78da75 ... user: drh tags: trunk)
15:15
Minor typo fixes from forum post 8fc8bc34291d6f45. (check-in: c8fb88c19e ... user: stephan tags: trunk)
12:00
An attempt to get the CLI build to work with mingw32. Forum post 086cb1ef66. (check-in: d95b9e7c17 ... user: drh tags: trunk)
11:23
Fix another memory leak following OOM in the decimal extension. (check-in: 414f6dbc09 ... user: drh tags: trunk)
06:10
Extend the JS pre-bootstrapping configuration to include an option to disable inclusion of any given extension VFS (not the default VFSes, like memdb). The primary motivation for this is to give people who don't use OPFS to a way to keep the OPFS VFSes from loading their proxy workers, which are expensive. (check-in: 9a07eb7a94 ... user: stephan tags: opfs-wl)
04:19
Fix the mangling of the opfs async proxy script's URI caused by both OPFS VFSes modifying it to accound for sqlite3.dir. Add a link to speedtest1 with opfw-wl to index.html. (check-in: c1cb61f473 ... user: stephan tags: opfs-wl)
03:32
Cleanups and docs in the opfs vfs and its concurrency tester. Experimentally add sqlite3.capi.sqlite3_js_retry_busy(), which runs a callback repeatedly until it _stops_ returning (or throwing) an SQLITE_BUSY error. (check-in: 45c02ed216 ... user: stephan tags: opfs-wl)
03:29
Elide more of the 64-bit was stuff from the default build target. (check-in: 3b74ad9081 ... user: stephan tags: opfs-wl)
02:42
Enhancements and fixes to some of the extensions used in the CLI so that they can be fuzzed using dbsqlfuzz. (check-in: d800ea06d2 ... user: drh tags: trunk)
02:36
The optional SQLITE_DECIMAL_MAX_DIGIT compile-time option limits the maximum number of digits that the decimal extension will operate on. (closed check-in: 4214485b2f ... user: drh tags: extfunc-fuzz)
02:19
Cleanups and docs in the new opfs code structure. (check-in: 3b470c4c7a ... user: stephan tags: opfs-wl)
01:01
For backwards compatibility, ensure that the "opfs" VFS does not specifically require Atomics.waitAsync() (a new requirement of "opfs-wl"), but make use of it if available. Only apply jitter to the concurrency test runs at random intervals. (check-in: f2175f526c ... user: stephan tags: opfs-wl)
00:14
Reenable the is_base85() extension function that was disabled by [af18b68978ec9b1f]. (check-in: be07c16e3a ... user: drh tags: extfunc-fuzz)
00:10
Fix another NULL ptr deref following OOM in the sha1 extension. (check-in: c4843e4cce ... user: drh tags: extfunc-fuzz)
00:03
Fix a NULL pointer dereference following OOM in the sha1 extension. (check-in: 530b3f97ca ... user: drh tags: extfunc-fuzz)
2026-03-06
23:58
Fix a NULL pointer dereference following OOM in the decimal extension. (check-in: de37f30b21 ... user: drh tags: extfunc-fuzz)
23:56
Fix a memory leak following OOM in the completion extension. (check-in: ff5b1efbf8 ... user: drh tags: extfunc-fuzz)
23:50
Add some jitter and duration info to the opfs concurrency tester. Ensure that Atomics.waitAsync() is available for opfs-wl. Further testing has shown that Web opfs-wl is consistently fairer about doling out contested locks but it's dog slow compared to the original VFS under moderate concurrency. In single-connection use they're effectively on par. (check-in: a9aecc9875 ... user: stephan tags: opfs-wl)
23:37
Fix a memory leak in the decimal extension that follows an OOM. (check-in: 8d59e47e7a ... user: drh tags: extfunc-fuzz)
22:21
Get "opfs" and "opfs-wl" properly split. Speedtest1 and the concurrency tester are happy with opfs-wl but it is not yet plugged in to tester1. (check-in: 12dcd54259 ... user: stephan tags: opfs-wl)
More ↓