Documentation Source Text

Timeline
Login

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

80 check-ins using file pages/whentouse.in version 3c47731f10

2009-08-10
13:25
Last minute documentation tweaks before the release of 3.6.17. (check-in: 87b76c67f1 user: drh tags: trunk)
11:26
Fix typo in serverless.html. (check-in: 1ac9233c15 user: dan tags: trunk)
2009-08-09
22:27
Fixes to tcl documentation: Add docs for "version" and "profile" methods, add a hyperlink to the existing "incrblob" documentation. (check-in: 2eccbd9b76 user: dan tags: trunk)
2009-08-06
17:47
Change docs to talk about the fact that virtual tables and shared cache can be used together beginning with version 3.6.17. (check-in: 68debd1491 user: drh tags: trunk)
2009-08-01
18:38
Updates in preparation for version 3.6.17. (check-in: c5059a139a user: drh tags: trunk)
2009-07-31
20:36
Expanded documentation on test coverage. Added the "th3.html" page for describing the TH3 program. (check-in: 6bac792113 user: drh tags: trunk)
2009-07-30
10:51
Update documentation to talk about 100% test coverage in SQLite. (check-in: f7aa8bfebf user: drh tags: trunk)
2009-07-29
23:07
Merge lang.html and vtab.html corrections that got marooned on a branch into the main line. (check-in: ab7c4f5247 user: drh tags: trunk)
06:32
Fix a typo in c3ref/intro.html. (check-in: a3ee478f75 user: dan tags: trunk)
2009-07-03
15:38
Enhance the CREATE TRIGGER documentation to describe restrictions on INSERT, UPDATE, and DELETE statements that occur within triggers. CVS Ticket #3947. (check-in: b7dfcf7883 user: drh tags: trunk)
2009-07-02
00:26
Add LLR to do with the advisory b-tree locks used in shared-cache mode. (check-in: a4e2a17a94 user: dan tags: trunk)
2009-06-27
14:07
Preparing for the 3.6.16 release. (check-in: 5eeec98501 user: drh tags: trunk)
2009-06-23
14:36
Preparations for the 3.6.16 release. (check-in: 1793436b49 user: drh tags: trunk)
2009-06-17
03:30
Note an error in fileformat.html. (check-in: 69b129b4a4 user: dan tags: trunk)
2009-06-13
10:59
Remove an unrequired "todo" in btreemodule.html. (check-in: 1563461430 user: dan tags: trunk)
2009-06-12
12:06
Add more notes to btreemodule.html. (check-in: da4bf79ef3 user: dan tags: trunk)
2009-06-11
03:44
Add a diagram for delete operations. (check-in: dbcfaf4922 user: dan tags: trunk)
2009-06-09
11:58
Add a few interface requirements to btreemodule.html. (check-in: 9949936e6e user: dan tags: trunk)
00:55
Correct the description on how short_column_names and full_column_names interact. (check-in: 787c316f3f user: drh tags: trunk)
00:52
Fill in a couple of missing details wrt balance_nonroot (balance-siblings). (check-in: 273d1c6fee user: dan tags: trunk)
2009-06-08
13:39
Begin preparing the website for the 3.6.15 release. (check-in: 4b07b4204a user: drh tags: trunk)
12:57
Fix typos in the privatebranch document. (check-in: dea8397e9a user: drh tags: trunk)
12:30
Add extra details on balance-siblings algorithm to btreemodule.html. (check-in: 9e047c0045 user: dan tags: trunk)
07:19
Change the form of the tags used to embed svg images. (check-in: cd56d0a98c user: dan tags: trunk)
06:23
Add a few lines to btreemodule.html. (check-in: 982ca6b660 user: dan tags: trunk)
04:45
Update datatype3.html to mention that CAST expressions have an affinity. (check-in: 0b44acac20 user: dan tags: trunk)
00:34
Updates to the private branch document. (check-in: 78188e762a user: drh tags: trunk)
2009-06-07
00:01
Add a rough draft of the document describing how to use fossil to maintain a private branch of SQLite. (check-in: ce4ee2b8d3 user: drh tags: trunk)
2009-06-06
22:39
Add diagrams for balance-deeper and balance-quick. (check-in: 9e5e77c76e user: dan tags: trunk)
12:06
Progress on btreemodule.html. (check-in: 2b4a307362 user: dan tags: trunk)
2009-06-02
19:19
Fix a typo on the Documents page. (check-in: ee05430080 user: drh tags: trunk)
09:50
Progress on btreemodule.html. (check-in: e40416fac3 user: dan tags: trunk)
01:37
Fix a typo in download.html reported as cvstrac ticket #3892. (check-in: 0f6eae0c0d user: dan tags: trunk)
2009-06-01
12:04
Work on b-tree requirements. (check-in: fdf074286b user: dan tags: trunk)
2009-05-30
11:45
Progress on btreemodule.html (check-in: 7274af9a66 user: dan tags: trunk)
2009-05-29
12:12
Add hlr50000.txt. (check-in: 208f3f4f7c user: dan tags: trunk)
12:10
Incremental progress on btree module documentation. (check-in: 42037c5bc7 user: dan tags: trunk)
2009-05-28
11:53
Add a skeleton and some notes for btree module documentation. (check-in: 209bab6a3d user: dan tags: trunk)
2009-05-26
23:52
Fix an error in the previous commit. A "todo" note was added in the wrong place. (check-in: e0634484e3 user: dan tags: trunk)
23:13
Improve the internal links from text to glossary definitions in fileformat.html. Also fix a bunch of issues reported by John Machin on the mailing list. (check-in: c5aa49ff35 user: dan tags: trunk)
15:13
Add a "todo" note to fix the schema file-format range. Also fix another todo in fileformat.html. (check-in: 14e677d1dc user: dan tags: trunk)
04:32
Modify some requirements in fileformat.html to make them more testable. (check-in: 9a9955c381 user: dan tags: trunk)
2009-05-25
12:47
Enhancements to the news.html text for the 3.6.14.2 release. (check-in: f286448352 user: drh tags: trunk)
12:37
Get the date right on the 3.6.14.2 release notes. (check-in: 0cbb3524aa user: drh tags: trunk)
12:34
Preparations for the 3.6.14.2 release. (check-in: 57157e0e9e user: drh tags: trunk)
2009-05-24
23:20
Fill in some missing definitions and combine some requirements in fileformat.html. (check-in: 9c0dadcbb7 user: dan tags: trunk)
22:00
Remove requirement H16124. If the 3rd parameter to sqlite3_create_function is outside the range -1...127 then the behavior is undefined. (check-in: 4f36464caa user: drh tags: trunk)
11:01
Documentation fix: the sqlite3_create_function() interfaces return SQLITE_MISUSE of the number of arguments parameter is out of range. (check-in: d06c1c4318 user: drh tags: trunk)
2009-05-22
11:45
Add some more links to the docs.html page. Group the links under headings to try to make it easier to find pages. (check-in: 379b9f7acd user: dan tags: trunk)
2009-05-21
11:36
Minor edits of fileformat.html. (check-in: e216c81d99 user: dan tags: trunk)
2009-05-20
11:36
Modifications to the introduction of the file format document. (check-in: 0f0af25556 user: dan tags: trunk)
08:58
Reduce the number of requirements in fileformat.in governing updating the database file. It is not possible to have too much detail without also defining the expectations SQLite has of a file-system, which is not in scope. (check-in: fcd47d8a18 user: dan tags: trunk)
2009-05-18
23:21
Last minute tweaks to the 3.6.14.1 release documentation. (check-in: f8fba45763 user: drh tags: trunk)
17:37
Changes in preparation for the 3.6.14.1 release. (check-in: 4abdcb6c1c user: drh tags: trunk)
2009-05-14
23:56
Miscellaneous documentation and hyperlink tweaks. (check-in: 5856a03e9a user: drh tags: trunk)
20:45
Better doc_pagelink_crossref.html support. Now catches more hrefs outputted directly via hd_puts. (check-in: d0a850961d user: shaneh tags: trunk)
18:13
Generate doc_pagelink_crossref.html which shows which pages link to which. Useful for finding orphans. (check-in: bd0b540d7b user: shaneh tags: trunk)
18:12
Changed lang.html to use hd_resolve for linkage rather than crafted links. (check-in: 17a3eefb66 user: shaneh tags: trunk)
2009-05-11
17:41
Document the goofy behavior of PRIMARY KEY(x DESC) still allowing x to be a rowid if it is of type INTEGER. (check-in: b354d15151 user: drh tags: trunk)
14:24
Fixed typo. (check-in: 218a28e1d5 user: shaneh tags: trunk)
14:24
Initial error list checkin. (check-in: 7276f4a4a3 user: shaneh tags: trunk)
2009-05-10
15:57
Fix a bug in the foreign-key-clause syntax diagram: the ON DELETE clause and its friends are all optional. (check-in: 3562d60bc7 user: drh tags: trunk)
2009-05-06
23:57
Fix a typo in the release 3.6.14 news blurb. (check-in: a431922439 user: drh tags: trunk)
17:24
Add the asyncvfs.html documentation file. Prepare for the 3.6.14 release. (check-in: 81cdc75444 user: drh tags: trunk)
2009-05-05
18:23
Website updates in preparation for the 3.6.14 release. (check-in: e3715164fb user: drh tags: trunk)
2009-05-01
10:45
Add text describing file locking and the database header cookies (file and schema versions) to fileformat.html. (check-in: ca6db0c14f user: dan tags: trunk)
2009-04-30
16:00
Update the DELETE documentation to discuss the truncation optimization. (check-in: dcd3325dd3 user: drh tags: trunk)
2009-04-29
14:33
Update trigger documentation. (check-in: 1179f9425f user: drh tags: trunk)
10:16
Fix a bug in the formula to compute the layout of index b-tree cells. (check-in: 7e6a5768d9 user: dan tags: trunk)
2009-04-28
15:51
fileformat.html updates. (check-in: 7962286919 user: dan tags: trunk)
2009-04-27
18:20
Further updates to fileformat.html. (check-in: 47c1a4a97e user: dan tags: trunk)
11:59
Updates to fileformat.html. (check-in: 712d82fbd7 user: dan tags: trunk)
2009-04-21
16:14
Added a new FAQ to explain how the syntax diagrams are created. (check-in: 74c109fae7 user: drh tags: trunk)
2009-04-20
17:43
Update documentation to describe how pragma journal_mode will work as long as there is no pending transaction. (check-in: 8bb233e0af user: drh tags: trunk)
13:29
Update the documentation to explain that the journal_mode must be set prior to the first transaction. CVSTrac ticket #3811. (check-in: 3a4c37b08b user: drh tags: trunk)
2009-04-17
12:30
Added documentation on the SQLITE_HAVE_ISNAN compile-time option. (check-in: d1b62a10d5 user: drh tags: trunk)
2009-04-15
12:56
Fix typos in the vtab.html document. (check-in: e9e994caf8 user: drh tags: trunk)
2009-04-14
18:20
More virtual table documentation tweaks. (check-in: 0d0a959a73 user: drh tags: trunk)
18:15
Update to the virtual table documentation - in particular the documentation on the xUpdate method. (check-in: feccb40483 user: drh tags: trunk)
11:45
Additional virtual table documentation improvements. Fix the "when-to-use" document to omit discussion of the obsolete bitmap size limits. (check-in: 9ef2178fee user: drh tags: trunk)