Documentation Source Text

Timeline
Login

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

50 descendants and 50 ancestors of [c6e5d60723]

2014-03-08
03:21
Add a news blurb for the 3.8.4 release. check-in: 02c3db4e28 user: drh tags: trunk
2014-03-06
02:12
Update the index page and change log in anticipation for 3.8.4. check-in: 2c81b82587 user: drh tags: trunk
2014-02-28
12:26
Minor clarifications of recent documentation. check-in: e139253c4b user: drh tags: trunk
2014-02-22
13:55
Clarification of what it means for the expression in a DEFAULT clause to be constant. check-in: 0b36750358 user: drh tags: trunk
2014-02-21
13:21
Update the all-bnf.html file. check-in: 424fd15707 user: drh tags: trunk
2014-02-20
16:09
Make sure bubble diagrams are all shown in the right places. check-in: a67364e06f user: drh tags: trunk
2014-02-12
19:36
Fix a mistake in the date/time function documentation. check-in: 5cb71ea877 user: drh tags: trunk
2014-02-11
16:36
Add SOURCE_ID and SHA1 hash for the 3.8.3.1 release. check-in: d882698e7b user: drh tags: trunk
14:30
Updates for the 3.8.3.1 release. check-in: f2ce0c9b8e user: drh tags: trunk
2014-02-10
17:49
Fix a typo in the WITH documentation. check-in: 4cd3bb5ab2 user: drh tags: trunk
2014-02-06
16:52
Further clarification on the difference between recursive and ordinary CTEs. check-in: ecdd0d43d0 user: drh tags: trunk
13:25
Fix an example code error in the WITH documentation. check-in: a6ce882b01 user: drh tags: trunk
2014-02-05
00:16
Fix a hyperlink in the SELECT documentation. check-in: 1c86b01b95 user: drh tags: trunk
2014-02-03
14:00
Add the sha1sum and SQLITE_SOURCE_ID for version 3.8.3 to the changelog. check-in: c161234538 user: dan tags: trunk
2014-02-02
22:43
Enhancements to the bubble diagram generator. Leaf check-in: 4dc85d1094 user: drh tags: bubble-diagrams
2014-01-30
20:55
Fix an error in the table-or-subquery syntax diagram. check-in: a467d7a4b8 user: drh tags: trunk
20:51
Add the "factored-select-stmt" syntax diagram. Improve the way diagrams are hidden and shown. check-in: fac98d12ae user: drh tags: trunk
19:39
Make the "select-stmt" syntax diagram a closer fit to reality. check-in: 0c43e7efb4 user: drh tags: trunk
17:41
Fix FROM clause in the SELECT syntax diagrams. Also fix typos in the text. check-in: a115a033da user: drh tags: trunk
15:56
Update the mmap documentation to describe the problem of Windows not truncating memory mapped files. check-in: fa77748670 user: drh tags: trunk
15:32
Additional clarification on syntax restrictions in SELECT statements. check-in: 4c5d78209a user: drh tags: trunk
15:03
Further enhancements to the SELECT documentation. check-in: 979599b0b6 user: drh tags: trunk
14:11
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. check-in: c14dc7c23b user: drh tags: trunk
11:15
Additional hyperlinks to "compound SELECT", "ORDER BY" and "LIMIT". check-in: 1c8ccd6d21 user: drh tags: trunk
11:08
Clarification of the role of ORDER BY and LIMIT in compound SELECT statements. check-in: 7b8d43a8ef user: drh tags: trunk
2014-01-29
17:47
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. check-in: ea6e1d11de user: drh tags: trunk
17:10
Add new elements to the 3.8.3 change log. check-in: 7ab25ac60e user: drh tags: trunk
13:52
Typo fix. CAST(...TO...) should be CAST(...AS...). check-in: 64427669a7 user: drh tags: trunk
2014-01-24
23:43
Fix typos in the WITH clause documentation reported on the mailing list. check-in: 5415be54c0 user: drh tags: trunk
13:20
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. check-in: fb11eda20b user: drh tags: trunk
04:05
Further refinement and cleanup of the WITH and SELECT documentation. check-in: 2941cf658c user: drh tags: trunk
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
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