Documentation Source Text

All files named "pages/wal.in"
Login

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

History for pages/wal.in

2024-07-14
23:07
[9082744b12] part of check-in [2ec07bda59] Improvements to the "Disadvantages" section of the wal.html document. (check-in: [2ec07bda59] user: drh branch: trunk, size: 29245)
2024-02-13
18:06
[d53a5bd13a] part of check-in [ae6dc63646] Minor WAL mode clarification for an SQLITE_BUSY case suggested in the forum. (check-in: [ae6dc63646] user: stephan branch: trunk, size: 29330)
2018-11-26
12:01
[9b1dbf50c3] part of check-in [4182b1655e] Fix typo in the wal.html document. (check-in: [4182b1655e] user: drh branch: branch-3.25, size: 29327)
2018-07-23
18:32
[f98a2621bc] part of check-in [62d574457f] Improved documentation for snapshots. (check-in: [62d574457f] user: drh branch: trunk, size: 29330)
2018-05-31
19:14
[5b028607cf] part of check-in [db85f0efae] Typo fixes. (check-in: [db85f0efae] user: drh branch: trunk, size: 27893)
2018-05-22
15:40
[b7ff2b276a] part of check-in [729be21bb1] Better phrasing of the read-only WAL mode disadvantage in wal.html. (check-in: [729be21bb1] user: drh branch: trunk, size: 27893)
15:31
[4568652f78] part of check-in [f5137e463c] Read-only WAL mode in 3.22, not 3.20. (check-in: [f5137e463c] user: drh branch: trunk, size: 27827)
15:28
[274ee73d81] part of check-in [ba027764e3] Update information on read-only WAL-mode databases to conform with the new capabilities added in version 3.22.0. (check-in: [ba027764e3] user: drh branch: trunk, size: 27827)
2017-03-04
20:09
[c7f3815e48] part of check-in [1a4aa7fa1d] Fix typo reported by Jeffrey Mattox. (check-in: [1a4aa7fa1d] user: drh branch: 3.17, size: 29085)
2016-09-21
04:21
[fb56bc556f] part of check-in [aa3809f595] Remove duplicate disadvantage to WAL mode. (check-in: [aa3809f595] user: drh branch: branch-3.14, size: 29005)
04:17
[fb282fc397] part of check-in [4e5ba5873c] Remove duplicate disadvantage to WAL mode. (check-in: [4e5ba5873c] user: drh branch: trunk, size: 29086)
2016-09-14
18:40
[619b1b6964] part of check-in [858d993381] Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: [858d993381] user: drh branch: trunk, size: 29171)
2016-09-13
22:45
[1e0d8c46f3] part of check-in [006ea9f849] One of the disadvantages of WAL mode is that one cannot change the page_size. (check-in: [006ea9f849] user: drh branch: trunk, size: 29090)
20:39
[ce60f5ea1f] part of check-in [e1960990d2] Enable a table-of-contents on the WAL documentation. Fix typos in the previous check-in. (check-in: [e1960990d2] user: drh branch: trunk, size: 29012)
20:28
[9f207df553] part of check-in [9466a94ec8] Add a section to the WAL documentation that describes some of the scenarios in which a query can get SQLITE_BUSY. (check-in: [9466a94ec8] user: drh branch: trunk, size: 28995)
2016-08-25
12:18
[e4aed41bc4] part of check-in [066e5931ce] Add <fancy_format> or <table_of_contents> markup to a few more documents. To ensure that there are enough anchors in the longer documents for the search script to use. (check-in: [066e5931ce] user: dan branch: experimental, size: 27306)
2016-05-26
17:57
[b4d08ea23f] part of check-in [e97f045354] Fix a typo on the wal.html page. (check-in: [e97f045354] user: drh branch: trunk, size: 27316)
2016-03-18
14:56
[c89f81aeee] part of check-in [e273b7fdae] Update the wal.html document at the bigwal anchor to reflect improvements to large transactions in WAL mode added to version 3.11.0. (check-in: [e273b7fdae] user: drh branch: branch-3.11, size: 27317)
2016-01-11
13:00
[08ef3f91ae] part of check-in [166fc2da3a] Begin entering 3.11.0 changes. (check-in: [166fc2da3a] user: drh branch: trunk, size: 28255)
2015-02-26
16:50
[80055d0c0e] part of check-in [7d8c30e639] Fix a faulty requirement mark in the WAL documentation and a typo in the AUTOINCREMENT page. (check-in: [7d8c30e639] user: drh branch: trunk, size: 28130)
2015-01-23
12:44
[8c5b85c776] part of check-in [99079b3364] Further updates to the large-WAL avoidance advice. (check-in: [99079b3364] user: drh branch: trunk, size: 28127)
2015-01-22
17:48
[edcb2eff38] part of check-in [9305fd78a4] Fix typos and simplify wording in the previous commit. (check-in: [9305fd78a4] user: drh branch: trunk, size: 28000)
17:32
[8c09e00ed4] part of check-in [de568658d9] Add a section to the WAL-mode documentation talking about how to avoid over-sized WAL files. (check-in: [de568658d9] user: drh branch: trunk, size: 28019)
2014-10-27
11:26
[d9a7ed8fdb] part of check-in [461e6bbcf3] Add a small number of evidence marks to wal.html. (check-in: [461e6bbcf3] user: dan branch: trunk, size: 23321)
2014-07-18
19:06
[c8654327d9] part of check-in [306698cb1d] Clarify that PRAGMA wal_autocheckpoint always causes a PASSIVE checkpoint. Provide clearer definitions for PASSIVE, FULL, and RESET checkpoints. (check-in: [306698cb1d] user: drh branch: trunk, size: 23311)
2013-11-18
18:48
[db01471abd] part of check-in [b8e6ac4ce4] Fix documentation typos pointed out on the mailing list by Philip Newton. (check-in: [b8e6ac4ce4] user: drh branch: trunk, size: 22391)
2013-05-14
02:37
[0211e14a22] part of check-in [af7d790e13] Improved hyperlinks on various documents. (check-in: [af7d790e13] user: drh branch: trunk, size: 22390)
2012-11-14
12:46
[65df89fe2e] part of check-in [64593a771c] Fix typo in documentation on EXCLUSIVE locking mode for WAL. (check-in: [64593a771c] user: drh branch: trunk, size: 22373)
2011-05-23
19:04
[3ae2aac091] part of check-in [e63c0ce4fb] Edits to the VFS documentation. Better cross-referencing to VFS. (check-in: [e63c0ce4fb] user: drh branch: trunk, size: 22356)
2011-05-19
12:59
[b44618ab08] part of check-in [f3ea1f0a36] Preparing for the 3.7.6.3 patch release. (check-in: [f3ea1f0a36] user: drh branch: branch-3.7.6, size: 22411)
2010-12-09
18:56
[63d574630c] part of check-in [140df585c3] Add documentation for the SQLITE_DEFAULT_WAL_AUTOCHECKPOINT compile-time option. Other updates to PRAGMA documentation. (check-in: [140df585c3] user: drh branch: trunk, size: 22400)
2010-11-03
01:22
[5316c00883] part of check-in [8ff1145035] Updates to PRAGMA locking_mode and WAL documentation. (check-in: [8ff1145035] user: drh branch: trunk, size: 22294)
2010-11-02
14:46
[ff30920b6d] part of check-in [0aa0be4de5] Documentation of the WAL in EXCLUSIVE locking-mode changes. (check-in: [0aa0be4de5] user: drh branch: trunk, size: 21328)
2010-08-31
15:53
[b6d1029b2b] part of check-in [400de5a3af] Expand the description of the large-transaction limitatioo for WAL mode. Identify additional requirements in the second file format document. (check-in: [400de5a3af] user: drh branch: trunk, size: 20273)
2010-08-28
05:48
[479818c30f] part of check-in [78fe166463] Fix documentation typos. (check-in: [78fe166463] user: shaneh branch: trunk, size: 20095)
2010-08-12
14:38
[4b0dc94504] part of check-in [0ec9f2cb8f] Update the file format documentation for the new 64K page size. Add a caution to the WAL document. Omit annoying echos in the script that removes requirement marks from the documentation. (check-in: [0ec9f2cb8f] user: drh branch: trunk, size: 20096)
2010-07-15
18:41
[4ebcd4c7e1] part of check-in [ad5454b5e0] Fix typos in the wal.html document. (check-in: [ad5454b5e0] user: drh branch: trunk, size: 19825)
2010-07-13
23:51
[9239025983] part of check-in [8cdaccbb90] Updates to the WAL documentation. (check-in: [8cdaccbb90] user: drh branch: trunk, size: 19823)
2010-07-08
18:12
[b756fbd4b9] part of check-in [b1e171c029] Update PRAGMA journal_mode documentation. Fix typos in the wal.html document. (check-in: [b1e171c029] user: drh branch: trunk, size: 14254)
2010-06-25
13:45
[bd6ead4493] part of check-in [3bf3e14239] Fix typos on the wal.html page. (check-in: [3bf3e14239] user: drh branch: trunk, size: 14252)
2010-06-24
17:51
[2daefad301] part of check-in [c079123bb9] Improve explanation of page_size limitations in WAL mode. Fix a broken link in fileformat2.in. (check-in: [c079123bb9] user: drh branch: trunk, size: 14247)
2010-06-17
15:21
[d66adf53ef] part of check-in [f84c08f7bf] Minor edits to the WAL document. (check-in: [f84c08f7bf] user: drh branch: trunk, size: 14130)
2010-06-15
12:07
[65c21994f9] part of check-in [9f38773d3b] Updates to WAL documentation. (check-in: [9f38773d3b] user: drh branch: trunk, size: 14102)
2010-06-01
20:50
[8a8d2bd3a8] part of check-in [766ec51bfe] Updates to the WAL page. (check-in: [766ec51bfe] user: drh branch: trunk, size: 13596)
2010-05-24
22:39
[e8dd3994e3] part of check-in [34cbc3f991] Tweaks to the wal.html document. (check-in: [34cbc3f991] user: drh branch: trunk, size: 12244)
2010-05-07
16:18
[fe9654391c] part of check-in [a7c7d3a520] Fleshing out the WAL documentation. (check-in: [a7c7d3a520] user: drh branch: trunk, size: 12060)
02:46
[af86b6cfc5] part of check-in [f1676af6d8] Add the new Kreibich book. Add preliminary documentation on WAL pragmas. Refactor the pragma.html document. (check-in: [f1676af6d8] user: drh branch: trunk, size: 1718)
2010-05-06
23:48
Added: [1f863f4c89] part of check-in [019b60379f] Minor edits on the way toward 3.7.0 documentation. The wal.html document is created but is still mostly just a stub. (check-in: [019b60379f] user: drh branch: trunk, size: 1725)