SQLite

Timeline
Login

50 most recent check-ins

2026-04-23
22:15
Improved default prompt in the CLI. (leaf check-in: 78193b6034 ... user: drh tags: trunk)
20:13
Fix harmless compiler warnings. Enhance the CLI prompt mechanism to make it more easily reusable by other projects, and to add the /h, /H, and /u escape sequences. (check-in: 354ce4f5e2 ... user: drh tags: trunk)
20:06
Fix a bug in [dbc1d6f0a3452607] that disrupts the display when running on a Windows console (not redirecting to a file). (check-in: 75b5df2b00 ... user: drh tags: trunk)
16:40
Improvements to the #define mechanism in the CLI that allows other programs that incorporate the shell.c source file to customize some of the prompt expansions. (check-in: e5f8840d11 ... user: drh tags: trunk)
15:54
Have testrunner.tcl return a non-zero exit status if one or more tests have failed. (check-in: 50ddc36d32 ... user: dan tags: trunk)
15:05
New CLI prompt escape sequences: /r, /A, /v, /V, and /D../D. (check-in: e7c7acd1a4 ... user: drh tags: trunk)
14:49
Fix harmless compiler warning. (check-in: 706373dcbe ... user: drh tags: trunk)
14:05
CLI shell: handle the special case of .prompt "" to not incorrectly report that as an OOM. Reported in the Fossil SCM forum. (check-in: 3fa0500b96 ... user: stephan tags: trunk)
11:33
Update interrupt2.test to avoid using Tcl_GetCommandInfo() from within calls to Tcl_DeleteCommand(). (leaf check-in: 00daafed79 ... user: dan tags: branch-3.53)
2026-04-22
20:02
Merge trunk enhancements into the reuse-schema branch. (leaf check-in: 578bfc438a ... user: drh tags: reuse-schema)
19:51
Merge recent trunk enhancements into bedrock via wal2. (leaf check-in: ec9bab4d19 ... user: drh tags: bedrock)
19:50
Merge recent trunk enhancements into the begin-concurrent branch. (leaf check-in: 7f954a9e2f ... user: drh tags: begin-concurrent)
19:47
Merge the latest trunk enhancements into the wal2 branch. (leaf check-in: 28d1d29ad4 ... user: drh tags: wal2)
19:38
When updating indexes on expressions, omit the update if the new indexed values are the same as the old. (check-in: f0fc4e5ec3 ... user: dan tags: trunk)
19:25
Add OOM test for the new code on this branch. (closed check-in: 685be705a2 ... user: dan tags: index-detect-noop)
19:12
Mark branches that are believed to be unreachable. (check-in: 18ed9736fb ... user: drh tags: index-detect-noop)
18:19
Instead of adding a branch to OP_IdxInsert, use an extra OP_IfNull when updating indexes on expressions. (check-in: 5112f96cb1 ... user: dan tags: index-detect-noop)
17:50
Enable the optimization on this branch for indexes on expressions only. (check-in: 3576b69304 ... user: dan tags: index-detect-noop)
17:31
Fix P3/P5 confusion in the comment above OP_IdxDelete. (check-in: 0fb6ca8e22 ... user: dan tags: index-detect-noop)
16:58
Detect and omit cases where an index key is being replaced with an identical key. (check-in: 7a01caf0d0 ... user: dan tags: index-detect-noop)
13:41
Fix a integer type bug in the previous check-in. (check-in: 5e1b5ff1c1 ... user: drh tags: trunk)
12:22
QRF and the CLI preserve zero bytes when outputing unformatted BLOB values. (check-in: dbc1d6f0a3 ... user: drh tags: trunk)
2026-04-21
22:55
Various minor bug fixes cherrypicked from trunk. (check-in: f1276db5da ... user: drh tags: branch-3.53)
22:19
Fix harmless compiler warning in QRF. (check-in: dcfb505ac7 ... user: drh tags: trunk)
20:40
Disable optimization of nested EXIST loops. Possible fix for forum post 77c02e8ed. (check-in: d0d95a39bc ... user: dan tags: trunk)
20:28
Fix the BETWEEN operator so that it propagates the EP_Subquery, EP_Collate, and EP_HasFunc flags in the expression tree, as it ought. Fix for the problem reported at forum post 2026-04-21T19:10:55Z and probably a bunch of other problems too. This has been incorrect for a long time. (check-in: 2d1d2947b2 ... user: drh tags: trunk)
18:07
Correctly dequote the constraint name passed to ALTER TABLE DROP CONSTRAINT. This improves upon the partial fix in [7f5afb12f4]. Forum post a746b08b87. (check-in: 9387238cb0 ... user: dan tags: trunk)
16:40
Disable optimization of nested EXIST loops. Possible fix for forum post 77c02e8ed. (closed check-in: 64f0d9eb63 ... user: dan tags: disable-nested-exist-opt)
16:07
Fix an off-by-one buffer size calculation in the decimal.c extension. (check-in: 24df42104d ... user: drh tags: trunk)
14:39
Do not unnecessarily delay opening the database file in the CLI. (check-in: ab6ee76c12 ... user: drh tags: trunk)
13:06
Fix another bug in EXISTS-to-JOIN - this one having to do with an OFFSET clause of a LIMIT. (check-in: f91099ecee ... user: drh tags: branch-3.53)
12:59
Fix another bug in EXISTS-to-JOIN - this one having to do with an OFFSET clause of a LIMIT. Reported by forum post 2026-04-21T10:57:09Z. (check-in: 1dd3c6a5e5 ... user: drh tags: trunk)
11:01
Experimental changes to star-query planning heuristics. (leaf check-in: edabcc0559 ... user: drh tags: star-query-experimental)
10:19
Reformulate how the OPFS async proxy Worker is loaded for the bundler-friendly builds to work around a bug in Vite in which it incompatibly rewrites the Worker's URL arguments. Addresses the discussion at npm package PR 159 and patch validated by Jure Rotar. (check-in: ec877a30f5 ... user: stephan tags: trunk)
10:15
Reformulate how the OPFS async proxy Worker is loaded for the bundler-friendly builds to work around a bug in Vite in which it incompatibly rewrites the Worker's URL arguments. Addresses the discussion at npm package PR 159 and patch validated by Jure Rotar. (check-in: 6215c9dd27 ... user: stephan tags: branch-3.53)
2026-04-20
10:28
Fix the fileio extension for Windows builds so that it does not depend on the sqlite3_win32_utf8_to_unicode() and sqlite3_win32_unicode_to_utf() routines that are found in the SQLite core. Forum post 2026-04-20T02:02:56Z. (check-in: fe0414a9a3 ... user: drh tags: trunk)
2026-04-18
21:51
Fix a harmless compiler warning in test/speedtest1.c. (check-in: 13f0fd1daa ... user: drh tags: trunk)
12:31
Performance improvement in the substr() and length() SQL functions. Caution: The new code may give different results for malformed UTF8. I do not consider that to be a problem by the GI/GO principle. (check-in: 6124d27a33 ... user: drh tags: trunk)
2026-04-17
19:12
Fix a test case that started failing due to a change in the help text for the ".prompt" command of the CLI. (check-in: bfe9df1bf4 ... user: drh tags: trunk)
15:09
Update interrupt2.test to avoid using Tcl_GetCommandInfo() from within calls to Tcl_DeleteCommand(). (check-in: 1979aa0902 ... user: dan tags: trunk)
11:41
Help-text and comment fixes in the CLI. Add the output-redir-test.txt testing script. (check-in: ec58a133b4 ... user: drh tags: trunk)
04:59
On platforms which support ./configure --with-icu-config, ensure that 'make tclextension' includes the ICU pieces in the tcl extension. Intended to resolve forum post 92a88de4b88929fe. (check-in: a4f27adb97 ... user: stephan tags: branch-3.53)
01:55
Fix parsing of options to the .once command. (check-in: fd21b079e9 ... user: drh tags: branch-3.53)
01:50
Less error-prone parsing of ".once" options. Fix for the problem reported by forum post 2026-04-17T01:26:56Z. (check-in: b235a80937 ... user: drh tags: trunk)
2026-04-16
19:50
Fix testrunner.tcl so that it does not create directories with names ending in "sqlite3.o" or "sqlite3.lo". Use "sqlite3obj" for those directory names instead. Otherwise "make clean" gets confused. (check-in: a4bf9289c9 ... user: drh tags: trunk)
19:33
Improved comments explaining the logic, and improved diagnostic messages when testrunner.tcl encounters trouble loading the sqlite3 extension. (check-in: 8d820b0ccf ... user: drh tags: trunk)
17:07
Minor updates to testrunner documentation. (check-in: f8507bd5e2 ... user: drh tags: trunk)
16:43
Run C-language tests in tests/c/ as part of release test. (check-in: e6929022b7 ... user: dan tags: trunk)
13:07
Tentatively change the name of the new ".dbstat" dot-command to ".inspect" as suggested by forum post 2026-04-15T01:09:41 (leaf check-in: 8f0275d65c ... user: drh tags: dbstat-to-inspect)
2026-04-15
19:09
Version number to 3.53.1 (check-in: b4c1cc5efc ... user: drh tags: branch-3.53)
More ↓