SQLite

Timeline
Login

50 most recent check-ins

2026-04-18
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. (leaf 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. (leaf 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)
17:13
Handle a special case of a corrupt changeset in sqlite3changegroup_add(). (check-in: dceee93ab3 ... user: dan tags: branch-3.53)
16:22
Handle the case where the name of the constraint in an "ALTER TABLE DROP CONSTRAINT" command is quoted. Forum post 8bfbaec404. (check-in: 2d37af77a1 ... user: dan tags: branch-3.53)
14:41
The sqlite3_str_new() interface never returns NULL, even after an OOM. Code that uses that interface should invoke sqlite3_str_errcode() to see if an OOM has occurred. (check-in: cb910047ed ... user: drh tags: trunk)
14:22
Bug fix in sqlite3_str_free(): Do not crash if called on an sqlite3_str object returned from sqlite3_str_new() following an OOM. (check-in: b6b1d069cd ... user: drh tags: branch-3.53)
14:17
Bug fix in sqlite3_str_free(): Do not crash if called on an sqlite3_str object returned from sqlite3_str_new() following an OOM. (check-in: 92d8ac0c49 ... user: drh tags: trunk)
13:05
Add support for the analyze() extension function to the fuzzcheck test program. (check-in: abd94554d2 ... user: drh tags: trunk)
12:47
Improve the analyze() extension so that it returns a simple error message as text (it does not throw an error) if the database is empty or is "temp" or does not exist. (check-in: 35379f6092 ... user: drh tags: trunk)
12:35
Fix harmless compiler warnings seen by MSVC in the previous check-in. Also add ext/misc/analyze.c to the makefile dependencies for the CLI. (check-in: 5a0ee6e227 ... user: drh tags: trunk)
12:20
Add the analyze() SQL function implemented the ext/misc/analyze.c extension (but not part of the amalgamation). Make that function available in the CLI and add a new ".dbstat" command to the CLI using that function. (check-in: 4c4988e56d ... user: drh tags: trunk)
11:58
Add a missing open_db() call in the new ".dbstat" command of the CLI. (closed check-in: a138e44a24 ... user: drh tags: analyze-sql-func)
11:41
Add the .dbstat command to the CLI. (check-in: fdba76df2b ... user: drh tags: analyze-sql-func)
11:40
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: 404fde8bac ... user: stephan tags: trunk)
11:23
Avoid a potentially undefined left-shift in the fts5 porter tokenizer. (check-in: 46a288e43e ... user: dan tags: trunk)
11:07
Handle the case where the name of the constraint in an "ALTER TABLE DROP CONSTRAINT" command is quoted. Forum post 8bfbaec404. (check-in: 7f5afb12f4 ... user: dan tags: trunk)
10:49
Compute the average fanout for b-trees of depth 2 or more. (check-in: 2f8598bb09 ... user: drh tags: analyze-sql-func)
2026-04-14
23:53
Minor doc typo fixes contributed by BrickViking. (check-in: c4660ce205 ... user: stephan tags: trunk)
23:19
Code simplifications. Return NULL is the specified SCHEMA does not exist. (check-in: 953969c881 ... user: drh tags: analyze-sql-func)
20:18
Handle a special case of a corrupt changeset in sqlite3changegroup_add(). (check-in: eba625f917 ... user: dan tags: trunk)
20:17
Have the session module detect some corrupt changesets earlier. (closed check-in: 0de91ff0d7 ... user: dan tags: corrupt-changeset_fix)
20:17
Merge trunk enhancements and fixes into the analyze-sql-func branch. (check-in: bb4a9beac8 ... user: drh tags: analyze-sql-func)
20:07
Various minor tweaks and refinements to the analyze() function. (check-in: 48d94e72ea ... user: drh tags: analyze-sql-func)
20:02
Handle a special case of a corrupt changeset in sqlite3changegroup_add(). (check-in: 49b3bac482 ... user: dan tags: corrupt-changeset_fix)
19:36
Implementation of the analyze() SQL function is now mostly complete. (check-in: 1ca0386ab2 ... user: drh tags: analyze-sql-func)
19:02
Much, but not all, of the report generation is added. An incremental check-in. (check-in: 289fefc3ed ... user: drh tags: analyze-sql-func)
18:12
Ensure c-tests use the locally built sqlite3.h file, not the system copy. (closed check-in: 2d81ee65ff ... user: dan tags: c-tests)
18:08
In RBU vacuum commands, do as SQLite does and ignore any trailing SQL statements in the sql column of the sqlite_schema table. (check-in: cf7dad1b10 ... user: dan tags: trunk)
18:06
Check-in [495e4851d4296b49] breaks the build for Windows. Fixed here. (check-in: 5b004348c3 ... user: drh tags: trunk)
13:18
Further fixes and clarifications. Now ready to start generating the actual report. (check-in: 037a0e586c ... user: drh tags: analyze-sql-func)
12:46
Further improvements to error messages and robustness. (check-in: 45917c1124 ... user: drh tags: analyze-sql-func)
12:23
Improved error messages and robustness. (check-in: c09ed9eb91 ... user: drh tags: analyze-sql-func)
11:25
Initial prototype implementation of a new run-time loadable SQL function to do approximately the same work as sqlite3_analyze. (check-in: 03934b5a6c ... user: drh tags: analyze-sql-func)
02:09
Minor README typo fix reported off-list by BrickViking. (check-in: aa3432af90 ... user: stephan tags: trunk)
00:48
Pass the ICU-related build flags through the 'tclextension' target, not just 'tclextension-install'. (closed check-in: 499c89f874 ... user: stephan tags: tclextension-icu)
00:11
Tweak 'make tclextension' to pass on any --with-icu-config build flags so that it can link with the various ICU libs. This works for me but needs testing on a wider selection of systems before being moved to trunk. Intended to resolve forum post 92a88de4b88929fe. (check-in: a8c022d794 ... user: stephan tags: tclextension-icu)
2026-04-13
17:33
Fix typos and inaccuracies in comments. No changes to code. (check-in: a6c2d7ce84 ... user: drh tags: trunk)
12:22
".prompt" command improvements in the CLI: Guard against mistakenly saying ".prompt show" without the "--" before "show". Add the --hard-reset option to .prompt to make it more easily testable. (check-in: 495e4851d4 ... user: drh tags: trunk)
11:34
Improvements to the prompt_filename() function in the CLI so that it finds the database filename even if the connection is not yet fully open. (check-in: efb3e808a0 ... user: drh tags: trunk)
More ↓