SQLite
Timeline
Not logged in

50 most recent check-ins

2016-05-25
18:53
[2a41f098] Leaf: Add the libvers.c tool in the tool/ subdirectory. (user: drh, tags: trunk)
2016-05-24
18:55
[41fd46e2] Enhance Lemon and the parser template so that it can once again build parsers that have no unreachable branches. (user: drh, tags: trunk)
18:50
[61e239bc] Minor change to the walcrash4.test module so that it works when SQLITE_DEFAULT_WAL_SYNCHRONOUS is set to something other than 2. (user: drh, tags: trunk)
16:20
[37de3eab] Fix an obscure problem with transactions written in "PRAGMA synchronous=full" mode on systems that do not support POWERSAFE_OVERWRITE causing an xSync() call to be omitted if the last frame written by a transaction is aligned to a sector boundary. This means that if a power failure or OS crash occurs very soon after such a transaction is committed, it may be lost following system recovery. (user: dan, tags: trunk)
00:40
[3b28b68e] Improvements to the initialization of the push-down automoton for the Lemon-generated parser. Smaller and faster. (user: drh, tags: trunk)
2016-05-23
21:56
[3c2a7705] Use a pointer to the top of the stack rather than an index into the stack in the Lemon-generated parser template, for about 6.6% parser performance gain. (user: drh, tags: trunk)
19:02
[276e92f5] Avoid a minor error message when running RTREE without an sqlite_stat1 table. (user: drh, tags: trunk)
18:27
[9589e937] Closed-Leaf: Fix the rtreeG.test test case. (user: drh, tags: tree-stat1-fix)
18:12
[48526a2f] Fix RTREE so that it does not run queries against the sqlite_stat1 if that table does not exist. (user: drh, tags: tree-stat1-fix)
18:06
[bfbb6dd8] Remove an extra "finish_test" from the end of rtreeC.test. (user: drh, tags: tree-stat1-fix)
16:16
[3ad2531e] Improve the error messages generated by the rtree module when a constraint fails. (user: dan, tags: trunk)
16:15
[a86e782a] Lemon enhancement: avoid unnecessary reduce actions that convert one non-terminal into another but have no side effects. (user: drh, tags: trunk)
14:24
[b91a5b82] Fix comment typos and improve clarity of presention in Lemon. The output should be identical. (user: drh, tags: trunk)
02:57
[815cc2bb] Leaf: Merge changes from trunk. (user: drh, tags: apple-osx)
00:10
[90411a28] Update the configure script with additional hints on the location of tclConfig.sh, hints needed by the latest versions of Xcode. (user: drh, tags: trunk)
2016-05-21
23:25
[dec13075] More tweaks to improve the performance of the insert logic, slightly. (user: drh, tags: trunk)
20:03
[55f348cd] Simplify the sqlite3BtreeInsert() interface by gathering the five arguments describing the content to be inserted into the new BtreePayload structure, and thus reducing the number of parameters from eight to four. (user: drh, tags: trunk)
19:10
[2ce11667] Remove some unused legacy code from the btree insert logic. (user: drh, tags: trunk)
18:50
[f33aa76f] Leaf: Use pthreads mutexes and conditions to synchronize threads in bc_test1. (user: dan, tags: begin-concurrent)
12:29
[1dbaf7a1] Yet another minor size reduction and performance increase in the b-tree insert logic. (user: drh, tags: trunk)
11:23
[656aa1ec] Small size reduction and performance increase in the sqlite3BtreeInsert() logic. (user: drh, tags: trunk)
00:45
[8e366f18] Add the shell-script used for routine performance testing. (user: drh, tags: trunk)
2016-05-20
23:51
[96cf821b] Add a simple TCL script for summing cachegrind information for each VDBE opcdoe. (user: drh, tags: trunk)
21:40
[1765672c] Another optimization on the OP_Column opcode. (user: drh, tags: trunk)
20:58
[9db8f214] Fix typo in comment. (user: mistachkin, tags: trunk)
19:51
[5c157474] Slight performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
18:09
[f250166b] Remove the sqlite3PagerClearCache() routine, which does not accomplish anything useful. (user: drh, tags: trunk)
15:53
[4dc56e86] Performance optimization and size reduction on the freeP4() routine. (user: drh, tags: trunk)
15:24
[1a0d0576] Increase the version number to 3.14.0 since we are already making significant code changes. (user: drh, tags: trunk)
15:15
[3d55d24d] Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. (user: drh, tags: trunk)
14:54
[9033afbb] Optimizations to link list merge sort code in vdbesort.c, pcache.c, and rowset.c. Resulting binaries are 10 bytes smaller and use 0.03% fewer CPU cycles. (user: drh, tags: trunk)
14:11
[559733b0] For queries with both ORDER BY and LIMIT, if the rows of the inner loop are emitted in ORDER BY order and the LIMIT has been reached, then optimize by exiting the inner loop and continuing with the next cycle of the first outer loop. (user: drh, tags: trunk)
13:44
[ed1b30dc] Closed-Leaf: Set the NULLEQ flag on the sequence counter comparison in the ORDER BY LIMIT optimization, to avoid coverage complaints about not testing the NULL case. (user: drh, tags: orderby-limit)
12:22
[645bd696] Autoconf configure.ac adjustment to try to get it to look for both editline and readline automatically. (user: drh, tags: trunk)
00:21
[08849eab] A few simple test cases for the ORDER BY LIMIT optimization. (user: drh, tags: orderby-limit)
2016-05-19
22:40
[990fe50c] Appears to work now. Needs test cases, more comments, and code optimization. (user: drh, tags: orderby-limit)
22:13
[852d1eda] In a query with both ORDER BY and LIMIT, if the inner loop satisfies the ORDER BY then try to cut short each invocation of the inner loop once the LIMIT has been satisfied. This check-in is a partial implementation only. (user: drh, tags: orderby-limit)
19:31
[58b516e8] Fixup comments on wctrlFlags value definitions. (user: drh, tags: trunk)
18:56
[d0130584] Clean up the WHERE_* macros used for the wctrlFlags parameter on the sqlite3WhereBegin() interface, freeing up some bits to be used for other things. (user: drh, tags: trunk)
17:51
[cf273741] Optimization marks in vdbe.c. No logic changes. (user: drh, tags: trunk)
16:58
[4737cadc] Performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
16:21
[1f577e1f] Add test cases to test some fts3/4 edge case behaviour surrounding the '*' character. (user: dan, tags: trunk)
11:12
[0d773061] Small size reduction and performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
2016-05-18
21:03
[c981ab2a] Add the "scrub" utility program that simultaneously backs-up a live database and erases all deleted content. (user: drh, tags: trunk)
21:01
[915416d1] Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. (user: drh, tags: trunk)
20:53
[e2e9b985] Merge the 3.13.0 release changes. (user: drh, tags: apple-osx)
10:57
[fc49f556] Version 3.13.0 (user: drh, tags: trunk, release, version-3.13.0)
2016-05-17
21:17
[ab1c5ce5] Closed-Leaf: Enhance the scrub utility program so that it does a FULL checkpoint prior to starting the backup, to ensure that the database file content matches what needs to be backed up without having to look at the WAL file. (user: drh, tags: scrub-backup)
17:11
[5021dfe1] Merge the latest changes from trunk. (user: drh, tags: scrub-backup)
2016-05-16
14:35
[995c084b] Do not run snapshot_fault.test as part of the inmemory_journal permutation. (user: dan, tags: trunk)