Documentation Source Text

Timeline
Login

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

50 check-ins occurring around bf0de3109460d830.

2014-01-24
01:20
First cut at WITH documentation. (check-in: 2636279279 user: drh tags: trunk)
2014-01-23
22:25
Incremental checkin of work on the common-table-expression documentation. (check-in: 52484ca596 user: drh tags: trunk)
18:37
Refactoring many of the bubble syntax diagrams, especially related to SELECT. Attempting to make the bubble diagrams easier to follow. (check-in: 9aa1b8df9b user: drh tags: trunk)
15:29
Fix a link in the with-clause syntax diagram. (check-in: 3598251c1c user: drh tags: trunk)
15:25
Recursive syntax diagram display. (check-in: 87e7eb3d0d user: drh tags: trunk)
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)