Documentation Source Text
Timeline
Not logged in

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

50 most recent timeline items

2014-02-28
12:26
[e139253c4b] Leaf: Minor clarifications of recent documentation. (user: drh, tags: trunk)
2014-02-22
13:55
[0b36750358] Clarification of what it means for the expression in a DEFAULT clause to be constant. (user: drh, tags: trunk)
2014-02-21
13:21
[424fd15707] Update the all-bnf.html file. (user: drh, tags: trunk)
2014-02-20
16:09
[a67364e06f] Make sure bubble diagrams are all shown in the right places. (user: drh, tags: trunk)
2014-02-12
19:36
[5cb71ea877] Fix a mistake in the date/time function documentation. (user: drh, tags: trunk)
2014-02-11
16:36
[d882698e7b] Add SOURCE_ID and SHA1 hash for the 3.8.3.1 release. (user: drh, tags: trunk)
14:30
[f2ce0c9b8e] Updates for the 3.8.3.1 release. (user: drh, tags: trunk)
2014-02-10
17:49
[4cd3bb5ab2] Fix a typo in the WITH documentation. (user: drh, tags: trunk)
2014-02-06
16:52
[ecdd0d43d0] Further clarification on the difference between recursive and ordinary CTEs. (user: drh, tags: trunk)
13:25
[a6ce882b01] Fix an example code error in the WITH documentation. (user: drh, tags: trunk)
2014-02-05
00:16
[1c86b01b95] Fix a hyperlink in the SELECT documentation. (user: drh, tags: trunk)
2014-02-03
14:00
[c161234538] Add the sha1sum and SQLITE_SOURCE_ID for version 3.8.3 to the changelog. (user: dan, tags: trunk)
2014-02-02
22:43
[4dc85d1094] Leaf: Enhancements to the bubble diagram generator. (user: drh, tags: bubble-diagrams)
2014-01-30
20:55
[a467d7a4b8] Fix an error in the table-or-subquery syntax diagram. (user: drh, tags: trunk)
20:51
[fac98d12ae] Add the "factored-select-stmt" syntax diagram. Improve the way diagrams are hidden and shown. (user: drh, tags: trunk)
19:39
[0c43e7efb4] Make the "select-stmt" syntax diagram a closer fit to reality. (user: drh, tags: trunk)
17:41
[a115a033da] Fix FROM clause in the SELECT syntax diagrams. Also fix typos in the text. (user: drh, tags: trunk)
15:56
[fa77748670] Update the mmap documentation to describe the problem of Windows not truncating memory mapped files. (user: drh, tags: trunk)
15:32
[4c5d78209a] Additional clarification on syntax restrictions in SELECT statements. (user: drh, tags: trunk)
15:03
[979599b0b6] Further enhancements to the SELECT documentation. (user: drh, tags: trunk)
14:11
[c14dc7c23b] Add the extended-simple-select-stmt syntax diagram. Update the documentation on SELECT statements to better explain limitations on the use of ORDER BY and LIMIT in compound SELECTs. (user: drh, tags: trunk)
11:15
[1c8ccd6d21] Additional hyperlinks to "compound SELECT", "ORDER BY" and "LIMIT". (user: drh, tags: trunk)
11:08
[7b8d43a8ef] Clarification of the role of ORDER BY and LIMIT in compound SELECT statements. (user: drh, tags: trunk)
2014-01-29
17:47
[ea6e1d11de] Update News and the change log. Bring the release date forward to 2014-02-03. Fix typos. Move older news entries out to oldnews.in. (user: drh, tags: trunk)
17:10
[7ab25ac60e] Add new elements to the 3.8.3 change log. (user: drh, tags: trunk)
13:52
[64427669a7] Typo fix. CAST(...TO...) should be CAST(...AS...). (user: drh, tags: trunk)
2014-01-24
23:43
[5415be54c0] Fix typos in the WITH clause documentation reported on the mailing list. (user: drh, tags: trunk)
13:20
[fb11eda20b] Add examples to WITH documentation showing how to control depth-first versus breath-first search of a tree using an ORDER BY clause on the recursive query. (user: drh, tags: trunk)
04:05
[2941cf658c] Further refinement and cleanup of the WITH and SELECT documentation. (user: drh, tags: trunk)
01:20
[2636279279] First cut at WITH documentation. (user: drh, tags: trunk)
2014-01-23
22:25
[52484ca596] Incremental checkin of work on the common-table-expression documentation. (user: drh, tags: trunk)
18:37
[9aa1b8df9b] Refactoring many of the bubble syntax diagrams, especially related to SELECT. Attempting to make the bubble diagrams easier to follow. (user: drh, tags: trunk)
15:29
[3598251c1c] Fix a link in the with-clause syntax diagram. (user: drh, tags: trunk)
15:25
[87e7eb3d0d] Recursive syntax diagram display. (user: drh, tags: trunk)
2014-01-17
23:50
[3f48c6857f] Update the syntax bubble diagrams to show that the WITH clause is allowed. (user: drh, tags: trunk)
2014-01-15
03:02
[5fc1073e06] Clarify some sentences in the documentation on ANALYZE. (user: drh, tags: trunk)
2013-12-17
16:33
[9cbe2e4d08] Documentation for the printf() SQL function. (user: drh, tags: trunk)
2013-12-16
21:42
[155df5701c] When the request URI for static content contains extra path elements, report the error as 404 instead of 301. (user: drh, tags: trunk)
21:30
[333c090d36] 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. (user: drh, tags: trunk)
20:13
[faec8e5df4] 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. (user: drh, tags: trunk)
17:01
[452b6e3c75] Improvements to the althttpd logic that redirects to the base document when there are surplus pathname elements in the request URI. (user: drh, tags: trunk)
14:39
[1682f2225f] 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. (user: drh, tags: trunk)
2013-12-14
14:42
[5bc4dbf151] Update the change log with SQLITE_DETERMINISTIC. (user: drh, tags: trunk)
12:40
[0aa5202f33] Add a change log for version 3.8.3. Fix a typo in the FAQ. (user: drh, tags: trunk)
2013-12-12
14:10
[200941601a] Fix missing "is" in the query planner document. (user: drh, tags: trunk)
13:23
[aa19d1fdb5] Corrections to the spellfix1 documentation. (user: drh, tags: trunk)
2013-12-06
15:50
[e795bba129] Version 3.8.2 (user: drh, tags: trunk, release, version-3.8.2)
14:57
[e22d41d36f] Update the changelog with the source-id and sha1 sums for version 3.8.2. (user: dan, tags: trunk)
2013-12-02
21:45
[c6e5d60723] Fix a typo in the News. (user: drh, tags: trunk)
2013-11-27
19:20
[825b2c6448] Add a tentative news item for the 3.8.2 release. Updates to CAST documentation. Fix typos. (user: drh, tags: trunk)