SQLite

Timeline
Login

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

50 most recent check-ins

2026-05-06
20:48
Experimental prototype of the %J conversion in printf(). (leaf check-in: 7f6b1bae08 ... user: drh tags: format-json)
19:13
Fix a minor typo in a comment in the json module. (leaf check-in: 5c6d3e9d83 ... user: drh tags: trunk)
06:57
Minor internal doc typo fixes. (check-in: d588680240 ... user: stephan tags: trunk)
2026-05-05
15:31
Delete the OPFS SEE test dbs when done with them. (check-in: cbb9f7bcd0 ... user: stephan tags: trunk)
15:26
Add importDb() tests of SEE databases for the opfs/opfs-wl VFSes, analog to the opfs-sahpool test in [a5a9ac7ad6622b]. (check-in: 534d388031 ... user: stephan tags: trunk)
12:17
Version 3.53.1 for the reuse-schema branch (leaf check-in: 123aa0530c ... user: drh tags: reuse-schema-3.53)
10:34
Version 3.53.1 (leaf check-in: c88b22011a ... user: drh tags: release, branch-3.53, version-3.53.1)
08:51
For the various OPFS VFS db-import routines, in SEE builds (only) relax the is-this-a-db check to allow for SEE dbs not having the usual header string in cleartext. Addresses SEE forum post f84bef3552. (check-in: a5a9ac7ad6 ... user: stephan tags: trunk)
08:12
Fix a predicate which causes a false error in the OPFS SAHPool tests when building with SEE. (check-in: 1d2f770713 ... user: stephan tags: branch-3.53)
08:11
Fix a predicate which causes a false error in the OPFS SAHPool tests when building with SEE. (check-in: 97ab0a2fd5 ... user: stephan tags: trunk)
07:57
Add #include time.h to shell.c.in to get fiddle building with emcc 5.x. (check-in: ae675dfe79 ... user: stephan tags: trunk)
2026-05-04
18:36
Fix a test case on CLI ".help" output due to the output changing because of check-in [1590b401ff0670b6]. (check-in: b6ad35096d ... user: drh tags: trunk)
18:30
When using the OR-optimization on a loop created by exists-to-join, do the early-exit logic for the whole loop, not for each individual OR branch. (check-in: b827cdcb37 ... user: drh tags: branch-3.53)
18:16
When using the OR-optimization on a loop created by exists-to-join ([e33da6d5dc964db8]), do the early-exit logic for the whole loop, not for each individual OR branch. Possible fix for forum post c8b205720c. (check-in: 70a5d09124 ... user: dan tags: trunk)
17:16
When using the OR-optimization on a loop created by exists-to-join, do the early-exit logic for the whole loop, not for each individual OR branch. Possible fix for forum post c8b205720c. (closed check-in: 3d197dd03c ... user: dan tags: exists-or-expr-fix)
16:18
Add a missing tcl quote which breaks the build on msys2. (check-in: 9380be51c7 ... user: stephan tags: trunk)
12:58
Add the --color and --no-color options to the ".prompt" command of the CLI. (check-in: 1590b401ff ... user: drh tags: trunk)
10:14
Honor the NO_COLOR environment variable. If NO_COLOR is set and SQLITE_PS1 and SQLITE_PS2 are not set, then the default prompt is monochrome and ANSI escapes are omitted. Also change the name of the SQLITE_PS_NOANSI compile-time option to SQLITE_NO_COLOR. (check-in: 7e4134e3ff ... user: drh tags: trunk)
2026-05-03
18:31
New test cases for the shell prompt (check-in: 2340cbbd23 ... user: drh tags: trunk)
15:53
Improvements to the non-printing character delimiter logic in the CLI prompt, for improved accuracy and for improved testability. (check-in: f5649795cd ... user: drh tags: trunk)
2026-05-02
23:40
Change the non-printing character escapes for editline to U+0001 and U+0002. Also insert those escapes for readline. Readline does not need it (because it can figure them out on its own) but they are needed when editline is being used in readline-compatibility mode, and we have no way of distinguishing between editline and readline in that case, so we might as well include them. (check-in: b9545b0f0b ... user: drh tags: trunk)
23:03
Attempt to automatically insert U+0001 escape bytes before and after ANSI X3.64 escape sequences when using editline, to work around the limitations of editline. (check-in: 63050bee6e ... user: drh tags: trunk)
20:19
Fix a harmless compiler warning on some MSVC versions. (check-in: bb8f6deeff ... user: drh tags: trunk)
18:09
Idea for a new API that simply retrieves the current authorizer settings. This might be useful, for example, in a subroutine that wants to run SQL with temporary changes to the authorizer, but restore the application settings before returning. (leaf check-in: 4302c05277 ... user: drh tags: get-authorizer)
17:30
Minor optimization to the authorizer. (check-in: 625f78a630 ... user: drh tags: trunk)
15:58
Fix harmless compiler warnings. (check-in: a0d0b5aff5 ... user: drh tags: trunk)
13:18
Fix a harmless compiler warning. (check-in: 9957c3b907 ... user: drh tags: branch-3.53)
11:47
Close database connections in a timely manner to fix test script problems on Windows. (check-in: 068a53865a ... user: drh tags: trunk)
2026-05-01
23:56
This is an idea for new APIs to improve upon sqlite3_set_authorizer(). After implementing it, however, I'm having second throughts. Saved here in case I changed my mind. (leaf check-in: c3c3d97315 ... user: drh tags: push-pop-authorizer)
17:42
Fix an SQLITE_MISUSE memory error in check-ini [1f940357f7bb160b]. (check-in: fc64113e8f ... user: drh tags: trunk)
16:06
Harden the recovery extension against SQL injections coming from the sqlite_schema table of the database being recovered. (check-in: 9190f1b9b8 ... user: drh tags: trunk)
16:03
Check-in [1786fcd5b4ee6cd9] works great and generates correct code, but it upset UBSAN. This check-in fixes the UBSAN complaint. (check-in: 7cd76847e8 ... user: drh tags: trunk)
13:56
Harden the recovery extension against SQL injections coming from the sqlite_schema table of the database being recovered. (check-in: 555401fe04 ... user: drh tags: branch-3.53)
2026-04-30
18:23
The value for /f and other filename substitutions in SQLITE_PS1 is now "memory" if open on an in-memory database. (check-in: 4aac1057ee ... user: drh tags: trunk)
16:52
Remove lots of code used to support legacy Windows version (WindowsXP and before). Use Slim Reader/Writer Locks on Windows for non-recursive mutexes, since SRWLs are now available on all supported Windows platforms. (check-in: 6f7a5ff22d ... user: drh tags: trunk)
15:41
Fix a harmless compiler warning in src/mutex_w32.c. (check-in: 8de796ca45 ... user: drh tags: trunk)
15:33
Fix the memdb1.test test module so that it runs correctly on Windows. (check-in: 9012f8ea74 ... user: drh tags: trunk)
15:19
Change the CLI warning that appears in the header about opening a in-memory database, to be more readable. (check-in: cc64cafdfe ... user: drh tags: trunk)
15:07
Add the /m escape to the CLI prompt string. Use it to show "memory" in italic for the default prompt for in-memory databases. (check-in: 1e3c953930 ... user: drh tags: trunk)
2026-04-29
19:14
Fix a crash that could occur if the destination database of a backup is replaced using sqlite3_deserialize() between the call to sqlite3_backup_init() and the first call to sqlite3_backup_step(). Forum post 15d82885e2. (check-in: 1f940357f7 ... user: dan tags: trunk)
16:09
Reduce the number of system calls in the os_win.c thunk from 81 down to 58, as well as other simplifications. (closed check-in: c49521739c ... user: drh tags: omit-legacy-windows)
15:03
Further simplifications to the interface to the Windows family of OSes. An incremental check-in. (check-in: f2aa6b66d2 ... user: drh tags: omit-legacy-windows)
14:02
Simplify the Windows interface by removing support for various WindowsXP and WindowsCE. This is a work-in-progress. More to follow. (check-in: 4dbc4d19c4 ... user: drh tags: omit-legacy-windows)
2026-04-28
20:01
Updates and simplifications to the mutex implementation on Windows. Uses Slim Reader/Writer Locks for performance, for non-reentrant mutexes. Requires WindowsVista or later. (check-in: a75aa5400f ... user: drh tags: omit-legacy-windows)
15:12
Attempt to align instances of the sqlite3_mutex object at 128-byte boundaries to prevent false-sharing in multi-core machines. See the discussion at and around forum post 2026-03-25T23:15:03Z. (check-in: 1786fcd5b4 ... user: drh tags: trunk)
12:49
Fix comment typo (check-in: d64a1dbe0f ... user: drh tags: trunk)
2026-04-27
14:01
Improved detection of when the alternative windows-compatible main() is needed in the sqldiff.exe utility. (check-in: e25b849a60 ... user: drh tags: trunk)
12:43
Relax arbitrary length restrictions on some error messages in the CLI. (check-in: 52f5531ded ... user: drh tags: trunk)
12:28
Fix a crash that could occur if sqlite3_deserialize() was used to overwrite a database with an open transaction on it. Bug introduced by [fc42d31d6fca21ab] on 2018-03-07 and first released in version 3.23.0. This is not a vulnerability as an attacker that can exploit this already has the ability to execute arbitrary code. Forum post 39134ba029. (check-in: b7b0745d6d ... user: drh tags: branch-3.53)
12:25
Feature detection fix for uint128 on RISCV 32-bit. (check-in: e3f318bf52 ... user: drh tags: branch-3.53)