SQLite

Timeline
Login

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

50 most recent check-ins

2025-08-01
13:22
Fix the same potential integer overflow problem that was just fixed in the 3.32 branch, but in the 3.39 branch this time. Also increase the patch level here in the 3.39 branch. (Leaf check-in: 642be27a38 user: drh tags: branch-3.39)
13:01
Fix the same potential integer overflow problem of [5508b56fd24016c1] in a different and much simpler way. No error is raised but memory errors are avoided. (Leaf check-in: ff6b0ddf04 user: drh tags: branch-3.32)
11:25
Increase the patch level to 4. (check-in: ddfc959655 user: drh tags: branch-3.32)
10:58
Cast a string size variable to 64-bit to avoid any possibility of integer overflow. (check-in: e04ad4f379 user: drh tags: branch-3.32)
09:47
Version 3.50.4 for the reuse-schema-3.50 branch. (Leaf check-in: 1ef29e118c user: drh tags: reuse-schema-3.50)
2025-07-31
12:25
Ensure that stack space allocated for a flexible array has the correct alignment. Fix to [d4307a0d43f42e96] to for some compilers (DeveloperStudio) and platforms (Sparc). (Leaf check-in: 1cccea0508 user: drh tags: trunk)
09:54
Generic JS doc touchups. No functional changes. (check-in: cc5f126ea4 user: stephan tags: trunk)
09:45
On MacOS, when increasing the size of files on FAT filesystems from 0 to 1 byte in order to preserve their inode numbers, be sure to fsync() the file. (check-in: 727efa8559 user: drh tags: trunk)
07:44
Minor doc and consistency improvements to [cf7163f82ca380958]. (check-in: 690a727322 user: stephan tags: trunk)
2025-07-30
21:39
Back out [e283d817e3a9] because further testing has proven it unnecessary. (Closed-Leaf check-in: 7318a00de6 user: stephan tags: solaris-alignment)
21:34
Move the flexarray union members from [527bbc1676a85a9] to the end of their respective objects. (check-in: 3082e07926 user: stephan tags: solaris-alignment)
19:48
Apply alignment-related patches suggested in [forum:41cd226375cd49c6 | forum post 41cd226375]. (check-in: 527bbc1676 user: stephan tags: solaris-alignment)
19:33
Version 3.50.4 (Leaf check-in: 4d8adfb30e user: drh tags: release, branch-3.50, version-3.50.4)
18:23
Default pointer size for the __SUNPRO_C compiler is 4 bytes. (check-in: e283d817e3 user: drh tags: solaris-alignment)
16:17
JS: ensure that sqlite3WorkerPromiser.v2.defaultConfig initially refers to sqlite3WorkerPromiser.defaultConfig. This fixes a longstanding oversight rather than a known in-the-wild problem. (check-in: cf7163f82c user: stephan tags: trunk)
15:02
Adjust the previous check-in to replace the db's WASM address with yet another random number, and increase the range of random numbers, reducing the chance of cross-worker db ID collision to 1 in many billions. (check-in: f5e2a72c57 user: stephan tags: trunk)
14:50
JS: add a random element when assigning db IDs to Worker1 db instances. This addresses [https://github.com/sqlite/sqlite-wasm/issues/113 | the npm project's ticket #113], which demonstrates that two independent workers can end up generating non-globally-unique IDs. That's not a bug, per se, but it makes the IDs useless for client-side mapping of db connection IDs to client-side state, so we add some randomness to them. (check-in: 6d2a43075f user: stephan tags: trunk)
13:37
Enhance the printf formatter for %#f such that the minus sign is omitted if the '+' is missing and all digits shown in the rendering are zero. Thus, for example, '%#.2f' renders -0.004 as "0.00" instead of "-0.00". (check-in: 09e1d7c7b4 user: drh tags: trunk)
2025-07-29
11:04
Fix SQLITE_OMIT_WAL builds on windows. (check-in: 575271c3ae user: dan tags: trunk)
2025-07-26
12:51
Add new extended error codes to SQLITE_ERROR and SQLITE_IOERR, for use by extensions. (check-in: 02b241bc4c user: drh tags: trunk)
2025-07-25
21:45
Do not use any index field with a collating sequence of DATACOPY to speed a look-up. Use such fields only for covering queries. *This is an experimental branch*. (Leaf check-in: aef529e6fc user: drh tags: branch-3.28-datacopy)
20:37
Add the datacopy extension, used for testing only. (check-in: 06735507ae user: drh tags: branch-3.28-datacopy)
2025-07-24
14:26
Version 3.44.5 (Leaf check-in: a881857822 user: drh tags: release, branch-3.44, version-3.44.5)
2025-07-23
23:22
Increase the version number to 3.44.5 (check-in: 0b0aba8674 user: drh tags: branch-3.44)
23:12
Raise an error right away if the number of aggregate terms in a query exceeds the maximum number of columns. (check-in: 733652d00a user: drh tags: branch-3.44)
12:48
Do not apply the [/info/e33da6d5dc964db8|EXISTS-to-JOIN optimization] if the subquery contains a LIMIT clause. [forum:/forumpost/2025-07-23T10:59:14z|forum post 2025-07-23T10:59:14z]. (check-in: 314c493f27 user: drh tags: trunk)
2025-07-22
20:17
Add a call to Tcl_Init() in tclsqlite3's setup. This activates many of the otherwise-missing Tcl standard commands and is believed to be benign on systems where those cannot be loaded, but whether it truly is requires some experimentation on affected systems. (Leaf check-in: 9eb5c91c89 user: stephan tags: tcl-init)
16:02
Fix a potentially uninitialized field in the WhereLoop object that is used as part of the skip-ahead-distinct optimization. (check-in: f39a0865d3 user: drh tags: branch-3.50)
15:51
Fix a potentially uninitialized field in the WhereLoop object that is used as part of the skip-ahead-distinct optimization. This fixes various [forum:/timeline?ymd=20250722&u=yxchen&vfx|recent forum reports from yxchen]. (check-in: c10f9970c6 user: drh tags: trunk)
2025-07-21
18:00
Apply [ebb346c5aa]'s change to sqlite3.1, as reported in [forum:bf92f78344 | forum post bf92f78344]. (check-in: 477211be60 user: stephan tags: trunk)
2025-07-20
18:29
Ensure that certain local files are not inadvertently carried over into the snapshot tarball and causing confusing build results. (check-in: 47fdf7ed2c user: stephan tags: trunk)
18:05
Teach autoconf/tea/configure to be able to run from the canonical source tree so that a snapshot build or appropriate symlinks are not necessary in order to test the extension. (check-in: 71b9365b84 user: stephan tags: trunk)
2025-07-19
20:10
Factor out the unusual encoding-change case from vdbeCompareMemString() for a performance improvement in the common case, and a small size reduction. (check-in: cbd46ab8a8 user: drh tags: trunk)
19:54
Small performance optimization in sqlite3VdbeRecordUnpack(). (check-in: eae168def2 user: drh tags: trunk)
18:46
Split the (internal) sqlite3VdbeCheckFk() routine into two variants, sqlite3VdbeCheckFkImmediate() and sqlite3VdbeCheckFkDeferred(), which run faster than the combined general-purpose variant. (check-in: 872b1b52ed user: drh tags: trunk)
18:17
Use fewer CPU cycles to commit a read transaction. (check-in: 861e55656a user: drh tags: trunk)
2025-07-18
22:18
Add SQLITE_SELFORDER1 to JS's sqlite3.capi namespace. It's only useful when built with an sqlite3.c which itself was created with -DSQLITE_ENABLE_ORDERED_SET_AGGREGATES, which the canonical build does not do but custom builds may. (check-in: fdd15e938c user: stephan tags: trunk)
19:17
Fix a minor comment inaccuracy. (check-in: b66fcb61a1 user: drh tags: trunk)
17:40
Increase the precision of the "real time" output from the ".timer" command in the CLI from milliseconds to microseconds. (check-in: c5dbe93114 user: drh tags: trunk)
12:22
Ensure that the accumulator for an aggregate always gets initialized, even when the aggregate is on the right side of a LEFT JOIN and never gets evaluated. Also increment the version number. (check-in: 53711bf9f6 user: drh tags: branch-3.50)
12:10
Ensure that the accumulator for an aggregate always gets initialized, even when the aggregate is on the right side of a LEFT JOIN and never gets evaluated. This fixes a problem introduced by [663f5dd32d9db832] and found by dbsqlfuzz. Test cases in TH3. (check-in: 235cf6586b user: drh tags: trunk)
2025-07-17
19:18
Pedantic internal build doc fix. (check-in: 9ef429a850 user: stephan tags: trunk)
15:38
Merge the latest trunk enhancments into the reuse-schema branch. (Leaf check-in: 12dbb05b84 user: drh tags: reuse-schema)
15:31
Merge all of the trunk enchancements into the bedrock branch. (Leaf check-in: ba2174bdca user: drh tags: bedrock)
15:24
Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: 69794955d8 user: drh tags: wal2)
15:18
Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 0b2979f0c0 user: drh tags: begin-concurrent)
14:02
Merge the 3.50.3 changes into the reuse-schema-3.50 branch (check-in: 5a70ffd63c user: drh tags: reuse-schema-3.50)
13:25
Version 3.50.3 (check-in: 3ce993b865 user: drh tags: release, branch-3.50, version-3.50.3)
2025-07-16
20:50
Diverse wasm build cleanups. (check-in: 14ca18f72a user: stephan tags: trunk)
18:51
Code style conformance tweaks and remove a ref to a now-dead makefile var. (Closed-Leaf check-in: a3cec8c714 user: stephan tags: wasm-build-parallel)