SQLite

Timeline
Login

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

50 most recent check-ins

2026-05-01
17:42
Fix an SQLITE_MISUSE memory error in check-ini [1f940357f7bb160b]. (leaf 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. (leaf 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)
12:07
Increase a stack-local buffer size to resolve a test regression introduced in [ff084ae341eab5c], in which some tests fail a pattern match check if their absolute file names are too long. Resolves forum post 205f73db1b2806f5. (check-in: 4eeb1f74f6 ... user: stephan tags: branch-3.53)
12:05
Increase a stack-local buffer size to resolve a test regression introduced in [ff084ae341eab5c], in which some tests fail a pattern match check if their absolute file names are too long. Resolves forum post 205f73db1b2806f5. (check-in: 286fc22c7c ... user: stephan tags: trunk)
11:32
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: 77662cce9a ... user: dan tags: trunk)
06:48
Refactor the uint128 type check to consolidate duplicated rules. (check-in: 362ef7bc00 ... user: stephan tags: trunk)
05:55
Feature detection fix for uint128 on RISCV 32-bit, reported in forum post 2026-04-26T11:41:01Z and validated by the OP. (check-in: c4a2c20839 ... user: stephan tags: trunk)
2026-04-26
18:35
Improvements to temp-file cleanup on close in the CLI. (check-in: 048c969c34 ... user: drh tags: trunk)
2026-04-25
16:17
In the CLI, eliminate the 2-second delay before getting the prompt back after running a ".www" or ".excel". Instead, remember the name of the temporary file that is to be deleted and delete it later. (check-in: 4e9ee211ca ... user: drh tags: trunk)
15:05
Simplify the modePush()/modePop() implementation in the CLI. (check-in: 92cad2cd72 ... user: drh tags: trunk)
15:04
Fix a single-byte OOB read that could occur in the session module when concatenating patchsets. (check-in: 5150cf9a89 ... user: drh tags: branch-3.53)
14:32
Do not run expridx2.test as part of the "journaltest" permutation, as it requires wal mode. (check-in: 11cfbae735 ... user: dan tags: trunk)
14:00
Fix a single-byte OOB read that could occur in the session module when concatenating patchsets. (check-in: 60d7cd625a ... user: dan tags: trunk)
10:45
Minor code simplification in the CLI. (check-in: 59795c71e5 ... user: drh tags: trunk)
00:29
Fix a problem in the CLI in which the ".www" command followed by ".dbstat" does not restore the mode to its original setting afterwards. (check-in: 4a5cac1d00 ... user: drh tags: trunk)
2026-04-24
20:27
Fix test cases due to recent CLI default prompt changes. Make sure ANSI escape codes are recognized on Windows terminals. (check-in: 22b791e404 ... user: drh tags: trunk)
09:21
Improvements to the default prompt for the CLI. (check-in: 9ab0bb487f ... user: drh tags: trunk)
2026-04-23
22:15
Improved default prompt in the CLI. (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(). (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)