Documentation Source Text

Timeline
Login

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

127 check-ins using file pages/fileformat2.in version eeec6d2205

2010-03-10
23:17
Fix typo in change log for 3.6.23. (check-in: 128ffc00f3 user: drh tags: trunk)
2010-03-09
19:35
Update the testing.html document and the release date of 3.6.23. (check-in: 15837d1afc user: drh tags: trunk)
02:22
Move the proposed release date for 3.6.23 to 2010-03-10. (check-in: 612e4dfe61 user: drh tags: trunk)
2010-03-08
00:49
Allow the colon character (ASCII 0x3a) as a valid character in the body of a URL. (check-in: dba0a9dc4b user: drh tags: trunk)
2010-02-26
15:39
Add documentation for sqlite3_compileoption_get() and related routines and pragmas. Fix up hyperlinks. (check-in: 4d3f01f58b user: drh tags: trunk)
14:05
Begin updating the documentation for the 3.6.23 release. (check-in: e45a1175e7 user: drh tags: trunk)
2010-02-16
13:35
Fix typo in the cintro.html document. (check-in: 56add885f4 user: drh tags: trunk)
2010-02-15
13:41
Editorial changes to the unlock-notify application note. (check-in: e5ce924181 user: drh tags: trunk)
2010-02-13
15:43
Correction to the PRAGMA secure_delete documentation. (check-in: 9523519a73 user: drh tags: trunk)
2010-02-12
19:58
Update the secure_delete pragma documentation to conform to the latest implementation. (check-in: e4d2cd7fd1 user: drh tags: trunk)
18:34
Update the documentation to include information about the new secure_delete pragma. (check-in: ae2879358d user: drh tags: trunk)
2010-02-11
15:55
Fix typo in the datatype3.html document. (check-in: d9afa1a3d7 user: drh tags: trunk)
2010-02-09
23:25
Add an evidence mark to a statement in fts3.in. Add an evidence mark to a statement in fts3.in. (check-in: 58746651dd user: dan tags: trunk)
2010-02-01
16:19
Updates to the matrix generator and to the custombuild.html document. (check-in: 801e11b806 user: drh tags: trunk)
16:18
Fix a typo in the FTS3 documentation. (check-in: f0a07e571f user: drh tags: trunk)
2010-01-21
09:12
Modify the search script so that it does not index the header at the top of each page or generated TOCs. (check-in: 9a1f417e0b user: dan tags: trunk)
06:06
Change foreignkeys.in to be more similar to other documentation files. (check-in: 7889bfe143 user: dan tags: trunk)
2010-01-20
18:32
Change the way the fts3.html document is generated to be more similar to most of the other documents. (check-in: e3ae335670 user: dan tags: trunk)
05:52
Fix typo in fts3.html. (check-in: 897b36953b user: dan tags: trunk)
2010-01-18
14:12
Add a section to fts3.in to explain how to use the matchinfo() function efficiently. (check-in: 0917dec067 user: dan tags: trunk)
2010-01-15
05:16
Fix another typo in custombuild.html. (check-in: 06a55cbcb5 user: dan tags: trunk)
01:21
Fix typos in the custombuild.html document. (check-in: 63f32cf18c user: drh tags: trunk)
2010-01-14
11:43
Fix an error in the matchinfo example in fts3.html. (check-in: ceff4c1d37 user: dan tags: trunk)
09:56
Update backup.in to explain that writing to an in-memory source database mid-backup causes the entire backup operation to be restarted in the next call to backup_step(). (check-in: f5ee14345e user: dan tags: trunk)
2010-01-13
22:15
Add fragments to headings of longer documents. (check-in: ad70832674 user: drh tags: trunk)
18:09
Add a description of matchinfo() and update the description of snippet() in fts3.html. (check-in: c31f4ab8b8 user: dan tags: trunk)
2010-01-12
17:35
Add many new anchors to the testing.html document. (check-in: 9203c7ec38 user: drh tags: trunk)
2010-01-11
21:37
Reword the documentation on the changes() SQL function to be more precise. (check-in: eb60d9c9d6 user: drh tags: trunk)
2010-01-09
15:59
Omit the display of keywords in search results. Keywords are still used in the search, they are simply not shown to the user because they did not seem to add anything valuable but they did clutter the display. (check-in: f304bbe41c user: drh tags: trunk)
15:37
Tweak the display of scoring on the search results page. (check-in: 3d2b460664 user: drh tags: trunk)
08:29
Improve handling of quote characters in search script. (check-in: 22781f7cbe user: dan tags: trunk)
07:34
Fix a couple of snippet related examples in fts3.html. (check-in: d8f53c98a9 user: dan tags: trunk)
2010-01-08
18:17
Corrections to substr() documentation text. Updates to the makefile. (check-in: bdfb8d83ff user: drh tags: trunk)
17:57
Filter out <script> tags when building the search database. (check-in: bfc81cf6e4 user: dan tags: trunk)
16:29
Make sure search works even if the q= parameter is omitted. Suppress the s=Go parameter on queries. (check-in: 817a320509 user: drh tags: trunk)
16:08
Move anchors of core function definitions from the description to the function name. This gives better search results. (check-in: ae27557119 user: drh tags: trunk)
15:38
Add a tag missing from documentation headers built when search is not enabled. (check-in: 42ce6e37be user: dan tags: trunk)
15:17
Add the search input text box to the menu bar. The search box is only added if the SEARCH file is present in the build directory when "make all" is run. Updates to the search results display page. (check-in: 7f31aaf373 user: drh tags: trunk)
00:31
Update the makefiles so that the TCL extensions used to build the FTS3 tables for the search function are built using STUBS. (check-in: 17ee5a34e9 user: drh tags: trunk)
2010-01-07
18:09
Add the "searchdb" target to the Makefile. For building the doc/search.db database used by the search cgi script. (check-in: e8a8c227d5 user: dan tags: trunk)
16:27
Add a <title> to the copyright-release.html document. (check-in: 1ecb24abf0 user: drh tags: trunk)
16:13
Add the "Search" menu option to the menu bar. (check-in: 6e06b9d9b4 user: drh tags: trunk)
15:58
Updates to the aggregate function documentation. (check-in: 716c872b13 user: drh tags: trunk)
2010-01-06
23:32
Simplifications to the description of keywords. Avoid any decision of the keywords that can, sometimes, be used as identifiers because that adds nothing to the conversation. (check-in: a9db62dba3 user: drh tags: trunk)
20:57
Fix a typo on the books.html page. (check-in: 82cfff06e6 user: drh tags: trunk)
17:38
Updates to search script. (check-in: 39f3bd86d6 user: dan tags: trunk)
17:01
Add the new Symbian book to the books.html page. (check-in: efbd2b8858 user: drh tags: trunk)
2010-01-05
23:31
Last minute changes before the 3.6.22 release. (check-in: 25998dce13 user: drh tags: trunk)
2010-01-02
18:49
Add source code for documentation search page. (check-in: 793a5fcb1b user: dan tags: trunk)
03:20
Add ACTION and NO to the list of keywords in the lang_keywords.html document. Reformat the keyword lists into testable statements. (check-in: 8cad2470c0 user: drh tags: trunk)
2010-01-01
14:46
Updates to the datatype3.html document to fix issues found while writing tests against that document. (check-in: 490c97c96c user: drh tags: trunk)
2009-12-31
22:14
Add the "any" column to the requirement matrix summary screen. The box goes green if all requirements are covered by any combination of TCL, TH3, our source code evidence. (check-in: 1c49dd8699 user: drh tags: trunk)
18:30
Fix incorrect documentation concerning affinity of UNION, INTERSECT, and EXCEPT. (check-in: 6fe30b1e8d user: drh tags: trunk)
16:06
Add HTML escapes back into requirement text when generating HTML in the requirements matrix. (check-in: ca108712a2 user: drh tags: trunk)
15:51
Another patch needed for the ampersand-escape mapping. (check-in: af45a586ba user: drh tags: trunk)
15:28
Convert HTML ampersand-values "&lt;", "&gt;", and "&amp;" into "<", ">", and "&" prior to computing the hash for a requirement. (check-in: 8822607ccf user: drh tags: trunk)
14:47
Clarifications on affinity handling in the datatype3.html document. (check-in: e62a74f31a user: drh tags: trunk)
2009-12-30
18:17
The FLOATING POINT datatype has INTEGER affinity due to the "INT" at the end of "POINT". Make this clear in the datatype3.html documentation file. (check-in: 5c8750d0ff user: drh tags: trunk)
15:32
Fix some typos in datatype3.html. (check-in: 3da8351ec8 user: dan tags: trunk)
14:53
Update the documentation in preparation for the release of 3.6.22. (check-in: 758f10c6da user: drh tags: trunk)
2009-12-25
02:53
Additional refinements to the datatype3.html document. (check-in: 4737512960 user: drh tags: trunk)
2009-12-24
21:37
Update and clarify the documentation on datatypes and on CAST expressions. (check-in: e357f599e3 user: drh tags: trunk)
16:02
Clarifications to the datatype3.html document. (check-in: 75e2505670 user: drh tags: trunk)
00:08
Tweaks to the autoinc.html page. Add a new evidence style: ANALYSIS-OF: (check-in: 1247769d7f user: drh tags: trunk)
2009-12-22
01:37
Update the download page to show all three self-synchronizing fossil repositories for the documentation sources. (check-in: 5e4ecf297e user: drh tags: trunk)
01:09
Add more requirements marks to the optoverview.html document. (check-in: 10b7c35b44 user: drh tags: trunk)
2009-12-21
17:10
Modify the evidence file HTMLization process to put evidence files in separate directories to avoid name collisions. (check-in: 95ddf6f2f8 user: drh tags: trunk)
15:45
Add the new "private" target to the makefile - used to build the requirements matrix that includes TH3 hyperlinks. (check-in: 3d7eb1e8f0 user: drh tags: trunk)
2009-12-15
14:34
Clean up and extend the privatebranch.html document. (check-in: b44ff2a454 user: drh tags: trunk)
14:05
Fix a typo in the privatebranch.html document. (check-in: 04a7a8e7dd user: drh tags: trunk)
00:29
Add requirements markings to the pragma documentation. (check-in: a900d49554 user: drh tags: trunk)
2009-12-14
23:00
Identify requirements in the autoinc.html and datatype3.html documents. Make corrections in datatype3.html for accuracy and for clearer presentation. (check-in: e18ce3ebd0 user: drh tags: trunk)
17:41
For the requirements matrix, scan evidence marks in the original source code, not in the amalgamation. Updates to SQL comment documentation. (check-in: dca51f132e user: drh tags: trunk)
2009-12-13
23:03
Additional cleanup in the SQL language documentation. (check-in: d508b9e21c user: drh tags: trunk)
22:20
Updates to the SQL language documentation - mostly to fix requirements marks. (check-in: b80a69c002 user: drh tags: trunk)
2009-12-12
23:58
Continuing improvements to the SQL language documentation. (check-in: f9931b6e49 user: drh tags: trunk)
18:29
Updates to the matrix generator so that it outputs prototype evidence comments for easy cut-and-paste into test cases. Rewrite the CASE section of the SQL expression documentation. (check-in: 01a939084b user: drh tags: trunk)
15:32
Fix some requirements markings. Changes the evidence scanner to understand that requirement text that begins with "--" is comment, not actual requirement text. (check-in: 88da6668cb user: drh tags: trunk)
01:14
Add requirements markings and a section on the CASE expression to the SQL language documentation. (check-in: ac0c9ef1a2 user: drh tags: trunk)
2009-12-11
16:54
Remove the old-style requirements documents from the set of documentation pages generated. (check-in: f259e08f31 user: drh tags: trunk)
16:34
Ignore case when sorting entries for the doc_backlink_crossref.html page. (check-in: 2c70d4b893 user: drh tags: trunk)
16:33
Fix a typo in the google url on the famous.html page. (check-in: 66c988ccf9 user: drh tags: trunk)
14:46
Change fts3.html to present the new INSERT syntax used to optimize the full-text index. (check-in: f6c99b3cc3 user: dan tags: trunk)
14:20
Comment out the line in althttpd that disallows the msnbot. We are going to give Bing a second chance.... (check-in: 101a84e46c user: drh tags: trunk)
2009-12-10
20:28
Enhance the requirements matrix generator to report duplicate text requirements. (check-in: b6c54837b9 user: drh tags: trunk)
2009-12-08
02:04
Further updates to the SQL function documentation. (check-in: e265a59cf0 user: drh tags: trunk)
2009-12-07
23:47
Updates and clarifications to the built-in SQL function documentation. Mark key sentences in that documentation as requirements. (check-in: 34346a758d user: drh tags: trunk)
20:51
Corresponding to SQLite version 3.6.21. (check-in: 81b9488b48 user: drh tags: trunk, release)
15:40
Change the names of the OSX download products. (check-in: a542163c9c user: drh tags: trunk)
15:02
Change the 3.6.21 release date to 2009-12-07. (check-in: 81494ab7d5 user: drh tags: trunk)
2009-12-05
19:07
Fix a minor typo in fts3.html. (check-in: a92e1357cb user: dan tags: trunk)
2009-12-04
07:50
Clarify that the values stored in the rowid of an FTS3 table do not change when the database is VACUUMed. (check-in: 39d5f660c5 user: dan tags: trunk)
2009-12-03
18:14
Change 3.6.21 release date. Fix typos reported by internet reviewers. (check-in: c922c8ef50 user: drh tags: trunk)
2009-12-02
08:41
Fix typo in howtocompile.in markup. (check-in: a47d474c56 user: dan tags: trunk)
03:14
Add the FTS3 documentation to the categorized documentation listing page. (check-in: 8de37e9f07 user: drh tags: trunk)
2009-12-01
15:41
Update the amalgamation.html page. (check-in: d8e32e270e user: drh tags: trunk)
15:30
Fix two more typos in examples in fts3.in. (check-in: d075300786 user: dan tags: trunk)
14:27
Fix a couple of bugs in the examples in fts3.in. (check-in: 9bd28d637b user: dan tags: trunk)
2009-11-30
15:37
Clarify authorship of the original FTS3 code in fts3.html. (check-in: daf96c0053 user: dan tags: trunk)
15:27
Update indicative performance numbers for populating a large database in fts3.html. (check-in: 54090fd49f user: dan tags: trunk)
13:55
Fix typo on the famous.html page. Other updates prior to publication. (check-in: 5572b2965d user: drh tags: trunk)
11:52
Fix some problems with fts3.html. (check-in: 0b949f6763 user: dan tags: trunk)
08:41
Add text to fts3.html describing the snippet and offsets functions. (check-in: d91a4c7249 user: dan tags: trunk)
2009-11-28
19:17
Add a description of tokenizers to fts3.in. (check-in: f1940858bf user: dan tags: trunk)
13:11
Set the target release date for 3.6.21 to 2009-12-05 (check-in: 8aa1114bbb user: drh tags: trunk)
2009-11-27
17:03
Change things so that fts3.html and foreignkeys.html do not use an external stylesheet. (check-in: 6a28d79533 user: dan tags: trunk)
2009-11-26
18:43
Expand on the description of fts3 query syntax in fts3.in. (check-in: 3031615e43 user: dan tags: trunk)
2009-11-25
18:44
Describe fts3 query syntax. (check-in: 6f60a71678 user: dan tags: trunk)
2009-11-24
18:45
Add some text to fts3.html. (check-in: 8d529e9fc1 user: dan tags: trunk)
2009-11-23
13:57
Begin making changes in preparation for 3.6.21. (check-in: 442afaf708 user: drh tags: trunk)
03:59
Add instructions for building an FTS3-enabled SQLite to fts3.html. (check-in: cf42334a68 user: dan tags: trunk)
2009-11-20
10:19
Clarify the documentation for ATTACH to note that it is not possible to attach the same database file twice while in shared-cache mode. (check-in: 6800ae21eb user: dan tags: trunk)
2009-11-17
19:06
Improvements to the description of data structures in fts3.html. (check-in: 146d003fc9 user: dan tags: trunk)
2009-11-15
03:59
Add start of html fts3 documentation. This is very much a work in progress. (check-in: 8c18d00b27 user: dan tags: trunk)
2009-11-14
17:00
Be sure to mention that PRAGMA foreign_keys is a no-op within a transaction. (check-in: a802dbe3fb user: drh tags: trunk)
15:21
Updates to the well-known-users page - added dropbox.com. Removed monotone and philips. (check-in: 419c5f2b1e user: drh tags: trunk)
2009-11-12
05:15
Updated description for substr(). (check-in: 2f8e06326a user: shaneh tags: trunk)
2009-11-10
00:27
Add the "How To Compile" document. Other minor document tweaks. (check-in: d5ea021abc user: drh tags: trunk)
2009-11-09
12:55
Added the Nishizawa book. Other editorial changes. (check-in: 8461a7c4c7 user: drh tags: trunk)
2009-11-06
15:17
Add the Tcl/Tk and SQLite harmony image. (check-in: 5f5c569162 user: drh tags: trunk)
2009-11-05
12:20
Fix a typo in the CREATE TABLE documentation. (check-in: 0c09e6614f user: drh tags: trunk)
2009-11-04
18:20
Corresponding to SQLite version 3.6.20. (check-in: 6d4f425724 user: drh tags: trunk, release)
14:41
Redate the 3.6.20 release to 2009-11-04 (check-in: 40a9b14a4b user: drh tags: trunk)
00:00
Fix a typo in the mostdeployed.html page. (check-in: e49bf5a116 user: drh tags: trunk)
2009-11-02
16:54
Documentation index tweaks. (check-in: 08c403b6b0 user: drh tags: trunk)
16:02
Tweaks to the documentation index presentation. (check-in: 13846fadf4 user: drh tags: trunk)
15:50
Added the website keyword index. (check-in: ec4a51db99 user: drh tags: trunk)