Documentation Source Text

Timeline
Login

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

105 check-ins using file Makefile version be3db6d826

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
13:25
Last minute documentation tweaks before the release of 3.6.17. (check-in: 87b76c67f1 user: drh tags: trunk)
11:46
Fix a few spelling typos. (check-in: c3ed16c6d3 user: dan 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)