Documentation Source Text

Timeline
Login

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

163 check-ins using file wrap.tcl version bc824ff386

2014-01-17
23:50
Update the syntax bubble diagrams to show that the WITH clause is allowed. check-in: 3f48c6857f user: drh tags: trunk
2014-01-15
03:02
Clarify some sentences in the documentation on ANALYZE. check-in: 5fc1073e06 user: drh tags: trunk
2013-12-17
16:33
Documentation for the printf() SQL function. check-in: 9cbe2e4d08 user: drh tags: trunk
2013-12-16
21:42
When the request URI for static content contains extra path elements, report the error as 404 instead of 301. check-in: 155df5701c user: drh tags: trunk
21:30
In althttpd, keep track of wall-clock time in milliseconds, not seconds. And for the user and system times, be sure to subtract out the user and system times for prior requests on the same connection. check-in: 333c090d36 user: drh tags: trunk
20:13
Add an extra column to the logfile output from althttpd. The 16th column gives the number of characters in the request URI that contribute to the script name. This is useful with substr() in doing queries against specific CGI scripts. check-in: faec8e5df4 user: drh tags: trunk
17:01
Improvements to the althttpd logic that redirects to the base document when there are surplus pathname elements in the request URI. check-in: 452b6e3c75 user: drh tags: trunk
14:39
When serving static content that has extra elements on the end of the URI, return a 301 to redirect to the base document, so that relative hyperlinks in the document will be correct. check-in: 1682f2225f user: drh tags: trunk
2013-12-14
14:42
Update the change log with SQLITE_DETERMINISTIC. check-in: 5bc4dbf151 user: drh tags: trunk
12:40
Add a change log for version 3.8.3. Fix a typo in the FAQ. check-in: 0aa5202f33 user: drh tags: trunk
2013-12-12
14:10
Fix missing "is" in the query planner document. check-in: 200941601a user: drh tags: trunk
13:23
Corrections to the spellfix1 documentation. check-in: aa19d1fdb5 user: drh tags: trunk
2013-12-06
15:50
Version 3.8.2 check-in: e795bba129 user: drh tags: trunk, release, version-3.8.2
14:57
Update the changelog with the source-id and sha1 sums for version 3.8.2. check-in: e22d41d36f user: dan tags: trunk
2013-12-02
21:45
Fix a typo in the News. check-in: c6e5d60723 user: drh tags: trunk
2013-11-27
19:20
Add a tentative news item for the 3.8.2 release. Updates to CAST documentation. Fix typos. check-in: 825b2c6448 user: drh tags: trunk
04:26
Update the skip-scan documentation to mention the magic 18 number for when skip-scan becomes profitable. check-in: 3eaa7f572e user: drh tags: trunk
01:26
Add documentation for the SQLITE_WIN32_HEAP compile-time option. Fix typos in the change log. check-in: 907e8cfb73 user: drh tags: trunk
2013-11-26
21:07
Change the documented behavior of casting a large real into an integer. check-in: f9d830d206 user: drh tags: trunk
17:47
Add the double-to-int casting change to the change log. Set the release date (tenatively) to 2013-12-10. check-in: 45cab1f685 user: drh tags: trunk
2013-11-25
13:23
Fix typo in malloc.html. check-in: bf0de31094 user: drh tags: trunk
2013-11-21
23:43
Update the change log to mention recent VDBE performance enhancements. check-in: 7113f9f169 user: drh tags: trunk
2013-11-19
00:20
Update the list of keywords to include COVERING, WITH, and WITHOUT. COVERING and WITH are currently unused. check-in: 74e28675d4 user: drh tags: trunk
2013-11-18
23:39
Updates to the "opcode.html" and "sqlite.html" documents. check-in: 45a6eaaaa7 user: drh tags: trunk
20:57
Correct minor typo. check-in: 9589b9982b user: mistachkin tags: trunk
18:48
Fix documentation typos pointed out on the mailing list by Philip Newton. check-in: b8e6ac4ce4 user: drh tags: trunk
2013-11-15
16:22
Fix a typo in the WITHOUT ROWID documentation. check-in: 5725d732c9 user: drh tags: trunk
2013-11-13
22:39
Update the change log to show the skip-scan optimization and other recent changes. Add documentation on skip-scan. check-in: 9b1dc53b75 user: drh tags: trunk
2013-11-11
23:27
Documentation updates associated with WITHOUT ROWID and the extension of the sqlite3_index_info object. check-in: 21034f356e user: drh tags: trunk
2013-11-09
17:27
Tweaks to WITHOUT ROWID documentation. check-in: 478a586d67 user: drh tags: trunk
17:17
Fix a broken fragment specification in the fileformat page. check-in: ea35f76f95 user: drh tags: trunk
17:14
Add the WITHOUT ROWID document. Enhance the file-format, CREATE TABLE, and AUTOINCREMENT documents to reflect changes due to WITHOUT ROWID. check-in: ffe4c464ea user: drh tags: trunk
2013-11-08
20:06
First attempt at documenting WITHOUT ROWID. check-in: 3819df0c0d user: drh tags: trunk
2013-10-27
03:44
Fix a typo in the documentation for the ABS() function. check-in: 9e1d78e903 user: drh tags: trunk
2013-10-19
16:21
Updates to documentation for recent changes, especially the unlikely() function and STAT4. Also fix some typos. check-in: 0998ee24a4 user: drh tags: trunk
15:21
Add documentation on the new SQLITE_USE_FCNTL_TRACE compile-time option. check-in: 67d47ef62f user: drh tags: trunk
15:17
Add discussion and cautions on the use of TEMP triggers on non-TEMP tables. check-in: 59201e1cfb user: drh tags: trunk
13:51
Merge the changes from the 3.8.0.x branch into trunk. check-in: 2faf39e6c4 user: drh tags: trunk
2013-10-17
13:52
Add the SQLITE_SOURCE_ID and sha1sum of sqlite3.c for 3.8.1 to changes.in. check-in: 7532f00f57 user: dan tags: trunk
12:54
Add news for the 3.8.1 release. Other final documentation tweaks prior to release. check-in: ca4b03a1f2 user: drh tags: trunk
2013-10-16
23:58
Fix typos in documentation. check-in: df95e4e1ec user: drh tags: trunk
2013-10-15
19:08
Added the fts4aux languageid column. Fix typos in famous.html check-in: cd0e9d17ed user: drh tags: trunk
2013-10-14
21:20
Move the tointeger() and toreal() functions into an extension. check-in: 6218782fda user: drh tags: trunk
19:36
Add documentation for toInteger() and toReal(). check-in: 782c63b8f0 user: drh tags: trunk
17:31
Add a mention of the SQLITE_TMPDIR environment variable in the change log. check-in: b5aece674f user: drh tags: trunk
13:15
Tweaks to the change log. Set an estimated release date for 3.8.1 of 2013-10-18. check-in: c00394dd14 user: drh tags: trunk
2013-10-12
20:43
Update the change log and the pragma documentation to reflect restoring PRAGMA index_list to its old behavior. check-in: d585c58e71 user: drh tags: trunk
13:10
Fix the PRAGMA defer_foreign_keys documentation to explain that deferral is disabled whenever a transaction completes. check-in: 651b3720a7 user: drh tags: trunk
2013-10-11
23:33
Improved documentation for DETACH - explain how behavior changes in shared cache mode. Update the makefile to scan the th3/core/*.c files for requirements marks. check-in: 949c314919 user: drh tags: trunk
20:16
Improve the text (rephrasing, not changing the meaning) of some requirements related to functions and pragmas. Improve or correct requirements marks. check-in: 77dee5dcd0 user: drh tags: trunk
14:18
Edits to the change log. check-in: c508b3c51a user: drh tags: trunk
2013-10-08
15:07
Revise the description of the Tcler's wiki database corruption event. check-in: 63ad7e56b1 user: drh tags: trunk
2013-10-07
08:27
Add documentation on the optional timezone suffixes to timestrings in the date and time functions. check-in: d4924d1139 user: drh tags: trunk
2013-10-04
17:27
Add new bullets to the change log for 3.8.1. check-in: dc132e270c user: drh tags: trunk
2013-10-02
13:34
Additional notes on how to corrupt an SQLite database file. check-in: 7c6ef04be8 user: drh tags: trunk
2013-10-01
01:01
Fix a typo on the release date for 3.8.0.2. Closed-Leaf check-in: 46516308c7 user: drh tags: branch-3.8.0
2013-09-30
12:14
Update the timeline link on the snapshot downloads so that it works if the previous release was on a branch. check-in: aa3aec51de user: drh tags: branch-3.8.0
12:10
Fix to the releaselog/current.html generator. check-in: e7d9c2101a user: drh tags: trunk
2013-09-19
14:30
Clarification of the meaning of the stat column in sqlite_stat1. check-in: 83b2bf0c4d user: drh tags: trunk
14:24
Leave unspecified what it means for the sqlite_stat3 and sqlite_stat4 tables to have idx columns equal to their tbl column. check-in: c538b41b91 user: drh tags: trunk
14:14
Fix typos and enhance the text of documentation for 3.8.1 changes. check-in: 1d0df412df user: drh tags: trunk
13:22
Updates to the TH3 description. check-in: ecd17d4f41 user: drh tags: trunk
2013-09-18
11:31
Add examples of creating fts3tokenize tables that use tokenizers declared with multiple arguments to fts3.in. check-in: 23c364befb user: dan tags: trunk
2013-09-16
13:32
Update the date and time function documentation to guarantee that 'now' is stable within a single sqlite3_step() call. check-in: a2842a55e9 user: drh tags: trunk
2013-09-14
16:09
Merge the 3.8.0 branch changes into trunk. check-in: 18c0f01b0c user: drh tags: trunk
2013-09-13
22:03
Add documentation for unlikely(), likelihood() and the soft_heap_limit pragma. check-in: dc4eae98aa user: drh tags: trunk
19:44
Add separate VSIX files for WinRT80 and WinRT81. Fix a typo on the home page. check-in: 474bc9f7f5 user: drh tags: branch-3.8.0
14:52
Add documentation for the fts4 unicode61 "tokenchars" and "separators" options. check-in: 00c7833d65 user: dan tags: trunk
2013-09-03
17:22
Add the sha1sum and SQLITE_SOURCE_ID for 3.8.0.2. check-in: 4069a1b264 user: dan tags: branch-3.8.0
17:20
Add documentation for the fts4 unicode61 tokenizer option "remove_diacritics=0". check-in: bc38355689 user: dan tags: branch-3.8.0
16:06
Changes for the 3.8.0.2 release. check-in: d705052eb2 user: drh tags: branch-3.8.0
2013-09-02
14:24
Merge change-log enhancements from the 3.8.0 branch into trunk. check-in: 265fde6eac user: drh tags: trunk
14:20
In the change log for patch releases, repeat the changes of the main release for the page containing changes of the just the patch release, but do not repeat the main release changes in the overall change log. check-in: affc1a3589 user: drh tags: branch-3.8.0
2013-08-31
14:32
Add documentation for the fts4 unicode61 tokenizer option "remove_diacritics=0". check-in: f5d1d7106f user: dan tags: trunk
2013-08-30
14:28
Added a 3.8.1 change log. Added documentation on SQLITE_MINIMUM_FILE_DESCRIPTOR. check-in: 4e286cee85 user: drh tags: trunk
14:03
Include all changes since 3.7.17 in the 3.8.0.1 change log. Typos fixed in the NGQP document. check-in: 3f23dd6ba9 user: drh tags: branch-3.8.0
2013-08-29
17:44
Add the source-id and sha1sum for 3.8.0.1 to changes.in. check-in: d22f4d2e9a user: dan tags: branch-3.8.0
16:51
If the user tries a download hyperlink without javascript, send them to an explanation page. check-in: 32aeca2648 user: drh tags: trunk
16:19
If the user tries a download hyperlink without javascript, send them to an explanation page. check-in: 80f0aef2d3 user: drh tags: branch-3.8.0
14:29
Preparations for the 3.8.0.1 patch release. check-in: 8d74017a56 user: drh tags: branch-3.8.0
2013-08-28
14:13
Add documentation for STAT4. check-in: 04ab4fa5ec user: drh tags: trunk
2013-08-27
13:34
Fix typos in the queryplanner-ng document. check-in: 9747293881 user: drh tags: trunk
2013-08-26
12:54
Version-3.8.0 check-in: e672a5f4d8 user: drh tags: trunk, release, version-3.8.0
12:20
Merge in the download pages updates that were made on the 3.7.17 branch. check-in: 71f4e91277 user: drh tags: trunk
10:07
Add the sha1 and source-id for 3.8.0 to changes.in. check-in: cb43f0154e user: dan tags: trunk
2013-08-25
23:48
Change the 3.8.0 release date to 2013-08-26. check-in: 105ed6eed2 user: drh tags: trunk
2013-08-23
16:37
Clarification and typo fixes in the NGQP document. check-in: a5a0ee107d user: drh tags: trunk
16:16
Fix documentation typos. check-in: ce2a4ec1e7 user: drh tags: trunk
01:57
Add documentation for the query_only and defer_foreign_keys pragmas. Update the change log for the 3.8.0 release. check-in: 8e16497ef1 user: drh tags: trunk
2013-08-22
20:28
Clearly label the source code snapshots on the download page as source code. Leaf check-in: 0e1cfbafc8 user: drh tags: 3.7.17
2013-08-20
17:06
Fix typos in the cache_spill pragma documentation. check-in: 4bfef7edb7 user: drh tags: trunk
03:06
Revised and amplified definition of the tointeger() and toreal() functions. Leaf check-in: 85757c1492 user: drh tags: toTypeFuncs
2013-08-19
21:17
Initial docs for tointeger() and toreal() SQL functions. check-in: 083cd58817 user: mistachkin tags: toTypeFuncs
14:26
Fix a typo in the RTREE documentation. check-in: 9ceaba9f7f user: drh tags: trunk
2013-08-17
17:56
Add documentation for the cache_spill pragma. check-in: 74740a2d9e user: drh tags: trunk
2013-08-08
17:58
Fix typos in the "vfs.html" document. check-in: 37c89b86f8 user: drh tags: trunk
02:54
Fix typos in the partial index document. check-in: 8bf9d71fd6 user: drh tags: trunk
2013-08-07
23:38
Add documentation for SQLITE_ALLOW_URI_AUTHORITY. check-in: cadb86b398 user: drh tags: trunk
15:39
Merge the changes from the 3.7.17 branch into trunk. check-in: 69c4153640 user: drh tags: trunk
15:02
Use javascript to delay setting href on anchors for deliverables on the download page. This is designed to prevent robots from downloading the deliverables. check-in: ea86d36c1c user: drh tags: 3.7.17
00:21
Clarifications and typo-fixes in the NGQP document. check-in: 5cbddcc945 user: drh tags: trunk
2013-08-03
18:42
Change pre-release snapshot descriptions to include links to change logs. check-in: e847b39547 user: drh tags: 3.7.17
18:42
Always publish the most recent changes in releaselog/current.html. check-in: 27f4c1dbbc user: drh tags: trunk
2013-08-02
23:41
Updates to requirements marks. check-in: 498cd0709e user: drh tags: trunk
18:27
Enable partial indices. check-in: f990657458 user: drh tags: trunk
18:27
Corrections to partial index documentation. Closed-Leaf check-in: 3e022afe53 user: drh tags: partial-indices
03:43
Add documentation on the partial index implementation. check-in: 5723efb011 user: drh tags: partial-indices
2013-08-01
18:23
Update syntax diagrams (on Mac OS 10.6.8 using Tk 8.5.7) for partial indices. check-in: 6f7d9ba15e user: drh tags: partial-indices
17:48
Fix the description of COLLATE operator precedence so that it is aligned with the implementation. check-in: 52366f9588 user: drh tags: trunk
2013-07-23
13:48
Merge the download page improvements that have been taking place over on the 3.7.17 branch. check-in: 0dc4a0b22a user: drh tags: trunk
13:45
Add a missing "not" to the text in the download page. check-in: 53bc857d09 user: drh tags: 3.7.17
2013-07-19
20:41
Further tweaks to the look of the Download page. check-in: c90897b38c user: drh tags: 3.7.17
20:22
Put a yellow background on the prerelease snapshots on the download page. check-in: c032a10b8b user: drh tags: 3.7.17
2013-07-17
15:39
Omit the newline from the default root name in standalone mode in althttpd. check-in: 6df9c92bc9 user: drh tags: trunk
00:17
Tweaks to the text describing the hazards of upgrading to the NGQP. check-in: 232b584bda user: drh tags: trunk
2013-07-16
22:15
Improvements to standalone mode in althttpd.c. check-in: a970d449c6 user: drh tags: trunk
2013-07-15
17:11
The log file for althttpd is now RFC-4180 CSV. Cherry-pick merge from check-in [52bfa21f48e14a29]. check-in: 93ba1a8d9d user: drh tags: trunk
17:10
Add the sqlite3_cancel_auto_extension() interface. check-in: 28716e6fd2 user: drh tags: trunk
11:17
The log file for althttpd is now RFC-4180 CSV. check-in: 52bfa21f48 user: drh tags: 3.7.17
2013-07-12
20:39
Fix typos in the isolation document. check-in: f64ef462b2 user: drh tags: trunk
20:03
Add the isolation.in document. Other changes for 3.8.0. check-in: 2eb277d7fc user: drh tags: trunk
2013-07-09
21:49
Fix typo in version number for sqlite_stat3. check-in: a583de40a1 user: mistachkin tags: trunk
2013-07-01
20:52
Fix a typo in an example in the fts4aux virtual table documentation. check-in: 6743aed594 user: drh tags: trunk
16:07
Lots of tweaking and enhancements to the documentation, especially regarding the query planner and ways of controlling the query planner. check-in: 641e107a66 user: drh tags: trunk
2013-06-26
19:13
Add the "Pre-release Snapshot" heading to the download page, with the ability to include winrt81 VSIX snapshots. check-in: a8228d3c37 user: drh tags: 3.7.17
14:35
Updates to the changes.html page. Fix typos on the NGQP documentation. check-in: e0c107dec3 user: drh tags: trunk
2013-06-25
16:31
Further improvement and expansion of the NGQP documentation, including adding a checklist for preventing and dealing with bad choices by the query planner. check-in: 828ca81aae user: drh tags: trunk
01:44
Second draft of the NGQP document. check-in: e09abae6c3 user: drh tags: trunk
2013-06-24
19:23
Work toward documenting the NGQP changes. check-in: e1646aea15 user: drh tags: trunk
2013-06-21
19:06
Add documentation for the fts4 notindexed option. check-in: 968222aa1c user: dan tags: trunk
08:00
Fix another minor typo in the vtable docs. check-in: a93d66e412 user: mistachkin tags: trunk
2013-05-29
06:57
Fix minor typo in the virtual table documentation for xCreate and xConnect. check-in: 44d1e198ca user: mistachkin tags: trunk
2013-05-28
13:23
Clarify the license for SQLite documentation. check-in: 419389e585 user: drh tags: trunk
2013-05-23
22:56
Fix a typo in mmap.html. check-in: 04448addda user: drh tags: trunk
11:48
Update the documentation for PRAGMA mmap_size to explain that it can sometimes be a no-op. check-in: a577a4e618 user: drh tags: trunk
2013-05-20
05:41
Add the sha1 hash and SQLITE_SOURCE_ID for 3071700 to changes.html. check-in: e87984f1c8 user: dan tags: trunk
2013-05-19
21:21
Tweaks to the "application file format" use case description. check-in: 89971860f6 user: drh tags: trunk
2013-05-18
17:45
Documentation updates for version 3.7.17. check-in: 67d025e82c user: drh tags: trunk
2013-05-15
18:58
Add recent bug fixes to the 3.7.17 change log. check-in: 2b8ea61f51 user: drh tags: trunk
2013-05-14
11:14
Fix another typo in queryplanner.in. check-in: d1d2571bce user: drh tags: trunk
11:12
Fix a typo in queryplanner.html. check-in: d52ed00775 user: drh tags: trunk
02:37
Improved hyperlinks on various documents. check-in: af7d790e13 user: drh tags: trunk
2013-05-08
18:04
Update the change log. check-in: f88ad9fa6a user: drh tags: trunk
2013-05-06
12:14
Fix a typo and clarify wording on the loadext.html page. check-in: f35f69d86e user: drh tags: trunk
2013-05-03
17:55
Typo correction and enhancement to the change log. check-in: a9cecdf9e8 user: drh tags: trunk
17:51
Still more edits to the application file format text. check-in: 6ef8771745 user: drh tags: trunk
17:42
Updates to the application-file-format text. check-in: 9811172daa user: drh tags: trunk
15:43
Add documentation for the Application ID. Add a proposed release date for 3.7.17. check-in: 0d800b73f2 user: drh tags: trunk
2013-05-01
11:51
Fix a broken hyperlink in the pragma.html page. check-in: 76230867ab user: drh tags: trunk
11:02
Fix typos in queryplanner-ng.html. check-in: c9e2b500a2 user: drh tags: trunk
00:14
Fix a typo in intern-v-extern-blob.html check-in: c8b280b8eb user: drh tags: trunk
2013-04-30
22:20
Updates to the next-generation-query-planner document. check-in: 28554e7596 user: drh tags: trunk
16:49
Add the Next Generation Query Planner document. check-in: 74fbc7b392 user: drh tags: trunk
11:51
Fix typos in the compile.html document. check-in: 32b04c8243 user: drh tags: trunk
2013-04-27
18:31
More documentation tweaks. Add two new entries to the "limits" page. check-in: 8da1a575d7 user: drh tags: trunk
12:01
Updates to documentation, especially the C API introduction. check-in: f0275a9b47 user: drh tags: trunk
2013-04-26
19:35
Update the change log for 3.7.17. Fix typos in the memory-mapped I/O documentation. check-in: c8b24bb8c6 user: drh tags: trunk
15:21
Update the change log for 3.7.17 after reviewing the timeline. check-in: 7e7024c429 user: drh tags: trunk
14:47
Fix typos and add clarification in the fts3tokenize documentation. check-in: aee1b746ba user: drh tags: trunk
14:38
Add documentation for the fts3tokenize table. check-in: a6e655aa62 user: drh tags: trunk
2013-04-25
11:35
Update the FTS3 documentation to make it clearer that external content tables must be in the same database as the FTS virtual table. check-in: 35441559aa user: drh tags: trunk
2013-04-24
22:09
If the website keyword search fails, try again after lowercasing the input text. This avoids problems when users enter "OR" and "NEAR" as search terms rather than operators. check-in: 78cbbe549b user: drh tags: trunk
2013-04-22
15:35
Ignore the error if two hyperlink keywords differ only in case. check-in: 55000f1b07 user: drh tags: trunk