This Day In History For 2020-06-29
2 Years Ago (more context)
|
2018-06-29
| ||
| 20:43 | Further performance related tweaks for sqlite3RunParser(). (check-in: 5eb47765 user: dan tags: weak-fallback) | |
| 20:21 | Further tweaks to sqlite3RunParser(). (check-in: eef61ffa user: dan tags: weak-fallback) | |
| 19:54 | Improve on the previous checkin. Still a bit slow. (check-in: c1fb41aa user: dan tags: weak-fallback) | |
| 17:44 | Instead of using a lemon %fallback directive, have the tokenizer try to figure out whether an instance of "WINDOW" should be TK_WINDOW or TK_ID. (check-in: 022079cb user: dan tags: weak-fallback) | |
3 Years Ago (more context)
|
2017-06-29
| ||
| 21:33 | In the command-line shell, add the -quote option to start up in quote mode. Enhance the ".mode" command so that it reports the current output mode if given no arguments. (check-in: 5e3f9ea5 user: drh tags: trunk) | |
| 21:11 | Remove the ".explain" command from the ".help" output of the command-line shell, though keep the implementation around for backwards compatibility. (check-in: 7782c04e user: drh tags: trunk) | |
| 20:31 | Some simple tests for the STMT virtual table. (check-in: a26e17ee user: drh tags: trunk) | |
| 20:23 | Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. (check-in: 3ed6877f user: dan tags: trunk) | |
| 20:13 | Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. (Closed-Leaf check-in: 2b5df3e8 user: dan tags: lsm-metapage-fix) | |
| 19:08 | Fix issues in the POSIX and Win32 interfaces for lsm1. (check-in: 38ec4141 user: mistachkin tags: trunk) | |
| 17:27 | Edit comments in sqlite.h.in used for generating documentation, to improve the description of the new sqlite3_prepare_v3() interfaces, and other miscellaneous cleanup. No changes to executable code. (check-in: 284707a7 user: drh tags: trunk) | |
| 16:51 | More updates to the Win32 interface for lsm1. (check-in: cae64769 user: mistachkin tags: trunk) | |
| 15:57 | Correct typo in the Win32 interface for lsm1. (check-in: 1b4facb1 user: mistachkin tags: trunk) | |
| 15:24 | Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. Use the new option in FTS3, FTS5, and RTREE. (check-in: 03977248 user: drh tags: trunk) | |
| 15:23 | • Edit [95141c642697dc03|95141c64]: Mark "Closed". (artifact: 61e8e392 user: drh) | |
| 15:22 | • Edit [942c3ef8cdb172f4|942c3ef8]: Mark "Closed". (artifact: 6f07f9aa user: drh) | |
| 15:13 | Further corrections to the Win32 interface for lsm1. (check-in: 4df6e247 user: mistachkin tags: trunk) | |
| 14:33 | Rename the "stmts" virtual table to just "stmt" without the final "s". (check-in: adfdb801 user: drh tags: trunk) | |
| 14:17 | A couple fixes for the Win32 interface for lsm1. (check-in: ebbd98e9 user: mistachkin tags: trunk) | |
| 13:41 | Add the stmts virtual table to testfixture builds. Add new compile-time options SQLITE_ENABLE_QPSG and SQLITE_ENABLE_STMTSVTAB to ctime.c (check-in: 60c62829 user: drh tags: trunk) | |
| 13:35 | Compilation fix for lsm1 using MSVC. (check-in: b7794cc5 user: mistachkin tags: trunk) | |
| 13:19 | Add the LSM1 extension. (check-in: 824e8327 user: drh tags: trunk) | |
| 13:13 | Add the "stmts" virtual table to the amalgamation, activated when compiled using -DSQLITE_ENABLE_STMTSVTAB. Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN statistics outputs from sqlite3_stmt_status() and add corresponding columns to the stmts virtual table. Change the numeric value of SQLITE_STMTSTATUS_MEMUSED to get it out of the way of counter values. (check-in: 88976ae3 user: drh tags: trunk) | |
| 12:59 | The query planner examines the values of bound parameters to help determine if a partial index is usable. Reprepares may happen if the bindings change. This behavior is disabled by the QPSG setting. (check-in: c322bfa2 user: drh tags: trunk) | |
| 12:54 | Implement xUnlink, xShmMap, and xShmUnmap for lsm1 on Win32. (Closed-Leaf check-in: 680cc064 user: mistachkin tags: lsm-vtab) | |
| 12:49 | Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN options to sqlite3_stmt_status(). Use this for two new columns in the stmts virtual table. (Closed-Leaf check-in: b0b0c8f8 user: drh tags: stmts-vtab) | |
| 01:23 | Fix the exprCompareVariable() routine so that it works for non-UTF8 text. (Closed-Leaf check-in: 25acd965 user: drh tags: partial-index-variables) | |
| 00:20 | Implement xRemap for lsm1 on Win32. Also, zero file handle when closing it. (check-in: 93c9aa7d user: mistachkin tags: lsm-vtab) | |
4 Years Ago (more context)
|
2016-06-29
| ||
| 06:19 | Add the ability to have a table-valued function on the RHS of an IN operator. (check-in: ba1b441b user: drh tags: prototype-int-array) | |
| 05:08 | Another test case for the intarray($PTR,$N) virtual table. (check-in: 06e1fab7 user: drh tags: prototype-int-array) | |
| 05:00 | Add a prototype intarray($PTR,$N) table valued function. (check-in: 233b3338 user: drh tags: prototype-int-array) | |
5 Years Ago (more context)
|
2015-06-29
| ||
| 23:01 | From sqlite3BtreeInsert(), bypass the btreeMoveto() routine for table inserts and go directly to sqlite3BtreeMovetoUnpacked(). (check-in: 53fe685d user: drh tags: trunk) | |
| 20:53 | Add a bypass path in sqlite3PagerWrite() for pages with the PGHDR_WRITEABLE bit set, for about a 1% performance increase. (check-in: ba425a6a user: drh tags: trunk) | |
| 19:08 | Combine subjRequiresPage() and subjournalPage() into a single subjournalPageIfRequired() routine. (check-in: 3b65eb56 user: drh tags: trunk) | |
| 18:29 | Add the PGHDR_WRITEABLE bit for PgHdr.flags which is used to distinguish between pages that are on the dirty list and pages that are safe to modify. (check-in: 7c4ef7b7 user: drh tags: trunk) | |
| 18:14 | Fix over-length source code lines in pager.c. (check-in: 14de3d39 user: drh tags: trunk) | |
| 15:41 | Fix minor problems in the ota demo application. (check-in: 6aaaec6e user: dan tags: trunk) | |
| 14:11 | Simplifications and performance improvement in pager_write(). (check-in: ab7aeeea user: drh tags: trunk) | |
| 04:21 | Add the new PGHDR_CLEAN bit to PgHdr.flags in pcache.c. This bit is always the opposite of PGHDR_DIRTY. Use the extra bit to avoid a comparison for a small performance boost. (check-in: 8619fc34 user: drh tags: trunk) | |
| 03:28 | Very small size reduction and performance increase in sqlite3BitvecTest(). (check-in: 9b3a7281 user: drh tags: trunk) | |
| 00:52 | Move an assert() and testcase() into their correct position within getAndInitPage(). (check-in: 18115164 user: drh tags: trunk) | |
| 00:21 | Use tail recursion in pcache1Unpin() to get a small size reduction and speed improvement. (check-in: fde70472 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-06-29
| ||
| 10:30 | Add tests to pager1.test and pagerfault.test. (check-in: 008513ee user: dan tags: trunk) | |
15 Years Ago (more context)
|
2005-06-29
| ||
| 17:24 | Check for zero-byte allocations in sqlite3MallocRaw. (CVS 2533) (check-in: 78cb8a9a user: drh tags: trunk) | |
| 15:33 | Make sqlite3Malloc always return NULL when the number of bytes to allocate is 0. (CVS 2532) (check-in: 657d74eb user: drh tags: trunk) | |