SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent check-ins

2025-07-18
22:18
Add SQLITE_SELFORDER1 to JS's sqlite3.capi namespace. It's only useful when built with an sqlite3.c which itself was created with -DSQLITE_ENABLE_ORDERED_SET_AGGREGATES, which the canonical build does not do but custom builds may. (Leaf check-in: fdd15e938c user: stephan tags: trunk)
19:17
Fix a minor comment inaccuracy. (check-in: b66fcb61a1 user: drh tags: trunk)
17:40
Increase the precision of the "real time" output from the ".timer" command in the CLI from milliseconds to microseconds. (check-in: c5dbe93114 user: drh tags: trunk)
12:22
Ensure that the accumulator for an aggregate always gets initialized, even when the aggregate is on the right side of a LEFT JOIN and never gets evaluated. Also increment the version number. (Leaf check-in: 53711bf9f6 user: drh tags: branch-3.50)
12:10
Ensure that the accumulator for an aggregate always gets initialized, even when the aggregate is on the right side of a LEFT JOIN and never gets evaluated. This fixes a problem introduced by [663f5dd32d9db832] and found by dbsqlfuzz. Test cases in TH3. (check-in: 235cf6586b user: drh tags: trunk)
2025-07-17
19:18
Pedantic internal build doc fix. (check-in: 9ef429a850 user: stephan tags: trunk)
15:38
Merge the latest trunk enhancments into the reuse-schema branch. (Leaf check-in: 12dbb05b84 user: drh tags: reuse-schema)
15:31
Merge all of the trunk enchancements into the bedrock branch. (Leaf check-in: ba2174bdca user: drh tags: bedrock)
15:24
Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: 69794955d8 user: drh tags: wal2)
15:18
Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 0b2979f0c0 user: drh tags: begin-concurrent)
14:02
Merge the 3.50.3 changes into the reuse-schema-3.50 branch (Leaf check-in: 5a70ffd63c user: drh tags: reuse-schema-3.50)
13:25
Version 3.50.3 (check-in: 3ce993b865 user: drh tags: release, branch-3.50, version-3.50.3)
2025-07-16
20:50
Diverse wasm build cleanups. (check-in: 14ca18f72a user: stephan tags: trunk)
18:51
Code style conformance tweaks and remove a ref to a now-dead makefile var. (Closed-Leaf check-in: a3cec8c714 user: stephan tags: wasm-build-parallel)
17:24
Fix vtabH.test so that it works on windows even if there are files that begin with "$" in the root directory. (check-in: 19a79219a7 user: dan tags: trunk)
17:00
Build .wasm/.js files into a build-mode-specific subdir, the goal being to be able to build them in parallel. This works, but (A) adds a bit of build ugliness and (B) is not actually parallelizing, so needs a closer look after a break. (check-in: 5e11d05412 user: stephan tags: wasm-build-parallel)
16:56
Remove some stray makefile debug output. (check-in: 7ef22c3d11 user: stephan tags: trunk)
14:51
In the wasm makefiles, replace X:=Y with X=Y because := has different semantics depending on the make impl and its use is arguably a bad muscle-memory habit worth breaking. These makefiles are very specifically for GNU make, but long-term it would be nice to eliminate that requirement. (check-in: d4203311a2 user: stephan tags: trunk)
13:22
wasm: remove some extraneous levels of makefile var and fix the (unsupported) wasmfs speedtest1 build to account for var renaming which happened long before this. (check-in: 35b2315343 user: stephan tags: trunk)
11:56
Remove an unnecessary step from the wasm builds and account for a recent Emscripten-internal code-generation change which caused a post-build cleanup step to not actually clean up (harmless, but adds about 26k of useless stuff to the resulting JS). (check-in: a8ed16989d user: stephan tags: trunk)
11:09
Further internal wasm build cleanups. No functional changes. (check-in: 8364d89c3b user: stephan tags: trunk)
10:34
Internal refactoring of the WASM build makefile rule generator, working towards parallelizing the various build modes (which is not currently possible because most modes share the same sqlite3.wasm output file name). (check-in: 1062b61e9c user: stephan tags: trunk)
09:27
Teach the sqlite3 CLI shell to look in XDG_STATE_HOME for the CLI history file before falling back to its historical location in the user's home directory. (check-in: 1e663374c3 user: stephan tags: trunk)
09:20
Squelch a legitimate but harmless 'discards const' warning. (Closed-Leaf check-in: 73539fe093 user: stephan tags: shell-xdg-vars)
2025-07-15
19:00
Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Fix for forum post 428ef7c468. (check-in: 9f184f8dfa user: dan tags: trunk)
18:51
Add test case to between.test. (Closed-Leaf check-in: ffebbb7ae9 user: dan tags: vtab-leftjoin-fix)
17:03
Have SQLite request a plan with no setup-cost from xBestIndex if the plan in question may only be used as the outermost loop of the query. (Leaf check-in: c3740ef6e4 user: dan tags: vtab-setup-cost)
14:21
Optimize allocation of large tombstone arrays in fts5. (check-in: 63595b7495 user: drh tags: branch-3.50)
14:06
Optimize allocation of large tombstone arrays in fts5. (check-in: 0fcc3cbdfa user: dan tags: trunk)
11:27
Fix the date in bestindexE.test. (check-in: f3fdcfa183 user: dan tags: vtab-setup-cost)
2025-07-14
18:59
Add comments to sqlite.h.in describing the change on this branch. (check-in: 19038620cd user: dan tags: vtab-setup-cost)
18:27
Add the snapshot-zip makefile targets for both Windows and Posix. (check-in: 8c73c0c593 user: drh tags: trunk)
18:03
Merge latest trunk changes into this branch. (check-in: 8f9d6acaf7 user: dan tags: vtab-setup-cost)
16:05
Enhance the "mktoolzip.tcl" script (used by the "tool-zip" makefile target) so that it uses "fossil test-filezip" to build the ZIP archive if available, and so that it also generates windows-dll-*.zip on Windows platforms. (check-in: 63ddc215eb user: drh tags: trunk)
15:40
In rtree.c, ensure that the pReadAux statement is reset whenever the bAuxValid flag is cleared. Fix for forum post 3e45ed31d8. (check-in: 3c0afda372 user: dan tags: trunk)
15:34
In rtree.c, ensure that the pReadAux statement is reset whenever the bAuxValid flag is cleared. Possible fix for forum post 3e45ed31d8. (Closed-Leaf check-in: 1740f9a098 user: dan tags: rtree-aux-column-fix)
14:51
Add new sessions function sqlite3changeset_apply_v3() and its streaming equivalent. This allows changesets to be filtered on a per-change basis, not just per-table. (check-in: 10ebd7a119 user: dan tags: trunk)
09:41
Fix harmless compiler warnings in builds that use SQLITE_OMIT_DATETIME_FUNCS. (check-in: e11fbf9fd6 user: drh tags: trunk)
2025-07-12
18:14
Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Possible fix for forum post 428ef7c468. (check-in: 18ba07c152 user: dan tags: vtab-leftjoin-fix)
16:35
Experimental change to allow virtual table xBestIndex() methods to specify an initial setup cost for a plan. (check-in: b67babf1ab user: dan tags: vtab-setup-cost)
2025-07-11
19:52
wasm: introduce the sqlite3.oo1.DB.wrapHandle() and Stmt.wrapHandle() APIs, which enable clients to wrap (sqlite3*) resp. (sqlite3_stmt*) pointers in their oo1 API counterparts, optionally with or without taking over ownership of the pointer. (check-in: e5d0795495 user: stephan tags: trunk)
19:44
Clearer docs for the unowned db/stmt handle mechanism. (Closed-Leaf check-in: 53401b5435 user: stephan tags: oo1-unowned-handles)
19:34
Correct a one-too-many-exclamation-points bug which caused the opposite of intended semantics in oo1.Stmt.pointer ownership. (check-in: 91e709f36d user: stephan tags: oo1-unowned-handles)
17:02
Additional header comment documentation in the ext/misc/vtablog.c test extension. (check-in: 3656acfaa3 user: drh tags: trunk)
14:18
Merge trunk into column-text-blob-v2 branch. (Leaf check-in: a5369e67f7 user: stephan tags: column-text-blob-v2)
12:56
Add column/value_text/blob_v2() to the sqlite3_api object. (check-in: ae29cc3135 user: stephan tags: column-text-blob-v2)
11:06
speedtest1: in WASM builds, disable the "app" test set by default because that one set is triggering file-not-found errors for the db file for reasons not yet understood. (check-in: 9d68971c58 user: stephan tags: trunk)
10:27
Do not export the numerous Emscripten HEAPxy symbols and remove the last remaining JS code which references them. They have long-since been replaced by internal equivalents and a specific feature check on one of them (which is also no longer needed) is triggering an exception from Emscripten. More details are in Emscripten ticket #24656, noting that this is not an Emscripten bug but an Emscripten behavior change brought it to light. (check-in: b9462dc146 user: stephan tags: trunk)
2025-07-10
20:45
Improve the accuracy of the ETC on both devtest and releasetest. (check-in: a3f96cafdc user: drh tags: trunk)
17:19
Add the estkey column to the jobs table of testrunner.db. The plan is to use this to collect measurements that will help generate improved ETAs for a test run. (check-in: 9eccf5267c user: drh tags: trunk)