/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

100 check-ins occurring around 12ef3a8f3d1eb4bd.

2016-02-03
01:55
Enhance the internal sqlite3VdbeAddOpList() interface to automatically update jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. check-in: ae8b9d2e user: drh tags: trunk
2016-02-02
21:19
Add tests to restore full coverage of fts5 code. check-in: 063755c8 user: dan tags: trunk
17:40
Enhance the performance of fts5 AND and OR queries. check-in: 62ea9e5a user: dan tags: trunk
02:53
Merge recent enhancements from trunk. check-in: 347f6a80 user: drh tags: begin-concurrent
02:30
Merge recent enhancements from trunk. check-in: e6a4a163 user: drh tags: apple-osx
02:22
Merge all recent enhancements from trunk. check-in: f3f92001 user: drh tags: sessions
02:04
Enhance the comment on the sqlite3_index_constraint object to bring attention to the fact than iColumn field can be negative for a rowid. check-in: d8b7b199 user: drh tags: trunk
00:59
Add the SQLITE_DBCONFIG_REQUIRE_WRITE_TXN connection setting, which if enabled requires all write operations to be enclosed within BEGIN ... COMMIT. Leaf check-in: 7453790c user: drh tags: require-write-txn
2016-02-01
21:48
Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. check-in: 6d7d4703 user: drh tags: trunk
20:12
Improve performance of fts5 queries. check-in: 2334e882 user: dan tags: trunk
17:20
Number VDBE opcodes starting with 0 instead of 1, as this obviates the lower-bound test on "switch(opcode){...}", making the code smaller and faster. check-in: 4c9222f7 user: drh tags: trunk
16:36
Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times. check-in: 5d7c0928 user: dan tags: trunk
13:58
Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30. check-in: a17712bf user: dan tags: trunk
13:21
Minor simplification to the OP_AutoCommit opcode. Fix some code comments related to transaction control. check-in: a9b6a067 user: drh tags: trunk
00:21
Fix an assert() that might fail on a corrupt database. check-in: 22eaced7 user: drh tags: trunk
2016-01-30
21:09
Fix new test cases in stat.test so that they work with -DSQLITE_DEFAULT_AUTOVACUUM=1 builds. check-in: a2810cf6 user: dan tags: trunk
19:16
Performance enhancement for fts5 column filter queries on detail=full tables. check-in: 13fb4aa6 user: dan tags: trunk
16:59
Merge the implementation of OP_IdxRowid and OP_Seek so that OP_Seek no longer requires the rowid register and a separate OP_IdxRowid call. Shorter and faster prepared statements result. check-in: 9bec50a1 user: drh tags: trunk
15:52
Only honor the register subtype value if the MEM_Subtype flag is set. Revised and improved fix for ticket [f45ac567eaa9f9]. check-in: 1f4c667f user: drh tags: trunk
15:46
A different way to clear the subtype on VDBE registers when the value of the register is overwritten with new content. To fix [[f45ac567eaa9f93]. Closed-Leaf check-in: 2e9fb129 user: dan tags: clear-subtype-flag
14:53
Take care to clear the subtype on VDBE registers when the value of the register is overwritten with new content. Closed-Leaf check-in: ec653cbc user: drh tags: clear-subtype-fail
14:17
Output subtype information on register traces for PRAGMA vdbe_trace. check-in: 96b78020 user: drh tags: trunk
13:32
Add the BTREE_FORDELETE and BTREE_AUXDELETE flags to the b-tree layer interface and use them. Add assert() statement to verify that they are correct. check-in: 85c46704 user: drh tags: trunk
12:50
Simplification and size reduction to the printf logic. Remove the bFlags parameter from sqlite3VXPrintf() and sqlite3XPrintf(). Use sqlite3XPrintf() instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output. check-in: 0bdb41c4 user: drh tags: trunk
02:10
Make use of covering indexes in the OR optimization. check-in: 9de3d712 user: drh tags: trunk
00:45
Change the P4_INTARRAY so that always begins with a length integer. Print the content of the INTARRAY on EXPLAIN output. Closed-Leaf check-in: 6c520d57 user: drh tags: covering-or
2016-01-29
21:16
Add tests for the change on this branch. check-in: 7cb697f8 user: dan tags: covering-or
20:58
Different comment on the alternative cursor fields of VdbeCursor. check-in: 6e3dcb6d user: drh tags: covering-or
19:29
Experimental attempt to make better use of covering indexes within OR queries. check-in: a323ac3a user: dan tags: covering-or
19:04
Improvements to FORDELETE processing, including bug fixes and adding assert() statements to help verify correct operation. Closed-Leaf check-in: 46080b04 user: drh tags: btree-fordelete-flag
18:48
Remove a stray "exit" in a test script. Closed-Leaf check-in: 10c88bf9 user: drh tags: fordelete-assert
18:11
Avoid unnecessary WHERE clause term tests when coding a join where one of the tables contains a OR constraint. check-in: 512caa1a user: drh tags: trunk
18:04
Prepend "rc!=SQLITE_OK || " to the nExtraDelete assert() condition. check-in: 2a055ed0 user: dan tags: fordelete-assert
16:57
Avoid unnecessary WHERE clause term tests when coding a join where one of the tables contains a OR constraint. Closed-Leaf check-in: ab946039 user: drh tags: OR-clause-improvement
08:38
Avoid two more instances of pointer arithmetic on freed pointers. check-in: 2910ef64 user: dan tags: trunk
2016-01-28
18:22
Modify the order of terms in an "if" condition to avoid implicitly comparing a dangling pointer to NULL following an OOM error. check-in: 5372f800 user: dan tags: trunk
17:06
Modifications to ensure the nExtraDelete-related assert() statement does not fail. check-in: f43ff8f8 user: dan tags: fordelete-assert
08:58
Remove a duplicate "p->magic = VDBE_MAGIC_RUN;" line from vdbeaux.c. check-in: 688eb3b4 user: dan tags: trunk
02:47
Fix for pthread detection in the configure scripts. check-in: 47633ffd user: drh tags: trunk
00:04
Minor correction to the batch tool changes in the previous check-in. check-in: 7c89d75d user: mistachkin tags: trunk
2016-01-27
23:50
Make the MSVC batch build tool sub-routine 'fn_UnsetVariable' a bit more robust. check-in: 1edd5f31 user: mistachkin tags: trunk
16:26
Change the name of the BTREE_IDXDELETE flag to BTREE_AUXDELETE, to better reflect its purpose. check-in: 1d3bf6be user: drh tags: fordelete-assert
16:17
Fix tests in fordelete.test to test for the BTREE_AUXDELETE flag. check-in: bbd25cf1 user: dan tags: fordelete-assert
15:49
Add assert() statements on the nExtraDelete variable in vdbe.c to try to verify that the FORDELETE and IDXDELETE flags are being generated correctly. Those flags are not currently generated correctly, and so the assert()s trip on this check-in. check-in: dde1db0d user: drh tags: fordelete-assert
07:28
Support building for Windows 10 desktop using 'MinCore.lib'. check-in: 4bf89891 user: mistachkin tags: trunk
2016-01-26
23:32
Merge all recent trunk enhancements. check-in: 9a71d56d user: drh tags: btree-fordelete-flag
20:19
Performance improvements for fts5, particularly detail=col mode. check-in: a3d7b8ac user: dan tags: trunk
20:08
Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables. Leaf check-in: b4ac61ae user: dan tags: fts5-perf
19:30
Improve the performance of fts5 column filters on detail=col tables. check-in: 249a2d07 user: dan tags: fts5-perf
17:08
Enhance fts5txt2db.tcl, a script used to generate fts5/fts4 databases for performance testing. check-in: c646e403 user: dan tags: fts5-perf
15:23
Change the automatic index mechanism so that it avoids creating transient indexes on columns that are known to have low cardinality. Leaf check-in: 12ef3a8f user: drh tags: autoindex-planning
14:48
Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks. check-in: 4003db4a user: dan tags: trunk
13:56
Ensure that unixFullpathname() always nul-terminates its output buffer, even when returning an error. Closed-Leaf check-in: 4a438556 user: dan tags: follow-symlinks
00:12
Remove an unused variable. check-in: 1c2656c1 user: drh tags: follow-symlinks
2016-01-25
23:24
Add the ability to do Windows builds to the amalgamation tarball. check-in: abd2b357 user: drh tags: trunk
23:19
Minor changes to the autoconf/README.txt file. Closed-Leaf check-in: 6df8a9c0 user: drh tags: msvcMakeMin
22:08
Fix a compiler warning about doing pointer arithmetic involving a NULL pointer even though the result of computation is never used. check-in: 7c49a947 user: drh tags: trunk
18:43
Only use lstat() if the HAVE_LSTAT macro is defined. Fix some test file issues. check-in: 8a6e4147 user: dan tags: follow-symlinks
18:05
Simplify the unixFullpathname() function. This adds a dependency on lstat(). check-in: f71249d3 user: dan tags: follow-symlinks
17:04
Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks. check-in: 80398fd4 user: dan tags: follow-symlinks
15:57
Replace the OP_SetIfNotPos operator with OP_OffsetLimit in the VDBE, for simpler and smaller code. check-in: 7ac017a4 user: drh tags: trunk
13:55
Add the SQLITE_EXTRA_DURABLE compile-time option. check-in: 30671345 user: drh tags: trunk
02:15
Small simplification to the prepare statement opcode memory reuse logic. Easier to read, and slightly smaller and faster. check-in: 8a1deae4 user: drh tags: trunk
01:07
Small simplification and performance improvement in memsys5Free(). check-in: 0a9cff5c user: drh tags: trunk
2016-01-23
22:55
Add the SQLITE_SPELLFIX_STACKALLOC_SZ compile-time option to control how much stack space is available for use as the Wagner matrix in editDest3 of the spellfix extension. check-in: dd0100dd user: drh tags: trunk
21:57
More updates to the README. check-in: 9f02868d user: mistachkin tags: msvcMakeMin
20:43
Updates to the autoconf README file. check-in: 4ce60fa4 user: drh tags: msvcMakeMin
20:34
Move Makefile.min.msc into the autoconf subdir where it belongs and change its name to Makefile.msc. Adjust build scripts accordingly. check-in: 12eb8db7 user: drh tags: msvcMakeMin
20:16
Minor coding style tweaks for the mkmsvcmin tool. check-in: c15e0fc4 user: mistachkin tags: msvcMakeMin
20:09
Adjust the amalgamation-tarball build process so that it includes the MSVC makefile and the sqlite3.rc resource file. check-in: e420f3dc user: drh tags: msvcMakeMin
19:47
Improved comments on the transformation script and on the generated Makefile. check-in: c6e633ab user: drh tags: msvcMakeMin
19:24
Use the -integer option when sorting list elements. check-in: 949aa614 user: mistachkin tags: msvcMakeMin
18:51
Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode. check-in: 72d53699 user: dan tags: fts5-perf
18:24
Changes to spellfix to try to get it to use stack space instead of heap space in cases where that makes sense. check-in: dfcebc73 user: drh tags: trunk
16:20
Merge trunk changes (including fixes for warnings in fts5) with this branch. check-in: ceccc9ad user: dan tags: fts5-perf
15:57
Fix some signed/unsigned comparison compiler warnings in fts5. check-in: 3be336aa user: dan tags: trunk
14:45
Fix a problem involving detail=col and column filters. check-in: 7558a0ad user: dan tags: fts5-perf
14:05
Remove an assert() that can be false if compiled with SQLITE_USE_ALLOCA. check-in: f0a551ed user: drh tags: trunk
07:53
Add tooling to create an MSVC Makefile capable of building the core library and shell only, using a pre-built amalgamation. check-in: c46f1a13 user: mistachkin tags: msvcMakeMin
01:54
Cleanup localtime() support for Windows CE. check-in: 39759a55 user: mistachkin tags: winCeLocalTime
00:07
More work on the MSVC build. check-in: a79c46bc user: mistachkin tags: trunk
2016-01-22
23:17
In the TCL interface, if a database connection object was opened with the -uri 1 option, then also honor URI filenames for the "backup" and "restore" commands. check-in: a1c8116c user: drh tags: trunk
22:16
More MSVC makefile cleanup. check-in: df22556f user: mistachkin tags: trunk
19:48
Experimental performance enhancements for fts5. check-in: b5a57b81 user: dan tags: fts5-perf
19:44
Reenable the xCurrentTime and xGetLastError methods on the unix VFSes as long as SQLITE_OMIT_DEPRECATED is not defined. check-in: c11c85fd user: drh tags: trunk
17:48
Add the sqlite3TokenInit() utility function. check-in: 73231753 user: drh tags: trunk
15:44
Have the dbstat module dequote any argument passed to the CREATE VIRTUAL TABLE statement before attempting to match it against the names of attached databases. check-in: e60461e9 user: dan tags: trunk
14:46
Merge latest trunk changes into this branch. check-in: 9341491c user: dan tags: schemalint
14:44
Fix handling of transitive constraints in schemalint.tcl. check-in: 44edc1aa user: dan tags: schemalint
14:32
Update the schemalint.tcl script so that the argument to a -select option may be either an SQL statement or the name of a file containing an SQL statement check-in: d4e37767 user: dan tags: schemalint
04:22
Enable FTS4 when building the shell with the MSVC makefile. check-in: e4c07df5 user: mistachkin tags: trunk
03:54
Further refinements to the MSVC makefile. check-in: 67625b96 user: mistachkin tags: trunk
01:25
MSVC makefile enhancements for use with the Windows 10 SDK. check-in: ac2e9d3d user: mistachkin tags: trunk
2016-01-21
18:56
Fix typo in 'Makefile.in'. check-in: 29a51c6d user: mistachkin tags: trunk
17:25
Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. Closed-Leaf check-in: 82470d1c user: dan tags: disable-restrict
17:06
Add a new hint bit on the flags parameter of sqlite3BtreeDelete(). The new BTREE_IDXDELETE bit indicates that the call is to delete an index entry corresponding to a table row that has already been deleted. check-in: ac2cbadd user: drh tags: btree-fordelete-flag
15:55
Improved comments on the FORDELETE hint. No logic changes. check-in: a3cec529 user: drh tags: trunk
2016-01-20
18:47
Add 'rbu' to the clean targets. check-in: f60f0250 user: mistachkin tags: trunk
16:36
Add a -detail option to the loadfts5.tcl script. For creating tables with the detail= option set. check-in: 81e830e2 user: dan tags: trunk
16:02
Merge the LIKE-operator bug fix from trunk. check-in: 36cb3d6e user: drh tags: sessions