SQLite

Today In History
Login

This Day In History For 2025-09-13

1 Year Ago (more context)

2024-09-13
23:41
Merge sqlite_dbpage fixes into the sqlite3-rsync branch. (check-in: dff76b7a34 user: drh tags: sqlite3-rsync)
22:09 Edit [d57903f7fdb5abbd|d57903f7fd]: Mark "Closed" with note "consio is overkill for sqlite3-rsync. Closing as per /chat discussion.". (artifact: 6710352a5a user: stephan)
21:47
Bug fix in the enhanced sqlite_dbpage for when truncating two or more ATTACH-ed databases within the same transaction. (Leaf check-in: 6aa9c8e79b user: drh tags: dbpage)
16:30
Require that the contentless_unindexed=1 option be specified before storing the values of fts5 UNINDEXED column belonging to contentless tables. (check-in: c51dc2a5e7 user: dan tags: fts5-contentless-unindexed)
16:15
Fix the hanging problem. (Closed-Leaf check-in: d57903f7fd user: drh tags: sqlite3-rsync-consio)
16:12
Fix harmless compiler warning on Windows. (check-in: 86e0219d97 user: drh tags: sqlite3-rsync)
16:10
Close the db as sqlite3_analyzer exits. (See forum post, "sqlite3_analyzer not closing WAL-mode db cleanly" .) (check-in: 94ceac9884 user: larrybr tags: trunk)
16:08
Changes so that the -consio sub-branch of sqlite3-rsync will compile on Win11. It compiles, but it does not work. The process just hangs. (check-in: b4eff1fd6e user: drh tags: sqlite3-rsync-consio)
15:37
Merge latest trunk changes, including the changes to the fts5 locale=1 feature, into this branch. (check-in: d2f0d19936 user: dan tags: fts5-contentless-unindexed)
14:40
Merge sqlite3-rsync branch into sqlite3-rsync-consio branch. (check-in: c9bdbe21fe user: stephan tags: sqlite3-rsync-consio)
13:53
Improved informational output from sqlite3-rsync. (check-in: e55e3e8ec2 user: drh tags: sqlite3-rsync)
12:35
Preveious check-in was actually doing an 8-round KeccakF1600. This one corrects that to just 6 rounds. (check-in: 3c36f5814f user: drh tags: sqlite3-rsync)
12:28
Change the hash algorithm from SHA1 to a 6-round KeccakF1600 with a rate of 160. This uses about 1/3rd fewer CPU cycles. (check-in: 96c7f47a8f user: drh tags: sqlite3-rsync)
12:01
Merge sqlite3-rsync branch into sqlite3-rsync-consio branch. (check-in: 983979cc78 user: stephan tags: sqlite3-rsync-consio)
11:14
Further enhancement to PTRMAP display in showdb: Show the details of invalid entries that are within the range of the database file. Continue to ignore invalid entries beyond the end of the database file. (check-in: 4cad385b90 user: drh tags: trunk)

2 Years Ago (more context)

2023-09-13
21:32
JNI: enable the fts5-customization bits by default but elide them from the docs until it's clearer where they're headed. Unrelated minor doc tweaks. (check-in: 21adb1aef2 user: stephan tags: trunk)
20:35
Improved comments on the hasHighPrecisionDouble() routine. No changes to the underlying code. (Closed-Leaf check-in: 810c635ce0 user: drh tags: runtime-longdouble-test)
20:06
Determine at start time whether or not the underlying hardware supports high-precision long double computations. (check-in: 9a854b9196 user: drh tags: runtime-longdouble-test)
17:30
Omit the Reinsert algorithm from RTree. This causes most benchmarks to run faster, at the expense of having a slightly less dense and hence larger index (example: 33 entries/node versus 34 entries/node). (check-in: b3049a1d3d user: drh tags: rtree-performance)
17:16
Doc corrections for the previous checkin. (check-in: 9ea0a9f39d user: stephan tags: trunk)
17:11
Add JNI sqlite3_prepare_multi(), based on feedback. (check-in: fa1c153472 user: stephan tags: trunk)
14:07
Performance optimization to cellContains() in RTREE. (check-in: 43cde22bf3 user: drh tags: rtree-performance)
13:12
In the ChooseLeaf algorithm of RTREE, do an initial pass through the cells of a node looking for solutions that involve no cell enlargement. Only look for the minimum cell enlargement if the enlargement is non-zero for all cells. This results in a performance improvement by reducing the number of calls to cellUnion(). (check-in: 59f0e239d1 user: drh tags: rtree-performance)
13:09 Edit [fb2e4a8067edc29b|fb2e4a8067]: Move to branch rtree-performance. (artifact: 790a284f35 user: drh)
12:06
Reduce the number of calls to cellArea() in the ChooseLeaf() algorithm of rtree. (check-in: c633fe6be0 user: drh tags: rtree-performance)
11:36
Remove unused variable from the ChooseLeaf algorithm in r-tree. (check-in: fb2e4a8067 user: drh tags: rtree-performance)
11:24
Replace an if() condition in fts5 that is always true with an assert(). (check-in: 2170312c8d user: dan tags: trunk)

