SQLite

Timeline
Login

50 most recent check-ins

2026-04-14
23:53
Minor doc typo fixes contributed by BrickViking. (leaf check-in: c4660ce205 ... user: stephan tags: trunk)
23:19
Code simplifications. Return NULL is the specified SCHEMA does not exist. (leaf 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. (leaf 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'. (leaf 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)
11:20
Update test/c/snprintf1.c to test the result of the sqlite3_snprintf() call. Also add an SQLITE_OMIT_AUTOINIT configuration and update C tests to account for it. (check-in: 30b597d797 ... user: dan tags: c-tests)
10:56
Latest upstream jimsh0.c. (check-in: 414ae4dd65 ... user: stephan tags: trunk)
2026-04-12
17:47
Doc typo fix which broke the docsrc build, reported by BrickViking. (check-in: 3c212b5d85 ... user: stephan tags: trunk)
10:46
Bug fix in the revised ".prompt" command of the CLI, with test cases. (check-in: 7583385593 ... user: drh tags: trunk)
05:43
Fix a typo which caused .headers to not show up in the shell's .help. (leaf check-in: 9efc1b6497 ... user: stephan tags: branch-3.53)
05:41
Fix a typo which causes .headers to not show up in the shell's .help. (check-in: d379b14a48 ... user: stephan tags: trunk)
2026-04-11
23:58
Change the prompt escape design yet again, to use / as the escape character, since % and just about every other punctuation character is special to cmd.exe, batch files, and nmake, on Windows. (check-in: 79a8d3edf8 ... user: drh tags: trunk)
22:58
CLI prompt design change: The escape character is changed from \ to %#37;. This avoids lots of quoting problems when trying to specify prompt strings in various programming languages and shells. (check-in: e7e6ecc45d ... user: drh tags: trunk)
22:18
Two C-preprocessor macros SQLITE_PS1 and SQLITE_PS2 can be set to override the default prompt strings in the CLI. (check-in: 6fa0216a19 ... user: drh tags: trunk)
20:53
Make sqlite3_incomplete() available to extensions. (check-in: 50d81300ba ... user: drh tags: trunk)
20:43
When fiddle terminal mode is enabled, add a link to the jquery.terminal project in the About box. (check-in: d64f0c8845 ... user: stephan tags: trunk)
20:41
Fix harmless UB in sqlite3_incomplete(). (check-in: 8dfdff559f ... user: drh tags: trunk)
20:31
fiddle: disable jquery.terminal's pre-processing of user input, as discussed in forum post c6665017c0dbba1f, with many thanks to the jquery.terminal team for this workaround. (check-in: ea7e121ab2 ... user: stephan tags: trunk)
18:38
Improvements to the interactive prompt in the CLI: (1) CLI honors SQLITE_PS1 and SQLITE_PS2 envvars as prompt strings, (2) CLI prompt strings expand various backslash escapes, (3) No arbitrary length limits on CLI prompt strings, (4) New default prompt shows the database filename using the \f escape, (5) SQLite core adds the sqlite3_incomplete() API, used by the \H escape in prompt string rendering, (6) Enhancements to the ".prompt" dot-command. (check-in: 55af98054e ... user: drh tags: trunk)
18:05
Fixes for running C tests on windows. (check-in: 1fcacdc41a ... user: dan tags: c-tests)
17:47
Fix harmless compiler warnings. (closed check-in: 3b4cc8d3be ... user: drh tags: cli-prompt)
17:03
Enhance testrunner.tcl to run individual tests written in C from the test/c/ directory. (check-in: 6f140f76f4 ... user: dan tags: c-tests)
16:12
Initial test cases for the CLI prompt enhancements. (check-in: b7ecc84735 ... user: drh tags: cli-prompt)
15:45
Add --reset, --show, and -- options to the ".prompt" command of the CLI. (check-in: 8075576ba2 ... user: drh tags: cli-prompt)
14:11
Enhancements to shell_prompt_test() for better testing. Enhance the ".open" command so that it does ~/ expansion on filenames. (check-in: ec6830fe60 ... user: drh tags: cli-prompt)
12:35
Remove arbitrary limits on the length of CLI prompts. Use environment variables SQLITE_PS1 and SQLITE_PS2 (if they exist) as the default CLI prompts. (check-in: a46ceaeab9 ... user: drh tags: cli-prompt)
11:24
Fix the \B escape for prompts so that it uses wcwidth() instead of strlen() to compute spacing. (check-in: c6ff4f701d ... user: drh tags: cli-prompt)
2026-04-10
23:33
Ensure that sqlite3-opfs-async-proxy.js is copied into the fiddle target dirs. (check-in: d4e0e81afd ... user: stephan tags: branch-3.53)
23:31
Ensure that sqlite3-opfs-async-proxy.js is copied into the fiddle target dirs. (check-in: 149200861e ... user: stephan tags: trunk)
23:25
Ensure that sqlite3-opfs-async-proxy.js is copied into the fiddle target dirs. (check-in: 7c9998de1b ... user: stephan tags: cli-prompt)
23:05
A protype of .prompt support in fiddle but its utility there is in doubt because .open does not work there, so there's very little dynamic info worth showing in a prompt. Also, ANSI colorization can't work there, nor can we colorize the prompts using HTML because of limitations in jquery.terminal. (check-in: 3b17500dc6 ... user: stephan tags: cli-prompt)
21:58
Expose the main /fiddle object to the browser dev console as globalThis.fiddle for experimenting with a dynamic prompt. (check-in: 8574e5c9da ... user: stephan tags: trunk)
20:44
Fix minor issues on Windows. (check-in: 48e40d3f6a ... user: drh tags: cli-prompt)
More ↓