SQLite

Today In History
Login

This Day In History For 2025-09-14

1 Year Ago (more context)

2024-09-14
20:30
Fix the fts5 xInstToken() API for prefix queries that do not use prefix-indexes. This is experimental. (check-in: 97c2824f47 user: dan tags: fts5-tokendata-prefix)
16:52
Merge subsequent changes to sqlite-rsync that were accidentally missed by the prior check-in. (check-in: 50762ba078 user: drh tags: trunk)
16:39
Enhancements to sqlite_dbpage() so that it accepts INSERT statements that can extend or truncate the database. Add the sqlite3-rsync utility program that make a copy of a live database over SSH. (check-in: b7a8ce4c8c user: drh tags: trunk)
16:30
CLI arg handling robustness improvements. (Leaf check-in: 129aca54f6 user: stephan tags: sqlite3-rsync)
16:28
Add the --version option. (check-in: 9961334c80 user: drh tags: sqlite3-rsync)
16:03
New debugging options: --logfile, --errorfile, --remote-errorfile. If page 1 changes, always send it last. (check-in: 2d8cd76691 user: drh tags: sqlite3-rsync)
11:38
Always show the -v traffic message even if there are multiple -v options. (check-in: fc05a5b7f7 user: drh tags: sqlite3-rsync)
11:23
Add the --logfile FILE option for debugging. (check-in: 30e1b92d56 user: drh tags: sqlite3-rsync)
10:59
Improved error messages coming out of sqlite3-rsync. (check-in: 452fb6de39 user: drh tags: sqlite3-rsync)
10:48
Make the output from sqlite3-rsync with a single -v option the same as it is with regular rsync. Only show the SSH command with two or more -v options, or if there is an error in popen2(). (check-in: 105ec44b47 user: drh tags: sqlite3-rsync)

2 Years Ago (more context)

2023-09-14
20:56
Tests for java versions of Fts5ExtensionApi.xSetAuxdata() and xGetAuxdata(). (check-in: 858fa236f8 user: dan tags: trunk)
20:02
JNI: move XTokenizeCallback interface out of the Fts5 object - that level of indirection is a holdover from when those classes were in the core package. (check-in: 385ec08570 user: stephan tags: trunk)
20:01
Add a few more tests for Fts5ExtensionApi methods. (check-in: 4ce2a7e8ed user: dan tags: trunk)
17:42
Add a test for the java version of Fts5ExtensionApi.xRowid(). (check-in: 227facf879 user: dan tags: trunk)
16:45
According to forum post 9f6db917e1, older MSVC compilers are unable to convert a double directly into an unsigned long long int, but must first go through a signed long long int. Work around this by restricting the range of doubles that are converted into long long integers so that only the lower 63 bits are used. (Closed-Leaf check-in: 0ab05871ba user: drh tags: legacy-msvc-workaround)
16:02
Document the use of OPFLAG_ISNOOP as the P2 argument on OP_Delete. No functional code changes. (check-in: d88f41b2cf user: drh tags: trunk)
14:05
Avoid a segfault in test program showdb.c that could occur when analyzing a corrupt db. (check-in: 6bf3e90687 user: dan tags: trunk)
13:10
Improve the sqlite3IntFloatCompare() routine so that it is testable. (check-in: bb221381fa user: drh tags: trunk)
10:46
Do not set the global bUseLongDouble flag based purely on sizeof(long double) being more than 8. That is a necessary but not sufficient condition to use the long double routines. Instead, do a run-time test to verify that long double really does provide extra precision. (check-in: aa999d490b user: drh tags: trunk)
01:46
Reduce the number of calls to sqlite3_mprintf() made by RTree. (Closed-Leaf check-in: f158b7d491 user: drh tags: rtree-performance)

3 Years Ago (more context)

2022-09-14
20:45
Include recovery extension in configure/make builds of testfixture. (check-in: d2f4652144 user: dan tags: recover-extension)
18:57
Extra tests and fixes. (check-in: deed533693 user: dan tags: recover-extension)
16:37
Fix recovery of utf-16 databases. (check-in: 5b05be0861 user: dan tags: recover-extension)

4 Years Ago (more context)

2021-09-14
20:07
Add test cases to rtreedoc.test. (check-in: afe0ec4d58 user: dan tags: trunk)
18:57
Update requirements marks to reflect recent documentation changes. (check-in: 08cab8921e user: drh tags: trunk)
14:16
Add test cases to rtreedoc.test. (check-in: b62de1269f user: dan tags: trunk)
11:27
Minor updates to rtreedoc.test. (check-in: b22c75e41d user: dan tags: trunk)

10 Years Ago (more context)

2015-09-14
22:54
Remove a comment that is no longer accurate. (check-in: cf114c1895 user: mistachkin tags: mutexInitIsInitReCheck)
22:53
Merge updates from trunk. (check-in: 25c157714d user: mistachkin tags: mutexInitIsInitReCheck)
22:52
Re-check sqlite3GlobalConfig.isInit after the mutex subsystem has been initialized. (check-in: fea8c0b281 user: mistachkin tags: mutexInitIsInitReCheck)
19:51
Improve test coverage of fts5_index.c. (check-in: c1f76686ce user: dan tags: trunk)
19:26
Testability improvements for the ONEPASS_MULTI enhancement. (check-in: d2df93f26f user: drh tags: trunk)
14:49
Fix a typo in an SQLITE_USER_AUTHENTICATION macro. (check-in: 379455af9f user: drh tags: trunk)
14:45
Use symbolic names ONEPASS_OFF, ONEPASS_SINGLE, and ONEPASS_MULTI for the various modes of the one-pass optimization. (check-in: 16e56bdade user: drh tags: trunk)
14:08
Fix a compiler warning and providing missing VdbeCoverage() calls. (check-in: 2edd2e5edd user: drh tags: trunk)
11:09
Use a single-pass approach for DELETE statements on non-virtual tables that do not require trigger or foreign key processing. (check-in: 8b93cc5937 user: dan tags: trunk)
10:47
Merge the latest trunk enhancements. (check-in: 22ce9218fb user: drh tags: sessions)
09:23
Avoid calling sqlite3VdbeCursorMoveto() from more than one point in vdbe.c. Doing so prevents it from being inlined as part of OP_Column. (Closed-Leaf check-in: 166d5af891 user: dan tags: onepass-delete)

15 Years Ago (more context)

2010-09-14
18:56
Further tests for compound SELECT statements. (check-in: a0f01ebab9 user: dan tags: trunk)
18:23
Clarify the documentation to better explain when an automatic re-prepare can be induced by rebinding parameters. Add evidence marks to the automatic re-prepare logic. (check-in: 3e11f5155c user: drh tags: trunk)
10:53
Fix some test failures found running releasetest.tcl. (check-in: 56a9ce7774 user: dan tags: trunk)

25 Years Ago (more context)

2000-09-14
01:25
Version 1.0.5 (CVS 495) (check-in: 84839d8764 user: drh tags: trunk)
01:21
better handling of exponential notation (CVS 145) (check-in: ea0e32828f user: drh tags: trunk)