Documentation Source Text

Timeline
Login

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

93 check-ins using file pages/whentouse.in version b73c5ece71

2009-10-24
20:34
Add the list-of-documents document. (check-in: 2e29944d92 user: drh tags: trunk)
02:07
Add line numbers to evidence displays. (check-in: 34a8386536 user: drh tags: trunk)
2009-10-23
20:59
Get evidence formatting, including backlinks, working. Bug fixes. (check-in: e528058980 user: drh tags: trunk)
19:17
Convert the requirements matrix generation over to use an SQLite database instead of a pile-of-files. There are still a few bugs, but the basic functionality is in place. (check-in: cbad51201d user: drh tags: trunk)
00:42
Update the documentation build process so that it uses a TCLSH that is built using tclsqlite3.c and which contains SQLite and MD5 commands built in. (check-in: 5d48a990bf user: drh tags: trunk)
2009-10-22
17:59
Change the makefile to automatically update the HTMLized evidence files on a full make. (check-in: fda1430aa2 user: drh tags: trunk)
17:53
Updates to pragma and optimizer documents. Add the evidence formatter and make corresponding revisions to the tracability matrix generator. (check-in: 687a957242 user: drh tags: trunk)
2009-10-21
20:08
Update requirements matrix generation so that requirements originating from separate documents go on separate pages. doc/matrix/matrix.html is now an index. (check-in: 4055cca797 user: drh tags: trunk)
13:44
Fix a typo in the foreign key documentation. (This changes on requirement number.) Identify new requirements in SQL function implementations. (check-in: 00a66e6757 user: drh tags: trunk)
00:19
When gathering test evidence, distinguish between th3/cov1 and th3/req1. (check-in: b58936c42e user: drh tags: trunk)
2009-10-20
20:51
Update the documentation for the built-in replace() function to make it clear that it works with text strings only, and not blobs. (check-in: dbf93ec2f9 user: drh tags: trunk)
13:54
Updates to the optoverview.html document to explain the recent changes to the LIKE and GLOB operator and how they now might be optimized when their RHS is host parameter. (check-in: 0b4f64fd77 user: drh tags: trunk)
13:48
Clarification on the meaning of the cache_size pragma and how the default page cache implementation interprets that pragma. Changes driven by src ticket f80d443a3b. (check-in: 6498c96895 user: drh tags: trunk)
05:32
Update the question about foreign key support in faq.html. (check-in: eaf2d456db user: dan tags: trunk)
2009-10-17
08:25
Add keywords to two sections in optoverview.in. So that documentation for sqlite3_reoptimize() can link to them. (check-in: 15b96b6b0a user: dan tags: trunk)
2009-10-14
02:43
Documentation updates prior to the release of version 3.6.19. (check-in: 9598affd43 user: drh tags: trunk)
2009-10-13
01:03
Tweaks to composite foreign key documentation. (check-in: f91582d301 user: drh tags: trunk)
2009-10-12
22:31
Ignore a closing comment mark ("*/") at the end of evidence comments. Show non-TCL and non-TH3 evidence in the matrix. (check-in: b8f9c4f046 user: drh tags: trunk)
17:56
Additional updates, improvements, and corrections to section 3 of the foreignkeys.html document. (check-in: a6630ea9bd user: drh tags: trunk)
15:28
Fix a bug in the way the matrix generator script computes requirement numbers using MD5 - remove surplus spaces before running MD5 over the text. Also check-in some updates to the foreignkeys.html document. (check-in: 87ab34e6a7 user: drh tags: trunk)
14:02
Fix a comma-splice in a sentence in the foreignkey.html document. (check-in: 74815839cd user: drh tags: trunk)
13:57
Fix another typo in the same SQL example of foreignkeys.html (check-in: a20a86f146 user: drh tags: trunk)
13:54
Add a missing semicolon to an SQL example in foreignkeys.html (check-in: 768c8f120d user: drh tags: trunk)
12:35
Further adjustments to the "evidence" target in the makefile. On the matrix translations of documents, color truth-statements orange if tested by only one of TH3 or TCL. (check-in: 9e600a556b user: drh tags: trunk)
12:05
Text clarifications in the fileformat.html docuement. Add the "evidence" target to the makefile. (check-in: a0c9d1890c user: drh tags: trunk)
2009-10-10
15:40
Fix typo in hyperlink in date-time function documentation. (check-in: dab9f1a7ac user: drh tags: trunk)
14:48
Tweaks to the foreign key documentation. (check-in: de5e4731cd user: drh tags: trunk)
14:34
Add a missing word to foreignkeys.html. (check-in: 7e3189adf2 user: dan tags: trunk)
14:28
Minor rewording of the foreignkeys.html document. Some requirements changed. Update the testcase evidence scanner to better handle evidence comments in TCL scripts. (check-in: 6dd77467c3 user: drh tags: trunk)
12:11
When scanning for test case evidence, allow comments to be indented. Scan the th3/cov1/*.test files in addition to th3/req1/*.test. (check-in: 3f08e43e76 user: drh tags: trunk)
2009-10-09
20:34
Syntax diagrams are now issued requirement numbers (based on a hash of the GIF image) and appear in the traceability matrix. (check-in: a8aba3f4bd user: drh tags: trunk)
17:48
Update the scanner and matrix generator to allow requirements text to follow a requirement number. Issue a warning if they disagree. (check-in: 329a3eafd7 user: drh tags: trunk)
17:22
Remove an incorrect sentence from foreignkeys.html. (check-in: 3677b8fc81 user: dan tags: trunk)
17:20
Update the test-case scanning tools to recognize the complete text of requirements following the "EV:" tag. (check-in: d2743d6c2a user: drh tags: trunk)
14:18
Generate the abbreviated traceability matrix showing only requirement numbers. (check-in: 0bfb260a9f user: drh tags: trunk)
13:33
Updates to Omitted Features. Add fragments to the foreign key document. Other documentation tweaks. (check-in: fe28facf39 user: drh tags: trunk)
13:30
Remove an incorrect paragraph from foreignkeys.in. Fix a few other small details. (check-in: de78ea29fa user: dan tags: trunk)
2009-10-08
11:19
Use ^( instead of ^ on a sentence in foreignkeys.in. (check-in: 70b1eab895 user: dan tags: trunk)
2009-10-07
18:43
Fix a sentence in foreignkeys.in. (check-in: 90c2bee863 user: dan tags: trunk)
12:56
In the webserver, any "%xx" in the inbound URL is converted into a single "_" character, regardless of the value of "xx". Formerly, "%xx" was converted into "_xx". This is to work around an issue on URIs inbound from stackoverflow.com. (check-in: 1ef729b05d user: drh tags: trunk)
10:45
Update the description of the "PRAGMA count_changes" command to describe the way changes made by foreign key actions are handled. (check-in: 52421d8609 user: dan tags: trunk)
01:15
Add "See also:" annotations to the syntaxdiagrams.html page. Fix a quoting mistake on pragma.html. (check-in: 365401b552 user: drh tags: trunk)
00:31
Update SQL language and foreign key documentation to better identify testable statements of truth about foreign keys. (check-in: cc6bec4374 user: drh tags: trunk)
2009-10-06
19:07
Add foreign key related statements to the documentation for the ALTER and DROP TABLE commands. (check-in: 4ca8a0c958 user: dan tags: trunk)
19:04
Updates matrix building scripts to ignore "." contained within markup. (check-in: 9e64626f1d user: drh tags: trunk)
17:03
All code in place for generating the requirements matrix. (check-in: b349e0f779 user: drh tags: trunk)
15:54
First code to build the requirements matrix. (check-in: 9334d5b6e0 user: drh tags: trunk)
11:59
Begin making changes that allow requirements text to be extracted directly from HTML documentation files. (check-in: 912746a5f1 user: drh tags: trunk)
2009-10-05
19:00
Remove all "^" characters from documentation text. This frees up that character for use in marking up requirements. (check-in: 1ce21e60da user: drh tags: trunk)
2009-10-02
05:48
Change pragma.html to say that the foreign_keys and recursive_triggers affect existing statements as well as those prepared after the setting is changed. (check-in: bdc6c4820c user: dan tags: trunk)
2009-09-29
05:52
Update foreignkeys.html to explain the changes to DROP and ALTER TABLE, and to remove the comments on the "immediate-immediate" constraint problem. (check-in: f21e45d5b6 user: dan tags: trunk)
2009-09-26
15:17
Revise the "Report A Bug" link to point to a wiki page explaining how to report a bug. (check-in: 21d37e66b1 user: drh tags: trunk)
2009-09-25
19:28
Fix an HTML typo in the TH3 document. (check-in: b767931a6e user: drh tags: trunk)
04:35
Fix the mismatched tags problem identified by [2cda06fa85]. (check-in: 1c76780f1c user: dan tags: trunk)
2009-09-23
15:20
Add change-log entries for the next release (3.6.19) (check-in: 9cb5891238 user: drh tags: trunk)
09:19
Add a comment to foreignkeys.html to make it clear that an ON UPDATE action is only performed if the parent key values modified so that the new values are distinct from the old. (check-in: cb8c404c1e user: dan tags: trunk)
2009-09-22
15:32
Add documentation for the foreign_keys pragma. Fix broken hyperlinks in the new foreign key constraints document. (check-in: bdfaef8a63 user: drh tags: trunk)
14:24
Add a link to foreignkeys.html to the main documentation index. (check-in: 37c1ac481d user: dan tags: trunk)
12:30
Extra details in the foreign keys document. (check-in: 02d2a1296b user: dan tags: trunk)
10:34
Enhance foreign key support page. (check-in: 3f9fde89b3 user: dan tags: trunk)
2009-09-21
19:07
Add an example of an index on a child key to foreignkeys.in. (check-in: a636d1d50b user: dan tags: trunk)
15:29
Add partially finished document "foreignkeys.in". (check-in: 639baca342 user: dan tags: trunk)
14:26
Correct the syntax of foreign key constraints. (check-in: 029b30de8c user: drh tags: trunk)
14:16
Remove the "last modified" line from the bottom of static web pages. It is no longer accurate. (check-in: 20d509a7ff user: drh tags: trunk)
01:41
Publish limitations on the 'unixepoch' modifier in the date and time functions. (check-in: 90ac5bfac9 user: drh tags: trunk)
2009-09-12
04:03
Mention in the date/time function documentation that dates outside the range 0000 through 9999 are unsupported. (check-in: 62853a0196 user: drh tags: trunk)
2009-09-11
16:09
Fix a typo in the sharecache.html document. (check-in: 19b6c05c73 user: drh tags: trunk)
15:58
Fix typos in the "changes" page for 3.6.18. (check-in: a7ffc62c5d user: drh tags: trunk)
15:34
Redate the 3.6.18 release. Final updates to the testing.html page. (check-in: c696d563cc user: drh tags: trunk)
15:25
Add the logo GIF. Many tweaks to the documentation in preparation for the release of 3.6.18. (check-in: 7c598abfd6 user: drh tags: trunk)
2009-09-09
19:31
Added a remark about the added SQLITE_SOURCE_ID information in 3.6.18. (check-in: 1747c9d69e user: drh tags: trunk)
17:04
Fix a typo in the recursive_triggers pragma documentation. (check-in: 00a2203dba user: drh tags: trunk)
17:00
Fix a typo on the 3.6.18 release notes. (check-in: d83bd759e2 user: drh tags: trunk)
16:22
Additional documentation updates in preparation for 3.6.18. (check-in: ab3114e96d user: drh tags: trunk)
2009-09-07
20:06
Make it clear that BEFORE triggers that change rows out from under the subsequent UPDATE or DELETE will result in undefined behavior. (check-in: a48fa42fae user: drh tags: trunk)
18:27
Add documentation of SQLITE_MAX_TRIGGER_DEPTH. (check-in: df753f0371 user: drh tags: trunk)
2009-09-01
14:05
Remove references to CVSTrac. Replace with corresponding Fossil references. (check-in: cc8dbfcb61 user: drh tags: trunk)
12:27
Make the "developers page" a hard-coded document, not a wiki page in CVSTrac. (check-in: faaa8cbcf3 user: drh tags: trunk)
2009-08-31
13:47
Query planner documentation update. (check-in: d8db9f9b5c user: drh tags: trunk)
2009-08-26
13:13
Tweaks to the testing documentation. (check-in: 3b5097e255 user: drh tags: trunk)
02:00
Updates, clarifications, and typo fixes in the SQL language documentation. (check-in: 7b2b285803 user: drh tags: trunk)
00:29
Updates to the testing.html and different.html documents. (check-in: 197d293511 user: drh tags: trunk)
2009-08-24
23:31
Fix typos in malloc.html. (check-in: 292c7157b4 user: drh tags: trunk)
23:05
Fix typos in the testing.html document. (check-in: 41a06717b5 user: drh tags: trunk)
14:50
Begin updating the change history in preparation for 3.6.18. Modify the download page to reference the new fossil repositories. Link in the www2.sqlite.org backup website. (check-in: 9f9705ea83 user: drh tags: trunk)
2009-08-22
02:53
Updates to the query planner documentation. (check-in: ded8a7f88c user: drh tags: trunk)
2009-08-19
15:55
Further miscellaneous documentation improvements. (check-in: 37edbace2a user: drh tags: trunk)
13:54
Fix a typo in the documentation of INSERT. Ticket [e07f262a63441]. (check-in: 6fbc1f9707 user: drh tags: trunk)
13:52
Miscellaneous documentation enhancements and cleanup. (check-in: 31954ec184 user: drh tags: trunk)
2009-08-14
18:43
Update the documentation makefile to use mksqlite3h.tcl rather than trying to process sqlite.h.in on its own. (check-in: e982745da1 user: drh tags: trunk)
18:28
Add documentation for the sqlite_source_id() SQL function. (check-in: ad4301a8a1 user: drh tags: trunk)
18:26
Update hyperlinks to point at the fossil-scm rather than CVSTrac. (check-in: 8de414fe8f user: drh tags: trunk)
2009-08-10
11:46
Fix a few spelling typos. (check-in: c3ed16c6d3 user: dan tags: trunk)