3 Years Ago (more context)

2022-09-13
21:02 Edit [b184c8d9222da6b4|b184c8d922]: Edit check-in comment. (artifact: 2c54484e65 user: drh)
20:40
Add OOM tests for the recovery extension. (check-in: 9b6b4c7162 user: dan tags: recover-extension)
19:47
Fix a broken error handling case in the recovery extension. (check-in: 60089547e1 user: dan tags: recover-extension)
19:27
Add/apply various kvvfs-specific utility APIs to the JS layer to assist in testing and analysis. Correct a backwards default arg check for sqlite3ApiBootstrap(). Add exports for sqlite3_db_handle(), sqlite3_file_control(), and the SQLITE_FCNTL_xxx enum. (check-in: 0d78961870 user: stephan tags: fiddle-opfs)
18:08
Add tests. Deal issues surrounding aborting recovery from within the SQL callback, and avoiding the pending-byte page. (check-in: 4e97dd31f5 user: dan tags: recover-extension)

4 Years Ago (more context)

2021-09-13
23:11
Shell to .read any named character source file/device (again.) (check-in: c6fe4f8d63 user: larrybr tags: trunk)
18:32
Add test cases to rtreedoc.test. (check-in: 4ee99d3154 user: dan tags: trunk)
18:16
Add assert() statements to refute forum post 9f4e7f58fbb66ddd. (check-in: 83a83475c5 user: drh tags: trunk)
16:36
Add new test file rtreedoc.test. (check-in: 8c4b1482ee user: dan tags: trunk)
13:53
Fix an incorrect comment and possible integer overflow in pager resulting from check-in [23ca23894af352ea]. Problem reported by forum post e2ea1a3f61. Also change the datatype of Pager.pageSize to i64 even though page size never exceeds 65536, in order to help prevent future problems of this kind. (check-in: f4a552ed9f user: drh tags: trunk)

10 Years Ago (more context)

2015-09-13
20:15
Add static VFS mutexes to the primary header file comments. (check-in: 9a867d9fbe user: mistachkin tags: trunk)
18:45
Experimental changes to avoid recusrively calling xMutexInit. (check-in: c9400ff167 user: mistachkin tags: mutexInitCmpSwap)
18:43
Merge updates from trunk. (check-in: b42c2e2076 user: mistachkin tags: mutexInitCmpSwap)

15 Years Ago (more context)

2010-09-13
19:03
Fix walmode.test so that all tests pass with SQLITE_TEMP_STORE=3. (check-in: 6ba6e59a9d user: dan tags: trunk)
18:58
Add tests for compound SELECT statements to e_select.test. (check-in: 8b0b009f29 user: dan tags: trunk)
14:38
Fix a couple of test files so that they work with DEFAULT_AUTOVACUUM. (check-in: 8cb39306f4 user: dan tags: trunk)
12:15
Run the multi-threaded tests in test/threadtest3.c as part of releasetest.tcl. Remove the OMIT_BUILTIN_TEST symbol from the "Device-Two" configuration. (check-in: 3f5406e323 user: dan tags: trunk)
11:29
Alter some configurations in releasetest.tcl. Print out the wall-clock time taken for each test after it is executed. (check-in: a91c5af3b0 user: dan tags: trunk)

20 Years Ago (more context)

2005-09-13
16:12
Correct the sense of a test for SQLITE_DEBUG on the resent NDEBUG change. Ticket #1425 (CVS 2693) (check-in: 81fdffdff6 user: drh tags: trunk)
07:00
Updates to the documentation on the TCL bindings. (CVS 2692) (check-in: 94aa2d3245 user: drh tags: trunk)
00:02
Fix a comment typo in the previous check-in. (CVS 2691) (check-in: 49c952807d user: drh tags: trunk)
00:00
Automatically set the NDEBUG preprocessor macro unless SQLITE_DEBUG is set. In this way, assert() statements become opt-in rather than opt-out. (CVS 2690) (check-in: 2ec2bd8574 user: drh tags: trunk)