/ 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 745a9a7fef0f28a5.

2018-03-10
14:17
Add support for INSERT OR REPLACE and INSERT OR IGNORE on the zipfile extension. check-in: 8ad35d48 user: drh tags: trunk
13:21
Improved error messages from the zipfile extension. check-in: f634a7e3 user: drh tags: trunk
12:53
Avoid harmless left-shifts of negative numbers in the zipfile extension when building ZIP archives of files with pre-DOS dates. check-in: 16bba865 user: drh tags: trunk
12:34
Fix the zipfile extension so that it is able to create symbolic link entries in the ZIP file even on systems like Win32 that do not support symbolic links on the native filesystem. check-in: 2a4493f4 user: drh tags: trunk
2018-03-09
22:18
Fix the .archive command in the CLI so that it actually compresses content. check-in: 3c2e3c2d user: drh tags: trunk
21:54
Enhance the ".ar" command in the CLI so that it is able to update and create ZIP Archives. check-in: 9404765e user: drh tags: trunk
16:37
Setting ".stats 2" in the CLI causes column metadata for each prepared statement to be displayed. check-in: 7fea00fd user: drh tags: trunk
15:24
Simplification to the shell_exec() mechanism in the CLI. check-in: 72e8f529 user: drh tags: trunk
14:11
Fix a problem in test file nockpt.test causing errors with SQLITE_DEFAULT_AUTOVACUUM builds. check-in: e547c83f user: dan tags: trunk
14:06
Fix a test case in zipfilefault.test so that it only runs if JSON1 is available. check-in: 072b2447 user: drh tags: trunk
12:46
Attempt to fix a harmless compiler warning from Clang. check-in: bba1bfbd user: drh tags: trunk
2018-03-08
19:56
Enable API armor handling for the new deserialize APIs. check-in: 0798c91a user: mistachkin tags: trunk
18:14
Add the --append and --zip options of the CLI to the --help message. check-in: f010c86e user: drh tags: trunk
18:09
Include the 'sessionfuzz' tool in the clean target for MSVC. check-in: 0f5a8666 user: mistachkin tags: trunk
16:36
Updates to documentation on sqlite3_serialize() and sqlite3_deserialize(). No changes to code. check-in: e71ceb60 user: drh tags: trunk
2018-03-07
21:39
Fix harmless compiler warnings in the 'dbdump' tool. check-in: 2b9bb266 user: mistachkin tags: trunk
21:29
Fix harmless compiler warning in the 'sessionfuzz' tool. check-in: 706800ba user: mistachkin tags: trunk
21:13
Enable compilation of 'sessionfuzz' tool using MSVC. check-in: c58de43b user: mistachkin tags: trunk
20:48
Add the sessionfuzz test program and data obtained from a week of running AFL. Automatically run this test program on any "make test" on unix. check-in: ecaedfe5 user: drh tags: trunk
15:54
Update the autoconf Makefile for MSVC. check-in: 36fec7a4 user: mistachkin tags: trunk
15:19
Fix various compilation issues seen with MSVC. check-in: d6fa9389 user: mistachkin tags: trunk
14:53
Another tweak to the MSVC clean target. Closed-Leaf check-in: 493abf10 user: mistachkin tags: msvcFixes
14:49
Fix harmless compiler warning in FTS5. check-in: 2d544711 user: mistachkin tags: msvcFixes
14:42
Fix utility compilation issues with MSVC. check-in: 5bd5a798 user: mistachkin tags: msvcFixes
13:01
Add the sqlite3_serialize() and sqlite3_deserialize() interfaces, enabled when the -DSQLITE_ENABLE_DESERIALIZE compile-time option is used. check-in: fc42d31d user: drh tags: trunk
01:37
Mark an unreachable branch using NEVER(). Closed-Leaf check-in: fadbc5e2 user: drh tags: memdb
2018-03-06
21:43
Improved documentation for sqlite3_serialize() and sqlite3_deserialize(). Change the name of the compile-time option to enable these interfaces from SQLITE_ENABLE_MEMDB to SQLITE_ENABLE_DESERIALIZE. check-in: f07e97ae user: drh tags: memdb
20:54
Handle some boundary cases in memdb associated with OOM faults. check-in: b58ca4cb user: drh tags: memdb
19:14
Simplifications to the memdb VFS. check-in: 6c3f723a user: drh tags: memdb
11:49
Avoid running a couple of tests in crash8.test that depend on the presence of the journal file if running on an F2FS file-system that does not require a journal file. Cherrypick of [797e02e0]. check-in: eeedfc74 user: dan tags: branch-3.19
11:46
Avoid running a couple of tests in crash8.test that depend on the presence of the journal file if running on an F2FS file-system that does not require a journal file. check-in: 797e02e0 user: dan tags: trunk
04:01
Improvements to the memdb VFS. check-in: a14fed69 user: drh tags: memdb
02:00
Merge the walIteratorInit() fix from trunk. check-in: 6399e101 user: drh tags: memdb
2018-03-05
23:23
Fix walIteratorInit() so that it always leaves the iterator as a NULL pointer if an OOM occurs. This fixes an assertion fault introduced by check-in [044b0b65e716bff]. check-in: e5ce256a user: drh tags: trunk
21:19
Merge the session fix from trunk. check-in: 6274cf1f user: drh tags: memdb
21:17
Fix another crash in the sessions module triggered by malformed input. check-in: 7e70c9b8 user: dan tags: trunk
20:21
Improved command-line help for the -A option on the CLI. check-in: d937ac18 user: drh tags: trunk
20:20
A new way of doing archive commands on the command-line for the CLI. The -A option means that everything that follows is a ".archive" command, including any suffix on the -A option. check-in: 9d8081fa user: drh tags: trunk
19:34
In the CLI, add a new command-line option "--archive" (also "--ar") that passes all subsequent arguments to the ".archive" command. check-in: a5c4d30a user: drh tags: trunk
18:20
Merge session fixes from trunk. check-in: 99c02aee user: drh tags: memdb
2018-03-02
20:00
In sqlite3_checker, wrap the call to "SELECT checkfreelist()" in a transaction. check-in: 02906e55 user: dan tags: trunk
18:26
Merge latest changes from begin-concurrent into this branch. check-in: 8ade94ba user: dan tags: begin-concurrent-pnu
17:59
Update this branch with recent checkpoint related changes from trunk. check-in: fb6b7938 user: dan tags: begin-concurrent
17:40
Merge latest trunk changes into this branch. check-in: 36801eff user: dan tags: begin-concurrent
16:52
In a checkpoint, figure out if it is possible to checkpoint any frames at all before creating the wal-iterator. check-in: 044b0b65 user: dan tags: trunk
15:42
Optimize the obscure case of running a checkpoint against a very large wal file for which a large percentage of the frames have already been checkpointed. check-in: 0f5057df user: dan tags: trunk
2018-03-01
22:18
Allow the zSchema argument to sqlite3_serialize() to be NULL to mean the main database. check-in: 5b01b991 user: drh tags: memdb
18:09
Typo fixes in comments. No changes to code. check-in: 1293d4f6 user: mistachkin tags: trunk
15:20
Fix further crashes in sqlite3changeset_apply() caused by corrupt changeset blobs. check-in: 2c01c72e user: dan tags: trunk
13:44
Merge the latest enhancements from trunk. check-in: c8083de1 user: drh tags: memdb
12:05
Fix some crashes in the sqlite3changeset_apply() function that could be caused by corrupt changeset blobs. check-in: 745a9a7f user: dan tags: trunk
2018-02-28
22:21
Enhance the sessions documentation to show the methods of the various objects. check-in: e0117775 user: drh tags: trunk
21:50
Use <pre> around code snippets in the documentation for sessions interfaces. This is a documentation change only with no changes to code. check-in: c949b915 user: drh tags: trunk
04:30
Fix a potential NULL pointer deref following OOM in the new IS TRUE logic. check-in: 48775ec6 user: drh tags: trunk
2018-02-27
20:09
Update zonefile README.md file to mention the frame cache. Leaf check-in: 84e9351b user: dan tags: zonefile
19:50
Rationalize some code in zonefile.c. Fix other minor issues in the same. check-in: f11beb16 user: dan tags: zonefile
15:47
Enhance test 'zonefile1-6.5' to account for platform differences. check-in: 8b617840 user: mistachkin tags: zonefile
15:42
Adjustments to test numbers for the 'zonefile' extension. check-in: 55de6f14 user: mistachkin tags: zonefile
15:40
Add support for TRUE and FALSE keywords and for operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE. If there is are columns named TRUE or FALSE, then the keywords resolve to the column names, for compatibility. The behavior of the "DEFAULT true" phrase is changed to mean what it says, rather than being an alias for "DEFAULT 'true'". check-in: 9a7f02c5 user: drh tags: trunk
14:49
Clean up comments and variable names prior to merge. Closed-Leaf check-in: 6445519e user: drh tags: is-true-operator
14:26
Have the zonefile extension use binary instead of text keys. check-in: 39a4267f user: dan tags: zonefile
00:58
Remove an unnecessary decision. check-in: adcb4665 user: drh tags: is-true-operator
2018-02-26
21:26
Code simplifications. New test cases. check-in: 57508518 user: drh tags: is-true-operator
20:15
Get the "DEFAULT true" and "DEFAULT false" phrases working correctly in CREATE TABLE. check-in: 8002f87d user: drh tags: is-true-operator
19:03
Enhance TreeView so that it can display the new IS TRUE expression trees. check-in: 7e38305e user: drh tags: is-true-operator
18:49
Refactor for correct NULL handling in the IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE operators. check-in: cf2abd59 user: drh tags: is-true-operator
17:03
More tests pursuant to ticket [36fae083b450e3af857a459e20]. check-in: c26f236d user: mistachkin tags: trunk
16:49
Fix heap issue in the shell on Win32 caused by allocator mismatch. check-in: 7b3a7551 user: mistachkin tags: trunk
15:31
Merge the fix for determining truth of floating point values from trunk. check-in: 003dc140 user: drh tags: is-true-operator
15:27
Always interpret non-zero floating-point values as true even if their integer part is zero. Fix for ticket [36fae083b450e3af857a459e20]. check-in: a983fa85 user: drh tags: trunk
07:58
Add extra parameter to zonefileCodecCreate() to indicate whether the new object will be used for mock-encryption or mock-decryption. check-in: 231832c4 user: dan tags: zonefile
03:20
Experimental implementation of IS TRUE and IS FALSE operators. All TRUE and FALSE to act like constants if the names do not resolve to a column name. check-in: 40314bc9 user: drh tags: is-true-operator
2018-02-24
08:26
Test edge cases in the zonefile module. Fix a broken error message in the same. check-in: 1764ade2 user: dan tags: zonefile
2018-02-23
21:01
Fix a problem with handling "k >= ?" constraints in the zonefile module. check-in: 9a99afaf user: dan tags: zonefile
19:21
Add test cases and minor fixes for the zonefile module. check-in: dbbcbf00 user: dan tags: zonefile
14:09
Fix a problem causing SQLITE_HAVE_LZ4 builds of zonefile to fail unless SQLITE_HAVE_ZLIB is also defined. check-in: 994aa77d user: dan tags: zonefile
14:02
Fix a problem with DROP TABLE statements on zonefile virtual tables. check-in: d2ed6910 user: dan tags: zonefile
14:00
Fix harmless compiler warnings in the zonefile extension seen with MSVC. check-in: d2800394 user: mistachkin tags: zonefile
13:58
Avoid running a test case that requires zstd in non-SQLITE_HAVE_ZSTD builds. check-in: d716dff4 user: dan tags: zonefile
13:45
Merge updates from trunk. check-in: 53f2100a user: mistachkin tags: zonefile
13:38
Fix harmless compiler warnings in the zipfile extension seen with MSVC. check-in: 15c587cf user: mistachkin tags: trunk
13:38
Enable the JSON1 extension when compiling the test fixture with MSVC. check-in: e9e9f27b user: mistachkin tags: trunk
2018-02-22
21:06
Add tests cases and fix some minor zonefile problems. check-in: f4d42162 user: dan tags: zonefile
18:30
For the "SQLite archive" link in the README.md file, point to the CLI .archive command documentation, not the original "sqlar" website. check-in: 4290faf5 user: drh tags: trunk
18:28
Updates to the README.md file. Mention the ability to use SQLite-archives for download. check-in: ab9a7ae4 user: drh tags: trunk
16:46
Add an LRU cache of uncompressed frame content to the zonefile virtual table implementation. check-in: 883e7e75 user: dan tags: zonefile
2018-02-21
21:15
Modifications to the zonefile module to make it easier to add a cache of uncompressed frame content. check-in: d9d5cc62 user: dan tags: zonefile
16:36
Have zonefile store encryption keys in a hash-table instead of a linked list. Add extra tests for key management. check-in: 3a63ea65 user: dan tags: zonefile
10:43
In zonefile, change the "file TEXT" column back to "fileid INTEGER". The fileid can be used as a key with the associated zonefile_files table, which contains more information than just the filename. check-in: 38d23888 user: dan tags: zonefile
01:48
Remove an unreachable branch in the walIndexPage() logic. check-in: 4e61a973 user: drh tags: trunk
01:05
Small performance improvement in sqltie3WalFindFrame(). check-in: 52013cad user: drh tags: trunk
00:48
Remove an unnecessary memset(). check-in: e7b7f588 user: drh tags: trunk
2018-02-20
22:20
Make the walIndexPage() routine about 3x faster by factoring out the seldom used reallocation logic into a separate subroutine. check-in: e2b10714 user: drh tags: trunk
21:00
Add extra code to log details when corruption is detected in the pointer-map structure maintained by the b-tree layer in begin-concurrent transactions. check-in: 57023371 user: dan tags: begin-concurrent-pnu
20:57
Update README.md in ext/zonefile. check-in: a13b2b38 user: dan tags: zonefile
19:25
Fix a problem with reading the "file" column of a zonefile virtual table. check-in: d8d0bdcb user: dan tags: zonefile
18:47
Instead of just the frame number, store frame sizes and offsets in zonefile shadow table %_shadow_idx. check-in: 56801c46 user: dan tags: zonefile
17:02
In the speed-check.sh script, make WAL mode the default. Add the --legacy option to do DELETE mode. Continue to use DELETE mode for long-term performance graphs since WAL mode was not always available, but use WAL mode for day-to-day performance measurements. check-in: cd816138 user: drh tags: trunk
16:39
Remove a superfluous "#if 1". No logic changes. check-in: caaffd32 user: drh tags: trunk
15:23
Optimize calls to sqlite3_mprintf("%z...") so that they attempt to append text onto the end of the existing memory allocation rather than reallocating and copying. check-in: 4bc8a48e user: drh tags: trunk