Documentation Source Text

File History
Login

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

History of pages/fileformat2.in

2018-09-06
20:02
Merge documentation fixes from the 3.24.0 release branch. file: [8e2f2f93bf] check-in: [4235bb053e] user: drh branch: trunk, size: 91032
2018-07-30
20:16
Enhancement to the how-to-corrupt document. file: [5606bb403c] check-in: [06a6ca5d34] user: drh branch: branch-3.24, size: 90950
2018-07-23
18:32
Improved documentation for snapshots. file: [271d2e6574] check-in: [62d574457f] user: drh branch: trunk, size: 90941
2018-06-08
13:21
Use https for all internal hyperlinks. file: [a790cdaa3e] check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 90860
2018-06-05
13:43
Add hyperlinks for "index b-tree" and "table b-tree". file: [b175b977b1] check-in: [35ca8da032] user: drh branch: trunk, size: 90921
2018-01-13
14:33
Update the file-format documentation on serial-types 10 and 11. They are no longer "reserved for expansion" but have shifted to "reserved for internal use". file: [036c4dc2dd] check-in: [9b212044e0] user: drh branch: trunk, size: 90859
2017-11-13
23:06
Continuing work on the walformat.html document. file: [6dcf0f35bc] check-in: [74c71c744b] user: drh branch: trunk, size: 90576
17:03
Continuing work on the walformat.html document. This is an incremental check-in. file: [0eedb970ce] check-in: [627feecddc] user: drh branch: trunk, size: 89643
2017-11-04
17:08
Begin adding the "WAL-mode File Format" document. Much work left to be done. file: [22fdd1e76b] check-in: [3f66c70302] user: drh branch: trunk, size: 89594
2017-08-31
00:54
Readability improvements to the file format documentation. file: [bef93f3287] check-in: [3b1bef8768] user: drh branch: trunk, size: 89535
2017-08-11
00:54
Fix a typo in the fileformat document file: [82e89da26f] check-in: [85bec545b9] user: drh branch: trunk, size: 89184
2017-06-07
14:00
Fix typo in the file format document. file: [d3f50b69e9] check-in: [64a0c62941] user: drh branch: trunk, size: 89183
2017-03-07
22:25
Fix a typo in the file format document. file: [b791c10044] check-in: [01b45f38af] user: drh branch: trunk, size: 89183
2017-02-22
12:43
Fix typos in the documentation reported by Karol Swietlicki. file: [b8b90d53bd] check-in: [d24b5395d0] user: drh branch: 3.17, size: 89183
2017-02-15
22:44
Fix a harmless typo in the rollback journal checksum algorithm description. file: [52fe78750e] check-in: [ebd7ef38cc] user: drh branch: trunk, size: 89181
22:43
Correct the rollback journal checksum algorithm description. file: [7992895d48] check-in: [b69eaea914] user: drh branch: trunk, size: 89181
2016-10-31
17:47
Update documentation on AUTOINCREMENT to indicate that it only works for INSERT and not UPDATE. file: [2d081469a5] check-in: [71511a055b] user: drh branch: trunk, size: 89195
2016-10-25
14:50
Enhance the file format document to explain how sqlite_stat1 works for WITHOUT ROWID tables. file: [1cf0ef3390] check-in: [df4011932b] user: drh branch: trunk, size: 89184
2016-09-27
23:04
Fix typo in the file format document. file: [8c61e1172e] check-in: [6e2e589a04] user: drh branch: trunk, size: 88947
23:01
New alternative title for the On-Disk Format document. file: [c51b198fb3] check-in: [8615868905] user: drh branch: trunk, size: 88944
2016-09-14
18:40
Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. file: [89e0671ec2] check-in: [858d993381] user: drh branch: trunk, size: 88918
2016-08-08
13:41
Final changes for the 3.14 release. file: [dda5b73d32] check-in: [bc4407518b] user: drh branch: trunk, size: 88853
2016-06-20
11:12
Additional clarification of the file format. file: [987a723fbd] check-in: [df46867c0f] user: drh branch: trunk, size: 88853
10:51
Enhance the file format document to make it clear that records might contain fewer values than there are columns in the table schema. file: [240d2d4a9a] check-in: [149d28ec0e] user: drh branch: trunk, size: 88597
2016-05-09
23:12
Use > instead of > in documentation. file: [8709d5fa1f] check-in: [4607eaf52f] user: drh branch: trunk, size: 88240
2016-05-05
23:40
Add sub-bullets in the description of the b-tree page type flag in fileformat2.html, for improved legibility. file: [cc45c0b65f] check-in: [ff214d6ba0] user: drh branch: trunk, size: 88231
2016-04-26
19:37
Also add a table of contents to fileformat2.html. file: [06d0dfe9c6] check-in: [e9007b6030] user: dan branch: trunk, size: 88178
2016-04-01
14:57
Merge changes from the 3.12.0 branch. Add the "rowidtable.html" page. Add documentation for SQLITE_ENABLE_PREUPDATE_HOOK. file: [4c968f9876] check-in: [74e8dbd8bf] user: drh branch: trunk, size: 88542
2016-03-08
17:23
Correct and clarify the computation of local and overflow payload sizes in the file format documentation. file: [47ed16bc85] check-in: [9ec8b470d5] user: drh branch: trunk, size: 88533
2016-03-02
13:16
Tweaks to the description of the sqlite_stat1 table in the fileformat2 document. file: [048acb6eab] check-in: [d4c54c7ebe] user: drh branch: trunk, size: 87555
2016-02-10
03:48
Merge typo fixes from the 3.10 branch. file: [c8a7866159] check-in: [f26e661484] user: drh branch: trunk, size: 87578
03:47
Fix typos in the fileformat2.html document. file: [a333c01e9b] check-in: [7ee2137b43] user: drh branch: branch-3.10, size: 87482
2016-01-26
15:04
Update the file format document to indicate that the number of rows in an index in sqlite_stat1 can be less than the number of table rows in the case of a partial index. file: [852d14389e] check-in: [42f14ae85f] user: drh branch: trunk, size: 87589
2015-12-27
14:43
Fix a typo in the file format documentation. file: [fdba8bbdb0] check-in: [1cc43dde6c] user: drh branch: branch-3.9, size: 87493
2015-11-11
00:22
Clarification of the checkpoint algorithm in the file format document. file: [b2b00ddeb0] check-in: [4f85463d41] user: drh branch: trunk, size: 87492
2015-11-03
14:58
Fix closing tag mismatch in fileformat.html. file: [710560efd0] check-in: [b4a002ba34] user: dan branch: trunk, size: 87351
2015-05-23
17:48
Enhance the file-format document to show the page type header numbers on various charts, for ease of reference. file: [0863774b6f] check-in: [88dc8a8a7b] user: drh branch: trunk, size: 87351
2015-02-27
02:37
Clarifications and typo fixes to several web pages. file: [6b3dfd844e] check-in: [00d095bbd5] user: drh branch: trunk, size: 87267
2014-11-20
19:15
Updates to the file-format document. file: [a5b28a288e] check-in: [c17b8feb60] user: drh branch: trunk, size: 87307
02:13
Further enhancements to the file format document. file: [4b1b22cd00] check-in: [0e52679d7c] user: drh branch: trunk, size: 87141
2014-11-19
22:22
Minor tweaks to the file format documentation. file: [3fbaa120ed] check-in: [63cc893eba] user: drh branch: trunk, size: 86489
13:50
Fix a faulty requirement mark on the previous check-in. file: [fa2bc8e9e1] check-in: [5c05494072] user: drh branch: trunk, size: 86425
13:42
Add documentation for the noskipscan token in sqlite_stat1. file: [423aff2e82] check-in: [242e4f73aa] user: drh branch: trunk, size: 86422
2014-10-06
15:08
Add to the file-format documentation the constraint that stat3 and stat4 samples must be ordered. file: [c3a055af0d] check-in: [fad8e07e26] user: drh branch: trunk, size: 86264
2014-08-15
14:59
Fix typos and add new hyperlinks. file: [f5e9fd94d0] check-in: [415cd2bfe2] user: drh branch: trunk, size: 85615
2014-08-11
21:17
Fix requirements marks in the file format document. Improvements to PRAGMA documentation. file: [b88b371a79] check-in: [e09448dc9d] user: drh branch: trunk, size: 85618
2014-08-07
13:22
General documentation updates. Attempts to provide better links and improve wording for better readability. file: [f81090a82e] check-in: [430bf0b418] user: drh branch: trunk, size: 85559
2014-07-24
15:36
Add a change log for version 3.8.6. Update the home page for version 3.8.6. file: [7bfeaa334a] check-in: [0d81c00b9a] user: drh branch: trunk, size: 85513
2014-07-22
12:24
Enhance the file format description to allow unrecognized text tokens at the end of the stat column in sqlite_stat1. file: [c6c4102fc6] check-in: [3e1aad19c5] user: drh branch: trunk, size: 85512
2014-06-30
17:52
Enhance the description of the sqlite_stat4 format for WITHOUT ROWID tables. file: [fa694b947c] check-in: [d7f83670d7] user: drh branch: trunk, size: 85323
2014-01-29
17:47
Update News and the change log. Bring the release date forward to 2014-02-03. Fix typos. Move older news entries out to oldnews.in. file: [c412f9a158] check-in: [ea6e1d11de] user: drh branch: trunk, size: 83805
2013-11-18
18:48
Fix documentation typos pointed out on the mailing list by Philip Newton. file: [6f90689151] check-in: [b8e6ac4ce4] user: drh branch: trunk, size: 83804
2013-11-09
17:27
Tweaks to WITHOUT ROWID documentation. file: [68d36b1a6f] check-in: [478a586d67] user: drh branch: trunk, size: 83802
17:17
Fix a broken fragment specification in the fileformat page. file: [73363f6996] check-in: [ea35f76f95] user: drh branch: trunk, size: 83829
17:14
Add the WITHOUT ROWID document. Enhance the file-format, CREATE TABLE, and AUTOINCREMENT documents to reflect changes due to WITHOUT ROWID. file: [57b5ca5ef2] check-in: [ffe4c464ea] user: drh branch: trunk, size: 83839
2013-10-17
12:54
Add news for the 3.8.1 release. Other final documentation tweaks prior to release. file: [6886fa62e1] check-in: [ca4b03a1f2] user: drh branch: trunk, size: 79277
2013-09-19
14:30
Clarification of the meaning of the stat column in sqlite_stat1. file: [3229b5e78e] check-in: [83b2bf0c4d] user: drh branch: trunk, size: 78748
14:24
Leave unspecified what it means for the sqlite_stat3 and sqlite_stat4 tables to have idx columns equal to their tbl column. file: [8a04507a41] check-in: [c538b41b91] user: drh branch: trunk, size: 78681
14:14
Fix typos and enhance the text of documentation for 3.8.1 changes. file: [83c12d54e7] check-in: [1d0df412df] user: drh branch: trunk, size: 78971
2013-08-28
14:13
Add documentation for STAT4. file: [69815e3f7d] check-in: [04ab4fa5ec] user: drh branch: trunk, size: 79014
2013-07-09
21:49
Fix typo in version number for sqlite_stat3. file: [08ddb54226] check-in: [a583de40a1] user: mistachkin branch: trunk, size: 77119
2013-07-01
16:07
Lots of tweaking and enhancements to the documentation, especially regarding the query planner and ways of controlling the query planner. file: [b3873b27ae] check-in: [641e107a66] user: drh branch: trunk, size: 77119
2013-05-03
17:55
Typo correction and enhancement to the change log. file: [e2aa35224f] check-in: [a9cecdf9e8] user: drh branch: trunk, size: 77092
15:43
Add documentation for the Application ID. Add a proposed release date for 3.7.17. file: [41b05a5582] check-in: [0d800b73f2] user: drh branch: trunk, size: 77089
2013-01-25
15:06
Correction to the description of the WAL file checksum computation. file: [d2d8e27afe] check-in: [0a8b8c3b49] user: drh branch: trunk, size: 76209
2012-05-12
01:50
Fix a typo in the file format documentation. file: [e74d55fc1e] check-in: [c1bf8efee7] user: drh branch: trunk, size: 76180
2012-05-11
17:01
Update the change history and news. And make some minor fixes to requirements text. file: [c27ca9fdbc] check-in: [9778992724] user: drh branch: trunk, size: 76177
2012-03-31
12:10
Fix typo in the fileformat2 document. file: [67087df6c6] check-in: [912e06a446] user: drh branch: trunk, size: 76171
2012-03-29
14:14
Enhance the file format documentation with additional information about internal schema objects. file: [1680087186] check-in: [68d2666398] user: drh branch: trunk, size: 76171
2011-12-30
14:57
Major speed improvement on the script that translates requirements. Fix requirements markup in optoverview.html and in fileformat2.html. Fixes to requirements.html. file: [67ebd372b2] check-in: [986229bc47] user: drh branch: trunk, size: 66328
2011-11-24
19:40
Fix typos and a mixup over BLOB and text serial types in the file format document. file: [1235d5d89b] check-in: [3b3c197a19] user: drh branch: trunk, size: 66262
2011-11-07
14:45
Start documentation for 3.7.10 by noting the change in DEFAULT_FILE_FORMAT. file: [b2fe72e86f] check-in: [50947bf51f] user: drh branch: trunk, size: 66263
2011-10-21
18:36
Add documentation for the SQLITE_DIRECT_OVERFLOW_READ compile-time option. file: [6997800457] check-in: [02ece32458] user: drh branch: trunk, size: 66343
2011-08-04
21:57
Clarify the language in the opening paragraphs of the file format document. file: [86c7736419] check-in: [e7ebad87a6] user: drh branch: trunk, size: 66279
2011-07-20
13:49
Fix typos in the file format document. file: [239922e044] check-in: [81951052dc] user: drh branch: trunk, size: 66254
2011-06-20
21:48
Documentation typos. file: [7e1c74f0ee] check-in: [b503d1f516] user: drh branch: trunk, size: 66132
2011-05-23
19:04
Edits to the VFS documentation. Better cross-referencing to VFS. file: [c38080eeaa] check-in: [e63c0ce4fb] user: drh branch: trunk, size: 66130
2011-04-22
20:49
Clarification and corrections to the computation of how much content spills into overflow pages in the b-tree. file: [3ef447a2ca] check-in: [e64e27e335] user: drh branch: trunk, size: 66124
2011-01-05
21:46
Fix a serious bug in the specification of the file format: the serial types for BLOB and TEXT where reversed. file: [53e8c4f712] check-in: [83a0bc6bb9] user: drh branch: trunk, size: 65960
2010-10-06
13:47
Updates to the file format documentation. file: [871f6bc2a7] check-in: [8f5cfd48d2] user: drh branch: trunk, size: 65960
2010-09-29
04:20
Fix documentation typos in testing.html and in fileformat2.html. file: [14e0923b89] check-in: [ac93c65159] user: drh branch: trunk, size: 65913
2010-09-09
12:31
Disable the older fileformat document. This makes documentation builds run much faster. Also fix some typos. file: [b35049704f] check-in: [7cab8e90e4] user: drh branch: trunk, size: 65906
2010-09-02
04:20
More typo fixes. file: [0ac1790800] check-in: [db66d3a1d4] user: shaneh branch: trunk, size: 66407
2010-08-31
15:53
Expand the description of the large-transaction limitatioo for WAL mode. Identify additional requirements in the second file format document. file: [7db4749395] check-in: [400de5a3af] user: drh branch: trunk, size: 66411
2010-08-30
15:10
More typo and spelling fixes. file: [5a8473951a] check-in: [d7a2085524] user: shaneh branch: trunk, size: 66392
13:36
Fix more spelling mistakes and typos. Additional changes for consistency in word usage. file: [791e81c325] check-in: [9425bd7118] user: shaneh branch: trunk, size: 66392
2010-08-28
05:48
Fix documentation typos. file: [88c327e25b] check-in: [78fe166463] user: shaneh branch: trunk, size: 66392
2010-08-23
22:51
Preparation for the 3.7.2 release. file: [885197e65c] check-in: [7bf266483d] user: drh branch: trunk, size: 66392
2010-08-13
17:44
Enhancements to the description of how the COLLATE operator works. file: [4d63e9908b] check-in: [17093bc7d6] user: drh branch: trunk, size: 66329
2010-08-12
17:55
Initial identification of requirements in the fileformat2.html document. file: [bfade9c37a] check-in: [8925c8c2e1] user: drh branch: trunk, size: 66322
14:38
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. file: [83862dd8ec] check-in: [0ec9f2cb8f] user: drh branch: trunk, size: 65229
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. file: [4e000b93a1] check-in: [d9e242f92a] user: drh branch: trunk, size: 63854
2010-07-13
23:51
Updates to the WAL documentation. file: [bc5820054c] check-in: [8cdaccbb90] user: drh branch: trunk, size: 63852
2010-07-07
02:03
Update the compile-time options document and footprint size bounds. Updates to the file format document. file: [bbe1726f1a] check-in: [0992cf9ad0] user: drh branch: trunk, size: 63840
2010-07-06
01:27
Adding first draft of WAL file format. file: [cd06ef7333] check-in: [05824b6e6a] user: drh branch: trunk, size: 63446
2010-07-05
15:06
Updates to the file format documentation. file: [2b5f03deef] check-in: [2d2c9fd38a] user: drh branch: trunk, size: 54206
2010-06-24
17:51
Improve explanation of page_size limitations in WAL mode. Fix a broken link in fileformat2.in. file: [7f2625eb34] check-in: [c079123bb9] user: drh branch: trunk, size: 54163
2010-06-19
10:39
Updates to the fileformat2 document. file: [7613426b04] check-in: [2a5bc288a1] user: drh branch: trunk, size: 54163
2010-05-07
16:18
Fleshing out the WAL documentation. file: [f6ab571f75] check-in: [a7c7d3a520] user: drh branch: trunk, size: 51175
2010-03-23
13:12
Update the file format documentation to show that the database size is stored in the header at offset 28. file: [16f5d7ad8a] check-in: [2ceac5efd8] user: drh branch: trunk, size: 51143
2009-11-02
15:50
Added the website keyword index. file: [eeec6d2205] check-in: [ec4a51db99] user: drh branch: trunk, size: 51146
2009-10-30
23:46
Documentation updates - attempting to make the website easier to navigate. file: [da1fa56980] check-in: [b243271f28] user: drh branch: trunk, size: 51090
17:27
Changes in preparation for the 3.6.20 release. file: [f8a05c065a] check-in: [3aa36a5775] user: drh branch: trunk, size: 45165
2009-10-29
01:54
Fix typos in the new books.html document and in nulls.html and support.html. Continue extending the file format redux. file: [63f1930e2b] check-in: [4016dcb5b6] user: drh branch: trunk, size: 45057
2009-10-28
15:05
Updates to file format redux, mostdeployed. Added the "Books about SQLite" page. file: [a6e388475e] check-in: [4cf07896aa] user: drh branch: trunk, size: 38177
13:39
First check-in of the secondary file format document. file: [56c4b0822d] check-in: [0bea9013f4] user: drh branch: trunk, size: 38157 Added