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

About branch wal2

This branch contains the two-wal-files patch only. This patch adds an extra journal mode enabled by "PRAGMA journal_mode = wal2". The advantage of this journal mode over regular "wal" mode is that writers may continue writing to one wal file while the other is checkpointed. The fossil trunk is periodically merged into this branch.

77 check-ins related to "wal2"
2019-10-04
16:24
Bring the begin-concurrent-pnu-wal2 branch up-to-date with 3.30.0. Leaf check-in: dd09f7ce user: drh tags: begin-concurrent-pnu-wal2
16:15
Bring the wal2 branch up to date with version 3.30.0 Leaf check-in: 16e1dced user: drh tags: wal2
15:03
Version 3.30.0 check-in: c20a3533 user: drh tags: trunk, release, version-3.30.0
2019-09-30
16:49
Merge in the 3.30.0 beta 1 enhancements. check-in: ebf88726 user: drh tags: begin-concurrent-pnu-wal2
16:44
Merge 3.30.0 beta 1 changes from trunk. check-in: 918bd97d user: drh tags: wal2
2019-09-28
18:28
Add missing comment to constant definitions. check-in: 661a3789 user: drh tags: trunk
2019-09-16
12:29
Bring the begin-concurrent-pnu-wal2 branch up to date with all the latest enhancements on trunk. check-in: 15593bf3 user: drh tags: begin-concurrent-pnu-wal2
12:23
Merge recent trunk enhancements into the wal2 branch. check-in: da8bc974 user: drh tags: wal2
05:34
Fix a problem with processing CTEs that use a WINDOW clause. check-in: ca564d4b user: dan tags: trunk
2019-07-10
18:40
Merge the 3.29.0 updates into the begin-concurrent-pnu-wal2 branch. check-in: 627b428f user: drh tags: begin-concurrent-pnu-wal2
18:30
Merge the 3.29.0 release into the wal2 branch. check-in: 8baa4022 user: drh tags: wal2
17:32
Version 3.29.0 check-in: fc82b73e user: drh tags: trunk, release, version-3.29.0
2019-07-08
21:25
Merge enhancments from wal2, which also merges trunk enhancements. check-in: 08dcb459 user: drh tags: begin-concurrent-pnu-wal2
21:19
Merge all enhancements from trunk into the wal2 branch. check-in: dcbcbc2a user: drh tags: wal2
18:35
Fix dbfuzz2 so that it will compile on systems that do not support getrlimit(). check-in: 36295dce user: drh tags: trunk
2019-05-14
22:07
Merge the latest trunk and wal2 enhancements. check-in: 3deaa6e2 user: drh tags: begin-concurrent-pnu-wal2
22:02
Merge the latest trunk enhancements into the wal2 branch. check-in: 23ec34e4 user: drh tags: wal2
20:25
Fix a problem with the fix for [9cf6c9bb51] (commit [658b84d7]) that could cause a cursor to be left in an invalid state following a (rowid < text-value) search. check-in: bc7d2c16 user: dan tags: trunk
2019-04-15
15:28
Merge all recent enhancements. check-in: 1cd536ec user: drh tags: begin-concurrent-pnu-wal2
15:17
Merge the latest trunk enhancements. check-in: 8950f119 user: drh tags: wal2
13:59
Fix a test script problem in fts5corrupt3.test. check-in: 734192d8 user: dan tags: trunk
2019-03-26
12:29
Bring this branch up to date with all the latest enhancements. check-in: 2e964aaf user: drh tags: begin-concurrent-pnu-wal2
12:22
Merge enhancements from trunk. check-in: a0e2e902 user: drh tags: wal2
2019-03-25
22:05
Fix an obsolete comment in the CLI. No code changes. check-in: fade103c user: drh tags: trunk
2019-03-08
16:06
Merge the latest enhancements and fixes from trunk. check-in: 543ecb30 user: drh tags: begin-concurrent-pnu-wal2
15:57
Merge the latest enhancements and fixes from trunk. check-in: bf20d4ff user: drh tags: wal2
15:39
Add the bgckpt.c extension to Makefile.in and Makefile.msc. check-in: 3712d625 user: drh tags: wal2
14:07
Add new test cases in test/fuzzdata8.db check-in: 97bdc090 user: drh tags: trunk
2019-01-11
14:59
Merge latest wal2 changes (documentation only) into this branch. check-in: 820ba1cc user: dan tags: begin-concurrent-wal2
14:58
Add new file doc/wal2.md to this branch. check-in: b495dce1 user: dan tags: wal2
2019-01-02
17:08
Reinstate assert() statements in os_unix.c that were removed to allow wal-mode SHARED locks to be taken over more than one locking slot (this branch no longer does that, so the assert() statements can go back in). check-in: fcb7348b user: dan tags: begin-concurrent-wal2
17:00
Reinstate assert() statements in os_unix.c that were removed to allow wal-mode SHARED locks to be taken over more than one locking slot (this branch no longer does that, so the assert() statements can go back in). check-in: 8445fb6d user: dan tags: wal2
16:30
Merge latest wal2 changes into this branch. check-in: c31eeb3c user: dan tags: begin-concurrent-wal2
16:15
Merge latest trunk changes into this branch. check-in: 87ef68f9 user: dan tags: wal2
16:01
Add another test case to vacuum-into.test. check-in: 0465d2fc user: dan tags: trunk
2018-12-28
16:20
Add new test file wal2rollback.test to this branch. check-in: 85a376fc user: dan tags: wal2
2018-12-27
17:11
Merge latest wal2 changes with this branch. check-in: ea96001e user: dan tags: begin-concurrent-wal2
16:49
Increase test coverage of wal.c provided by permutation "coverage-wal" on this branch. check-in: 2f7f893a user: dan tags: wal2
2018-12-26
20:42
Improve testing of the wal.c changes on this branch. check-in: 63483e22 user: dan tags: wal2
19:10
Merge latest trunk changes with this branch. check-in: 404f9d99 user: dan tags: wal2
18:34
Update the coverage-wal permutation to cover branches enabled by SQLITE_ENABLE_SNAPSHOT. check-in: 6821c61f user: dan tags: trunk
2018-12-22
15:50
Enhance the wal2 header comment in wal.c to explain how the wal-hook is invoked in wal2 mode. check-in: 118aa7e3 user: dan tags: wal2
2018-12-17
15:22
Merge changes from wal2 branch. check-in: 85f49f0d user: dan tags: begin-concurrent-wal2
15:22
Add extra test case to wal2recover.test. check-in: 1a5aa734 user: dan tags: wal2
2018-12-15
20:59
Merge latest wal2 changes into this branch. check-in: 06bb80ee user: dan tags: begin-concurrent-wal2
20:20
Further test cases for wal2 mode. check-in: 9cb5f8da user: dan tags: wal2
2018-12-14
19:53
Add further tests for wal2 mode. check-in: 54e628f9 user: dan tags: wal2
2018-12-13
16:26
Add tests cases for recovery in wal2 mode. check-in: 34f56f8a user: dan tags: wal2
2018-12-12
20:39
Add new test file wal2big.test. check-in: e3e50bcd user: dan tags: wal2
19:04
Add tests to ensure that each of the 4 wal read-locks does what it is supposed to. check-in: 4d5779f3 user: dan tags: wal2
2018-12-11
17:56
Change the way wal2 locks work to ensure a reader only ever has to lock a single slot. check-in: 18b2c23a user: dan tags: wal2
13:44
Merge latest trunk changes into this branch. check-in: d8dd98a3 user: dan tags: wal2
12:51
Small performance improvement in sqlite3_step(). check-in: d1db8d58 user: drh tags: trunk
2018-12-06
16:54
Add test file wal2snapshot.test that should have been added as part of an earlier commit. check-in: f6baa7e1 user: dan tags: wal2
2018-12-05
17:36
Fix a test script problem on this branch. check-in: 692ddc28 user: dan tags: begin-concurrent-wal2
17:31
Fix a test script problem on this branch. check-in: 285d1c59 user: dan tags: wal2
17:20
Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. check-in: bf309107 user: dan tags: begin-concurrent-wal2
17:14
Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. check-in: 1d8d4f68 user: dan tags: wal2
16:45
Fixes for snapshots API on this branch. Also ensure that the snapshots API cannot be used with wal2 mode databases (for now anyhow). check-in: d8c2d55f user: dan tags: begin-concurrent-wal2
16:31
Fixes for snapshots API on this branch. Also ensure that the snapshots API cannot be used with wal2 mode databases (for now anyhow). check-in: 19c61ab7 user: dan tags: wal2
2018-12-03
20:49
Merge the wal2 and begin-concurrent code. Both features work, but not at the same time. check-in: b7281a1c user: dan tags: begin-concurrent-wal2
18:13
Increase a timeout in test file walprotocol2.test. To account for unix builds without HAVE_USLEEP. check-in: 480be916 user: dan tags: wal2
2018-12-01
20:14
Sync this branch with the latest trunk. check-in: 7a44fa5a user: dan tags: wal2
12:34
Version 3.26.0 check-in: bf8c1b2b user: drh tags: trunk, release, version-3.26.0
2017-10-10
20:11
Add new extension "bgckpt" in ext/misc/bgckpt.c. For experimenting with running wal2 mode checkpoints in a background thread. check-in: 63955442 user: dan tags: wal2
2017-10-09
19:50
Merge latest trunk changes with this branch. check-in: d218d815 user: dan tags: wal2
19:49
Add a header comment to wal.c describing the differences between wal and wal2 mode. check-in: 9c80cd20 user: dan tags: wal2
2017-10-08
02:22
Fix harmless compiler warnings in FTS5 seen with MSVC. check-in: 5594a121 user: mistachkin tags: trunk
2017-10-07
19:55
Ignore the *-wal2 file if the *-wal file is zero bytes in size. check-in: f7360fad user: dan tags: wal2
13:37
Check in test file wal2simple.test. check-in: 8932b2f1 user: dan tags: wal2
2017-10-06
14:25
Merge latest trunk changes into this branch. check-in: 7e435178 user: dan tags: wal2
14:08
Fix a bug in recovering wal2 mode databases introduced by the previous commit. check-in: 9e1502e1 user: dan tags: wal2
13:43
Fix frame overwriting in wal2 mode. check-in: a4b02bc9 user: dan tags: wal2
2017-10-05
20:57
Fix compiler warnings that come up with SQLITE_OMIT_WAL. check-in: 8ca0fa8d user: drh tags: trunk
18:14
Fix test case failures on this branch. check-in: 16decc13 user: dan tags: wal2
2017-10-04
20:57
Add experimental mode that uses two wal files. Activated using "PRAGMA journal_mode = wal2". check-in: e2fc5c81 user: dan tags: wal2
18:26
Updates to requirements marks. check-in: 40964a4e user: drh tags: trunk