SQLite

Timeline
Login

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

50 most recent check-ins

2025-06-13
11:08
Further improvements to the EQP text for flex-search. (Leaf check-in: 40a83da503 user: drh tags: flex-search)
00:50
Change the flex-search EQP message to be "SEARCH ... OR SCAN" as this seems less disruptive and more readable. (check-in: 680e278c3e user: drh tags: flex-search)
00:25
Fix test cases on the expert extension. (check-in: c46feb36b5 user: drh tags: flex-search)
2025-06-12
19:02
Preliminary code generation for flex-search. Add a no-op IfUseIndex opcode as a placeholder. (check-in: 521948c64f user: drh tags: flex-search)
13:40
Merge latest trunk enhancements and fixes into the experimental flex-search branch. (check-in: 51c89c886f user: drh tags: flex-search)
13:27
Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. (Leaf check-in: 954efdd30d user: drh tags: branch-3.50)
10:56
Help ext/wasm 'make snapshot' find the wasm docs dir when it's run from outside of my usual checkout structure. (check-in: 0e04136bc5 user: stephan tags: branch-3.50)
07:35
Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. (Leaf check-in: a95d126e13 user: dan tags: trunk)
2025-06-11
17:24
Fix a problem with UPDATEs on fts5 tables that contain blob values. (check-in: 2b4577d83c user: drh tags: branch-3.50)
15:03
Fix a problem with UPDATEs on fts5 tables that contain blob values. (check-in: badf3014bd user: dan tags: trunk)
00:06
Increase the version number for this branch to 3.50.2. (check-in: e9652e398e user: drh tags: branch-3.50)
00:05
Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. (check-in: e0ce6dab46 user: drh tags: branch-3.50)
00:01
Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. [forum:/forumpost/52503ac21d|Forum post 52503ac21d]. (check-in: 80a78987da user: drh tags: trunk)
2025-06-10
20:06
Improved selection of the divisor when subdividing nested Bitvec objects. This fixes a potential stack overflow that can occur when the database size is within 60 pages of the maximum allowed by the file format. (check-in: 5d40152bfe user: drh tags: branch-3.50)
19:52
Improved selection of the divisor when subdividing nested Bitvec objects. This fixes a potential stack overflow that can occur when the database size is within 60 pages of the maximum allowed by the file format. (check-in: f7ab764ed9 user: drh tags: trunk)
18:26
Minor corrections to the new Bitvec testing logic. (check-in: 77b79ca127 user: drh tags: trunk)
17:22
Enhancements to sqlite3BitvecBuiltinTest() that allow testing code to create very large Bitvec objects that do not use the linear array cross-check. (check-in: c5680672ca user: drh tags: trunk)
16:56
Adjustments to ext/misc/fileio.c in an attempt to get it to build using mingw. (check-in: ac786b92e3 user: drh tags: branch-3.50)
16:02
Improved diagnostics for Bitvec: Add the sqlite3ShowBitvec() routine that can be called from a debugger (only available with SQLITE_DEBUG). Add new output opcodes for sqlite3BitvecBuiltinTest(). (check-in: dea1e37fa6 user: drh tags: trunk)
2025-06-09
22:38
Adjustments to ext/misc/fileio.c in an attempt to get it to build using mingw. (check-in: 96b14a3f11 user: drh tags: trunk)
16:32
Initial implementation of sqlite3BtreeEstimatedPosition() with the est_rank() SQL function used for testing. (check-in: e93048425b user: drh tags: flex-search)
2025-06-07
16:45
Query planner identifies loops where it might be advantageous to check the number of matching rows and fall back to a full table scan if the number of matching rows is large. (check-in: 87fd199257 user: drh tags: flex-search)
2025-06-06
23:10
Remove unnecessary whitespace and otherwise improve comments in the wherecode.c module. No coding changes. (check-in: 2eb4e9bf0f user: drh tags: trunk)
23:02
Update the "msort" function in Lemon so that it works with lists of any length, and also so that the sort is stable. This patch was motivated by [forum:/forumpost/63750d717c9ed961|forum post 63750d717c] but was independently developed, then tested by temporarily setting LISTSIZE to 2. (check-in: aba5c3135e user: drh tags: trunk)
15:43
Update the reuse-schema branch to the 3.50.1 patch release. (Leaf check-in: b5463d7560 user: drh tags: reuse-schema-3.50)
14:52
Version 3.50.1 (check-in: b77dc5e0f5 user: drh tags: release, branch-3.50, version-3.50.1)
2025-06-05
20:12
Remove the clunky test_windirent.h and test_windirent.c files from src/ and replace them with a much cleaner and more compact ext/misc/windirent.h. (check-in: acc978df52 user: drh tags: trunk)
18:28
Enhance the FSDIR virtual table with a new "level" column. The query planner knows how to optimize to avoid search deeper than the maximum requested level. (check-in: 1ddc0f9e79 user: drh tags: trunk)
13:14
Fix harmless compiler warning introduced by the setlk-snapshot-fix merge. (check-in: cbab5d8651 user: drh tags: branch-3.50)
11:57
Fixes to ensure SQLITE_ENABLE_SETLK_TIMEOUT builds use a blocking lock and do not call xSleep() when (a) opening a snapshot transaction, and (b) when blocked by another process running recovery. (check-in: 8ac4525a2e user: drh tags: branch-3.50)
08:33
Merge TEA README updates from [bf7be67e3f]. No code changes. (check-in: 65c5e66af7 user: stephan tags: branch-3.50)
2025-06-04
18:40
tea build: add an info-exists check after a 'scan' call, as scan does not create its target vars on error. Problem reported at [forum:fde857fb8101a4be | forum post fde857fb8101a4be] and triggers when the 'vsatisfies' test for the host's Tcl version fails (so the build would fail anyway, but will fail more informatively with this fix). (check-in: a7eb03e263 user: stephan tags: branch-3.50)
18:34
tea build: add an info-exists check after a 'scan' call, as scan does not create its target vars on error. Problem reported at [forum:fde857fb8101a4be | forum post fde857fb8101a4be] and triggers when the 'vsatisfies' test for the host's Tcl version fails (so the build would fail anyway, but will fail more informatively with this fix). (check-in: 4f21874d5d user: stephan tags: trunk)
2025-06-03
18:11
Apply the duplicate 'export default' workaround to the (untested and unsupported) node-specific build rules in mkwasmbuilds.c to resolve a problem reported off-list by Thomas Steiner. (check-in: c8523d9e14 user: stephan tags: branch-3.50)
18:10
Apply the duplicate 'export default' workaround to the (untested and unsupported) node-specific build rules in mkwasmbuilds.c to resolve a problem reported off-list by Thomas Steiner. (check-in: 2f8a1b7953 user: stephan tags: trunk)
17:46
Relax query flattener constraint (3b) and thereby allow flattening the RHS of a LEFT JOIN even if the RHS contains a virtual table. This is a performance optimization that would not normally be found on a patch branch, but downstream needs it and does not want to wait on the next full release. (check-in: 916dde1f40 user: drh tags: branch-3.50)
14:19
Merge latest changes from the wal2 branch into this branch. (Leaf check-in: 93740658c8 user: dan tags: bedrock)
14:15
Merge latest trunk changes into this branch. (Leaf check-in: d685bc8ce3 user: dan tags: wal2)
10:49
Enhance sqlite3_rsync so that it works even if the replica database is initially malformed. (check-in: ea1754f7d8 user: drh tags: trunk)
10:30
Fix an off-by-one error in sqlite3_rsync. (check-in: e13a9492c1 user: drh tags: branch-3.50)
10:28
Fix an off-by-one error in sqlite3_rsync, reported in [forum:/forumpost/b6d78f60fc|forum post b6d78f60fc]. (check-in: 27d9e8e79b user: drh tags: trunk)
10:18
Fix harmless compiler warning introduced by the setlk-snapshot-fix merge. (check-in: c1f20f89d9 user: drh tags: trunk)
2025-06-02
23:41
Fix JSONB edit so that when it is trying to reduce the size of an element it understands 0xf0 (8-byte) sizes. (check-in: cee2711227 user: drh tags: branch-3.50)
23:34
Fix JSONB edit so that when it is trying to reduce the size of an element it understands 0xf0 (8-byte) sizes. (check-in: 5b3de6e8ab user: drh tags: trunk)
18:58
Increase the version number to 3.51.0 (check-in: ed69d44327 user: drh tags: trunk)
18:48
Fixes to ensure SQLITE_ENABLE_SETLK_TIMEOUT builds use a blocking lock and do not call xSleep() when (a) opening a snapshot transaction, and (b) when blocked by another process running recovery. (check-in: 7f9c0cdd06 user: dan tags: trunk)
18:42
Improve the accuracy of affinity and collating sequence analysis for NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. (check-in: d6a8b1ea5c user: drh tags: branch-3.50)
18:37
Fix os_win.c so that SQLITE_ENABLE_SETLK_TIMEOUT=2 builds work on windows. (Closed-Leaf check-in: 8efb95e0d4 user: dan tags: setlk-snapshot-fix)
18:34
Improve the accuracy of affinity and collating sequence analysis for NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. Initial problem report in [forum:/forumpost/829306db47|forum post 829306db47]. (check-in: f184d1d236 user: drh tags: trunk)
18:09
Updates to new test cases to run with SQLITE_ENABLE_SETLK_TIMEOUT=2 builds. (check-in: c6d3e3542f user: dan tags: setlk-snapshot-fix)