This Day In History For 2021-01-11
1 Year Ago (more context)
|
2020-01-11
| ||
| 21:08 | New apis: sqlite3_filename_database(), sqlite3_filename_journal(), and sqlite3_filename_wal(). Also sqlite3_uri_key(). And the other sqlite3_uri functions now work using the journal or wal filename in addition to the database file. And the sqlite3_db_filename() result is guaranteed to work as an argument to the sqlite3_uri functions. (check-in: fd7bcc5352 user: drh tags: trunk) | |
| 20:27 | Minor changes for consistency between sqlite3_filename_wal() and sqlite3_filename_journal(). (Closed-Leaf check-in: 9a70ff43a7 user: drh tags: enhanced-uri) | |
| 16:08 | Redesign for better legacy compatibility. Add the sqlite3_uri_key() interface. (check-in: bcb43d11c4 user: drh tags: enhanced-uri) | |
2 Years Ago (more context)
|
2019-01-11
| ||
| 23:08 | Use 64-bit APIs in the fileio.c extension. (check-in: b49d56a0fa user: drh tags: trunk) | |
| 21:34 | Fix a segfault in fts3 prompted by a corrupted database. (check-in: 2d7b1d1d41 user: dan tags: trunk) | |
| 19:27 | Fix another problem with corrupt databases in fts5. (check-in: 9bf811ea89 user: dan tags: trunk) | |
| 17:41 | Fix a problem handling a negative value in the "number-of-pages" database header field. Also a problem with running "REINDEX tbl" against a virtual table for which the SQL passed to sqlite3_declare_vtab() contains PRIMARY KEY or UNIQUE constraints. (check-in: 556dd8922f user: dan tags: trunk) | |
| 17:20 | Improved detection and reporting of errors in the readfile() extension SQL function. (check-in: d2f0b5a483 user: drh tags: trunk) | |
| 17:19 | Omit errors about missing SAVEPOINTs when aborting the .archive command in the CLI. (check-in: 2a47387ba6 user: drh tags: trunk) | |
| 16:44 | Improved detection of cell corruption in sqlite3VdbeRecordCompareWithSkip(). (check-in: fa47f4c658 user: drh tags: trunk) | |
| 15:26 | Merge documentation changes from branch begin-concurrent-wal2 into this branch. (check-in: cf8a0c71cf user: dan tags: begin-concurrent-pnu-wal2) | |
| 15:22 | Merge documentation changes from branch "begin-concurrent" into this branch. (Closed-Leaf check-in: 41e742bd0f user: dan tags: begin-concurrent-wal2) | |
| 15:06 | Add new documentation file begin_concurrent.md. (check-in: fdbf97e611 user: dan tags: begin-concurrent) | |
| 15:00 | Merge latest begin-concurrent-wal2 changes (documentation only). (check-in: d0ab56a3be user: dan tags: begin-concurrent-pnu-wal2) | |
| 14:59 | Merge latest wal2 changes (documentation only) into this branch. (check-in: 820ba1cc7e user: dan tags: begin-concurrent-wal2) | |
| 14:58 | Add new file doc/wal2.md to this branch. (check-in: b495dce153 user: dan tags: wal2) | |
| 14:46 | Fix PRAGMA integrity_check so that it does not cancel the PRAGMA vdbe_debug setting. (check-in: aaa3a19f8c user: drh tags: trunk) | |
| 14:38 | Add the --vdbe-debug command-line option to dbfuzz2. (check-in: 599b4df43c user: drh tags: trunk) | |
| 14:22 | Add the "dbfuzz2" target to main.mk. Remove an unused local variable from dbfuzz2.c. (check-in: 05c7609cfd user: drh tags: trunk) | |
| 14:09 | • Edit [cc42dd15100db28a|cc42dd1510]: Edit check-in comment. (artifact: e7f317677b user: drh) | |
| 13:32 | The keywords TRUE and FALSE should only act as boolean literal values if unquoted. (check-in: 5547f39de9 user: drh tags: trunk) | |
| 13:03 | Separate makefile targets for "dbfuzz2", "dbfuzz2-asan", and "dbfuzz2-msan". (check-in: ea119641a7 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2018-01-11
| ||
| 18:15 | Add the sqlite3_vtab_nochange() interface. Test cases are in TH3. (check-in: a5d09dfaa3 user: drh tags: trunk) | |
| 17:33 | Change zipfile to be a WITHOUT ROWID virtual table and table-valued function. (check-in: 931201f64e user: dan tags: trunk) | |
| 17:04 | Add the sqlite3_vtab_nochange() method which virtual table implementations can use to optimize UPDATEs. (Closed-Leaf check-in: d444b1ff39 user: drh tags: sqlite3_vtab_nochange) | |
| 16:16 | Add test cases for running multiple RBU operations within the same process concurrently. (check-in: 407b5ed35c user: dan tags: trunk) | |
| 14:50 | Minor formatting changes in zipfile.c. No logical code differences. (check-in: 4f68bed3b9 user: drh tags: trunk) | |
| 13:43 | Fix typo in comment. No code changes. (check-in: 2c55571baa user: drh tags: trunk) | |
| 00:38 | Update the .help screen in the CLI. Make sure the temporary files for ".open" are not deleted too soon. (check-in: b8d92d8dc2 user: drh tags: trunk) | |
| 00:04 | Add the built-in edit(VALUE) and edit(VALUE,EDITOR) function to the CLI. (check-in: ef823c47a0 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2017-01-11
| ||
| 21:03 | Changes to allow some multi-row UPDATE statements to avoid the two-pass approach. (check-in: 7ae6104a3e user: dan tags: trunk) | |
| 20:10 | Fix a problem causing the pre-update hook to be passed an incorrect rowid value in some single-pass multi-row updates. (Closed-Leaf check-in: 62257eb53c user: dan tags: onepass-update) | |
| 19:03 | Fix a problem with single-pass multi-row UPDATE statements that invoke REPLACE conflict handling. (check-in: 0a2b8e1b9d user: dan tags: onepass-update) | |
| 16:52 | Attempt to detect physical sector sizes on Windows 8 and higher. (check-in: 381fd34b97 user: mistachkin tags: winSectorSize) | |
| 15:42 | Fix a problem preventing UPDATE statements that use a range-scan on the PK index of a WITHOUT ROWID table from using a one-pass strategy. (check-in: cab86c9094 user: dan tags: onepass-update) | |
| 14:21 | In the STAT4 computations, ensure that the aAvgEq values do not go negative. (check-in: 4f83f6806a user: drh tags: branch-3.8.9) | |
| 14:15 | In the STAT4 computations, ensure that the aAvgEq values do not go negative. (check-in: f58f75b5a0 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2016-01-11
| ||
| 22:58 | Performance optimization in the sqlite3VdbeChangeP4() routine of the code generator. (check-in: 28bd8d5fc5 user: drh tags: trunk) | |
| 22:43 | Fix duplicate test number in 'waloverwrite'. (check-in: f5fb826866 user: mistachkin tags: trunk) | |
| 18:30 | Merge trunk with this branch. (check-in: a73d245f2e user: dan tags: fts5-offsets) | |
| 18:23 | Add the fts5speed.tcl script to ext/fts5/tool/. (check-in: 2c0b93553e user: dan tags: fts5-offsets) | |
| 18:05 | Performance optimization on the Column opcode. (check-in: ecc98bef43 user: drh tags: trunk) | |
| 17:30 | Fix bugs in fts5 synonym processing for detail=col and other modes. (check-in: 0e3c545423 user: dan tags: fts5-offsets) | |
| 14:19 | Performance optimization in sqlite3WalkExpr(). (check-in: 2f8bd5fab8 user: drh tags: trunk) | |
| 13:10 | Merge recent enhancements, and especially the WAL overwrite change, from trunk. (check-in: c4a858b228 user: drh tags: sessions) | |
| 13:03 | Import the version number change to 3.11.0. (check-in: 132772d1c4 user: drh tags: apple-osx) | |
| 12:52 | Increase the version number to 3.11.0 due to the WAL overwrite enhancement. (check-in: 8e807bfaa1 user: drh tags: trunk) | |
| 12:49 | Merge enhancements from trunk, and in particular the WAL overwrite feature. (check-in: 79125ec9d2 user: drh tags: apple-osx) | |
| 12:13 | If a single page is written to the wal file more than once, instead of appending the second and subsequent copy to the wal file, overwrite the first. Update: See the important bug fix at [f694e60a]! (check-in: d493d4f118 user: dan tags: trunk) | |
| 08:12 | Add a test case to waloverwrite.test to check that savepoint rollback does not cause a problem. (Closed-Leaf check-in: 87dae56c32 user: dan tags: wal-overwrite-frames) | |
| 03:48 | Slightly smaller and faster LIKE/GLOB comparison implementation. (check-in: 5dddcc78ee user: drh tags: trunk) | |
| 00:52 | Improved testability. (check-in: e83d3a2a4e user: drh tags: wal-overwrite-frames) | |
10 Years Ago (more context)
|
2011-01-11
| ||
| 17:40 | Merge accidentally created fork. (check-in: b7d080b8e8 user: dan tags: trunk) | |
| 17:39 | Add the SQLITE_FCNTL_SYNC file-control. (check-in: b3f2f465c3 user: dan tags: trunk) | |
| 17:38 | Change the page size of the destination database in a backup, if it is changeable, prior to starting the backup. (check-in: a5e4e0caad user: drh tags: trunk) | |
| 16:09 | If a rollback is attempted in journal_mode=off mode, force SQLite to discard the contents of the pager cache before processing any subsequent queries. (check-in: ece7efce27 user: dan tags: trunk) | |
| 12:46 | Fix the sqlite3.h generator script so that it generates the correct SQLITE_SOURCE_ID string with the latest versions of Fossil that include fractional seconds on the date/time stamp. (check-in: 3513bf6ee0 user: drh tags: trunk) | |
| 01:51 | • Edit [d94e59b514c16c5f|d94e59b514]: Edit check-in comment. (artifact: 526acc2a0f user: drh) | |
| 01:42 | A proposed change to the sqlite3_step() API such that it will only auto-reset following an SQLITE_BUSY or SQLITE_LOCKED error. Calls after any other result other than SQLITE_ROW will return SQLITE_MISUSE. (Closed-Leaf check-in: d1b3c54f42 user: drh tags: step-autoreset) | |
15 Years Ago (more context)
|
2006-01-11
| ||
| 23:40 | Testing of the automatic TSD deallocation logic. The sqlite3_thread_cleanup() API is documented. This should close ticket #1601. (CVS 2920) (check-in: fb518b0ce4 user: drh tags: trunk) | |
| 21:41 | Automatically deallocate thread-specific data when it is no longer being used. Ticket #1601. Also implemented the suggestion of ticket #1603. Memory management is now off by default at compile-time. The sqlite3_enable_memory_management() API has been removed. (CVS 2919) (check-in: 5d9c6aa964 user: drh tags: trunk) | |
| 16:10 | Ensure the database attached as part of VACUUM can be detached successfully after a malloc() failure. (CVS 2918) (check-in: 8c26893c65 user: danielk1977 tags: trunk) | |
| 14:09 | Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917) (check-in: 3970eb875d user: danielk1977 tags: trunk) | |
| 05:49 | Fix typo noted by #1599. (CVS 2916) (check-in: 1b368c7c5c user: danielk1977 tags: trunk) | |
| 01:28 | Version 3.3.0 (alpha) (CVS 2915) (check-in: 59a7a56c1b user: drh tags: trunk) | |
| 01:28 | Add new APIs to the sqlite3.def file. (CVS 2914) (check-in: 9258931a80 user: drh tags: trunk) | |
| 01:08 | Prepare for the release of version 3.3.0. (CVS 2913) (check-in: 302993ae16 user: drh tags: trunk) | |