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

History of src/wal.h

2019-01-02
19:46
Merge changes from begin-concurrent-wal2. Also modify the unix-excl shm-locks on this branch so that it is not an error to attempt to release an EXCLUSIVE lock that is not held. file: [c1a0f32c] check-in: [86685679] user: dan branch: begin-concurrent-pnu-wal2, size: 6610
2018-12-29
20:47
Merge latest begin-concurrent changes with this branch. file: [86a71244] check-in: [1625887c] user: dan branch: begin-concurrent-wal2, size: 6520
20:42
Fix a problem causing a corrupt pager-cache if an OOM or IO error was encountered while committing a concurrent transacation. file: [ac2100ee] check-in: [48ca30f9] user: dan branch: begin-concurrent, size: 6360
2018-12-18
18:01
Merge the wal2 feature into this branch. file: [4ef31f6d] check-in: [a2c618c0] user: dan branch: begin-concurrent-pnu-wal2, size: 6605
2018-12-05
17:20
Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. file: [c398e026] check-in: [bf309107] user: dan branch: begin-concurrent-wal2, size: 6515
17:14
Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. file: [d2a69695] check-in: [1d8d4f68] user: dan branch: wal2, size: 6068
2018-12-03
20:49
Merge the wal2 and begin-concurrent code. Both features work, but not at the same time. file: [b42fc808] check-in: [b7281a1c] user: dan branch: begin-concurrent-wal2, size: 6356
2018-12-01
20:14
Sync this branch with the latest trunk. file: [fc611305] check-in: [7a44fa5a] user: dan branch: wal2, size: 5909
2018-10-09
22:50
Merge changes for the 3.25.0 release. file: [bc4bdd9e] check-in: [ddf6a54e] user: drh branch: apple-osx, size: 6013
2018-09-28
20:58
Merge latest trunk into this branch. file: [f325a585] check-in: [86750c92] user: dan branch: begin-concurrent, size: 6355
2018-08-06
17:12
Allow sqlite3_snapshot_open() to be called to change the snapshot after a read transaction is already open on database. file: [60629254] check-in: [051ac015] user: dan branch: exp-snapshot-open, size: 5908
2017-10-04
20:57
Add experimental mode that uses two wal files. Activated using "PRAGMA journal_mode = wal2". file: [b6063e6b] check-in: [e2fc5c81] user: dan branch: wal2, size: 5798
2017-09-09
06:10
Merge trunk enhancements file: [bada9007] check-in: [6a0b9d9d] user: drh branch: apple-osx, size: 5902
2017-08-28
17:19
Merge recent enhancements from trunk. file: [1713fefe] check-in: [d53108e7] user: drh branch: begin-concurrent, size: 6244
2017-08-25
01:14
Update the mechanism used to keep track of what kind of syncing to do for WAL transaction commits and checkpoint operations. Use the checkpoint-style of syncing to sync the header of a new or restarted WAL file. file: [8de5d2d3] check-in: [bf65dae8] user: drh branch: wal-sync-refactor, size: 5797
2017-05-29
19:23
Instead of a root page number, log the object (table or index) name if a page level locking conflict is detected. file: [1ea51dc4] check-in: [9ad846e5] user: dan branch: begin-concurrent, size: 6265
2017-05-23
19:23
Add experimental new API sqlite3_wal_info(). file: [79378c5c] check-in: [5b9d498f] user: dan branch: begin-concurrent, size: 6258
2017-05-08
20:15
Add some support for wal mode to the hack on this branch. file: [739d9249] check-in: [b733afc1] user: dan branch: server-edition, size: 5905
2017-01-09
06:33
Upgrade this branch to 3.16 plus the various fixes that appeared after its release. file: [8659519a] check-in: [d0e212d0] user: dan branch: begin-concurrent, size: 6168
2016-11-26
20:44
Merge all recent trunk changes, and especially the new sqlite3_snapshot_recover() interface. file: [1598818f] check-in: [41a3af54] user: drh branch: apple-osx, size: 5923
2016-11-18
20:49
Add experimental sqlite3_snapshot_recover() API. file: [06b2a0b5] check-in: [174a6076] user: dan branch: serializable-snapshot, size: 5818
2016-11-04
19:09
Merge recent trunk changes, including all the fixes that appeared in version 3.15.1. file: [8fed212c] check-in: [0e5ffd91] user: drh branch: apple-osx, size: 5881
2016-08-12
16:21
Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. file: [bf03a23d] check-in: [8a5f41c7] user: dan branch: interruptible-checkpoint, size: 5776
2016-08-11
19:12
Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. file: [520cb694] check-in: [d9f8918c] user: drh branch: begin-concurrent, size: 6039
2016-07-25
17:31
Merge 3.14 alpha changes from trunk. file: [f38853cd] check-in: [e98cefb1] user: drh branch: apple-osx, size: 5794
2016-07-09
16:14
Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". file: [6dd221ed] check-in: [5471aca0] user: drh branch: trunk, size: 5689
2016-01-14
15:46
Merge the latest enhancements and fixes from trunk. file: [327e94c3] check-in: [fccc5f20] user: dan branch: begin-concurrent, size: 6024
15:03
Merge the latest enhancements and fixes from trunk. file: [29c2a284] check-in: [d85774e0] user: drh branch: apple-osx, size: 5779
2016-01-08
02:27
Add the experimental SQLITE_FCNTL_JOURNAL_POINTER file control for obtaining the sqlite3_file pointer associated with a rollback journal or WAL file. file: [2f7c831c] check-in: [a02ace9a] user: drh branch: file-control-journal, size: 5674
2015-12-16
19:55
Merge recent enhancements from trunk. file: [e3ae126b] check-in: [cb22efaf] user: drh branch: begin-concurrent, size: 5877
2015-12-11
12:53
Merge recent trunk enhancements, and in particular the snapshot interface. file: [074df251] check-in: [7e7b2406] user: drh branch: apple-osx, size: 5632
2015-12-05
20:51
Add untested implementations of experimental APIs sqlite3_snapshot_get(), _open() and _free(). file: [907943df] check-in: [0715eb00] user: dan branch: snapshot-get, size: 5527
2015-09-03
15:17
Changes from ENABLE_CONCURRENT (default off) to OMIT_CONCURRENT (default on). This is not a clear-cut decision and might be changed back. file: [361b1689] check-in: [f8ae9bfd] user: drh branch: begin-concurrent, size: 5701
2015-09-01
17:48
Fixes so that it builds without warnings both with and without SQLITE_ENABLE_CONCURRENT. file: [ec78c303] check-in: [5ed2a445] user: drh branch: begin-concurrent, size: 5673
2015-08-24
06:43
Fix another problem involving unlocked transactions and wal-file restarts. file: [903ef67e] check-in: [4460764e] user: dan branch: begin-concurrent, size: 5461
2015-08-21
20:11
Fix many minor issues in the unlocked transaction code. file: [a701096b] check-in: [53aaeea6] user: dan branch: begin-concurrent, size: 5462
2015-08-19
20:27
When committing an unlocked transaction, relocate newly allocated database pages within the file to avoid conflicting with committed transactions. There are lots of things still to fix in this code. file: [5aaed8ca] check-in: [3bbc31d5] user: dan branch: begin-concurrent, size: 5573
2015-07-29
12:14
Only allow UNLOCKED transactions to commit if none of the pages read by the transaction have been modified since it was opened. file: [cd7ea524] check-in: [0b971842] user: dan branch: begin-concurrent, size: 5518
2015-07-27
19:31
Add an experimental "BEGIN UNLOCKED" command. file: [5188cd85] check-in: [80794216] user: dan branch: begin-concurrent, size: 5574
2014-10-20
16:24
Have the ota extension perform an incremental checkpoint after generating the wal file. file: [0d3ba0c3] check-in: [0bf1301a] user: dan branch: ota-update, size: 5861
2014-09-16
20:02
Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. file: [e25f9d38] check-in: [decaccc3] user: dan branch: ota-update, size: 5403
2014-09-02
19:59
Add an experimental extension for applying bulk updates to databases. file: [237bc448] check-in: [2954ab50] user: dan branch: ota-update, size: 5489
2014-05-08
23:01
Initial attempt to merge in all trunk changes over the previous 1.5 years. This check-in compiles but there are compiler warnings and "make test" segfaults after only running a few test modules. file: [6b3a67ec] check-in: [9411d7dc] user: drh branch: apple-osx, size: 5456
2013-05-02
17:37
Minor fixes for compilation with SQLITE_OMIT_WAL defined. file: [df01efe0] check-in: [b81e87e7] user: dan branch: trunk, size: 5351
2013-03-23
21:00
Replace the sqlite3_io_methods.xMremap interface with sqlite3_io_methods.xFetch and xUnfetch. file: [a4d3da52] check-in: [1431be95] user: dan branch: experimental-mmap, size: 5300
2013-03-22
18:20
Allow the database file to be memory mapped in wal mode. file: [d99ce512] check-in: [d190ddab] user: dan branch: experimental-mmap, size: 5312
2012-05-09
22:36
Added support for SQLITE_ENABLE_PERSIST_WAL compile time macro, retrieving lastErrno from WAL file and setting last errno when writes fail due to space constraints file: [ce626f1f] check-in: [65479294] user: adam branch: apple-osx, size: 5438
2012-03-05
16:39
Pull in all the latest trunk changes. file: [a8ade306] check-in: [504bf490] user: drh branch: apple-osx, size: 5338
2012-02-24
14:33
Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only used by ZIPVFS. file: [29c19754] check-in: [3130275c] user: drh branch: trunk, size: 5333
2012-02-23
15:35
Add the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs. file: [9a300673] check-in: [786e24dc] user: dan branch: trunk, size: 5298
2012-01-03
21:54
Pull all the latest trunk changes over into the apple-osx branch. file: [313ef1ff] check-in: [8a048423] user: drh branch: apple-osx, size: 5067
2011-12-30
10:54
Minor changes to fix compilation with SQLITE_OMIT_WAL and SQLITE_OMIT_WSD defined. file: [eaa00b9a] check-in: [26a513a8] user: dan branch: trunk, size: 5062
2011-12-16
21:26
Enhance the WAL header sync so that it honors the various synchronous pragmas, settings, and device characteristics. file: [42f8313f] check-in: [9799241f] user: drh branch: wal-header-sync, size: 5062
2011-06-24
20:47
Merging local changes to apple-osx file: [e75d8775] check-in: [34f0efa2] user: adam branch: apple-osx, size: 4813
2011-05-19
02:34
Bring the apple-wal-readonly branch up to date with the latest changes in apple-osx, and especially the fix for disappearing WAL transactions. file: [0835021a] check-in: [57912327] user: drh branch: apple-wal-readonly, size: 4813
2011-05-16
21:00
Enhance WAL mode so that the WAL file honors the journal size limit set by PRAGMA journal_size_limit. file: [66b40bd9] check-in: [db7e500f] user: drh branch: trunk, size: 4808
2011-05-11
14:57
Only open a read-only connection to shared-memory if the "readonly_shm=1" option is specified as part of the database file URI (and if a read-write connection fails). file: [c1e05cdf] check-in: [671ba5fc] user: dan branch: wal-readonly, size: 4706
2010-11-18
12:11
Modify the interface to the blocking wal-checkpoint functionality. file: [7a5fbb00] check-in: [72787c01] user: dan branch: blocking-checkpoint, size: 4701
2010-11-16
18:56
Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. file: [d5bbc112] check-in: [7e3fc2c8] user: dan branch: blocking-checkpoint, size: 4451
2010-11-01
17:38
If a database file with the WAL flag set is opened in exclusive-locking mode, use heap memory to store the wal-index instead of shared-memory. file: [c1aac659] check-in: [8dd5c691] user: dan branch: trunk, size: 4310
2010-08-03
06:42
Incremental checkin on pager state refactoring. file: [96669b64] check-in: [0a636798] user: dan branch: experimental, size: 4015
2010-06-28
11:23
Fix some errors when compiling with SQLITE_OMIT_WAL. file: [906c8576] check-in: [3b68cb9c] user: dan branch: trunk, size: 4034
2010-06-02
18:59
Fix a problem with rolling back to a savepoint opened before the writer decided to wrap the log file. file: [4ace2526] check-in: [6b4aed6a] user: dan branch: trunk, size: 3985
2010-05-30
19:55
Initial code for incremental checkpoint in WAL mode. This check-in compiles on unix and runs as long as you do not engage WAL mode. WAL mode crashes and burns. Consider this check-in a baseline implementation for getting the new capability up and running. file: [1c1c9feb] check-in: [ef3ba7a1] user: drh branch: wal-incr-ckpt, size: 3985
2010-05-24
13:57
Change the checksum used in WAL files so that each frames checksum depends on the content of the WAL header and all frame headers and content up to and including the frame to which the checksum is attached. file: [111c6f3e] check-in: [8a53f12c] user: dan branch: trunk, size: 3975
2010-05-12
18:01
Refactoring the VFS-SHM methods used by WAL. This version compiles and runs non-WAL test cases but crashes and burns on wal.test. file: [434f76f5] check-in: [2b00152c] user: drh branch: wal-refactor, size: 3936
2010-05-11
12:19
Changes so that WAL and exclusive-locking mode work together. file: [32f36b2a] check-in: [71e7b1cf] user: dan branch: trunk, size: 4016
2010-05-04
14:47
Fix problems with recovering wal files that use a page-size other than the default. file: [b4c42014] check-in: [1a391f3c] user: dan branch: trunk, size: 3843
2010-05-01
16:40
Support compile-time option SQLITE_OMIT_WAL, for building without WAL support. file: [d6d4a680] check-in: [9b230c43] user: dan branch: wal, size: 3772
2010-04-30
09:52
Fix a couple of assert() statements in os_unix.c and wal.c. Combine sqlite3WalIsDirty() with sqlite3WalUndo(). file: [c3f347ba] check-in: [a8f958be] user: dan branch: wal, size: 3143
2010-04-29
22:34
Refactor wal.c to use the VFS. This check-in compiles and links and works ok as long as you leave WAL turned off, but WAL does not work. file: [d0a7048e] check-in: [62db5fa3] user: drh branch: wal, size: 3254
2010-04-28
14:42
Rename the sqlite3_log_hook() to sqlite3_wal_hook(). Added comments to wal.h. file: [c60781e7] check-in: [bbc38511] user: drh branch: wal, size: 3242
2010-04-26
16:57
Fixes for problems with small caches and SAVEPOINT rollback in WAL mode. file: [812101dd] check-in: [6a944f02] user: dan branch: wal, size: 2415
00:19
Change the names of the log.c and log.h source files to wal.c and wal.h. file: [1a34bb71] check-in: [56fe5d76] user: drh branch: wal, size: 2326 Renamed from src/log.h