Documentation Source Text

Timeline
Login

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

50 descendants and 50 ancestors of [02c3db4e28]

2014-05-26
15:38
Talk about partial index sorting in the queryplanner.html document. check-in: f81d69fb6a user: drh tags: trunk
13:58
Fix typos in the new ALTER TABLE documentation and in the queryplanner.html document. check-in: be73465c0f user: drh tags: trunk
13:10
Fix typos and clarify the text in the TH3 document. check-in: 8e68e11794 user: drh tags: trunk
13:00
Additional remarks on the use of checklists in the testing.html document. check-in: 8a2b7d834e user: drh tags: trunk
12:43
Better support for Windows in the howtocompile.html document. check-in: 55ab2074b0 user: drh tags: trunk
11:56
Updates to the ALTER TABLE documentation. Provide a clear warning that RENAME TO does not rewrite referencing triggers and views. Provide two correct procedures for making other kinds of schema changes. check-in: d4418abf42 user: drh tags: trunk
2014-05-25
22:11
Make sure fileformat.html stays in sync with fileformat2.html. check-in: df6145bd4e user: drh tags: trunk
22:00
Revisions to the arbitrary table schema change text in ALTER TABLE. check-in: b730943d19 user: drh tags: trunk
21:54
Add instructions for how to do arbitrary schema changes to the ALTER TABLE documentation. check-in: 227fb14d50 user: drh tags: trunk
20:11
Another accidental fork merge. check-in: b1b9dd90bb user: drh tags: trunk
20:08
Enhancements to the optoverview.html document: Added discussion of partial sorting and fixed the conditions for query flattening. check-in: fc0e9baa66 user: drh tags: trunk
2014-05-24
17:31
Merge accidental fork check-in: 0f2064446a user: drh tags: trunk
17:16
Further improvements to the opcodes.html documentation generator. check-in: 4f034b4e83 user: drh tags: trunk
17:01
Enhance the "opcodes.html" document to include hyperlinks from to the opcodes. check-in: 0d929c02e3 user: drh tags: trunk
16:20
Update the change log for 3.8.5. Fix a typo in the isolation.html document. check-in: ee616cbbb3 user: drh tags: trunk
2014-05-22
10:00
Fix a typo in FAQ item 14. check-in: 1b0ed95a32 user: dan tags: trunk
2014-05-19
20:00
Clarification in the text of the release notes for 3.8.5. check-in: c0ce61ad28 user: drh tags: trunk
19:55
Mention the automerge enhancement in the release notes. check-in: 5b3b975982 user: drh tags: trunk
2014-05-16
11:28
Update fts3.html for recent changes to FTS. check-in: ae994ce63a user: dan tags: trunk
2014-05-09
22:27
Fix typo in VALUES clause documentation in lang.html. check-in: fee01c2d5b user: drh tags: trunk
2014-05-07
16:00
Add notes on the SQLITE_IOCAP_IMMUTABLE and "nolock" and "immutable" query parameter changes. check-in: 7aa71cbb0c user: drh tags: trunk
2014-05-01
14:44
Updates to the R*Tree documentation. check-in: bd0fe1c3e1 user: drh tags: trunk
2014-04-29
15:08
Added documentation for the sqlite3_rtree_query_callback() enhancement. check-in: 89557fb903 user: drh tags: trunk
2014-04-26
00:30
Update althttpd.c client to log SIGPIPE and SIGSEGV in addition to SIGALRM. check-in: 5a80e1c8e7 user: drh tags: version-3.8.4.3
2014-04-25
20:47
Fix more typos in the foreignkey.html document. check-in: 25bc66990e user: drh tags: version-3.8.4.3
20:46
Fix more typos in the foreignkey.html document. check-in: 2de942054f user: drh tags: trunk
20:23
Fix a typo in the foreign key documentation. check-in: 821750714a user: drh tags: trunk
2014-04-22
01:19
Clarification of one of the 3.8.5 changes lines. check-in: 72fa86df8d user: drh tags: trunk
01:06
Update the version number to 3.8.5. Add a change log. check-in: aabef1a296 user: drh tags: trunk
00:32
Rename the "sqlite.html" page to "cli.html". Keep an "sqlite.html" page that redirects to "cli.html". check-in: a6ea023899 user: drh tags: trunk
2014-04-21
18:20
Update the command-line shell documentation with a discussion of CSV import and export. check-in: 070bfddab9 user: drh tags: trunk
13:12
Update the FAQ. check-in: eb122dda42 user: drh tags: trunk
2014-04-05
12:04
Fix a typo on the 3.8.4.3 news page. check-in: 7401266cf0 user: drh tags: trunk
2014-04-03
17:07
Version 3.8.4.3 check-in: 2482a30724 user: drh tags: trunk, release, version-3.8.4.3
2014-04-01
17:19
Tweaks and maintenance on the various documentation pages. Improvements to wording. Updated hyperlinks. check-in: c08c92bf98 user: drh tags: trunk
15:02
Strengthen the disclaimers on the "speed.html" page and on the "PRAGMA stats" documentation. check-in: 0bbad9c76b user: drh tags: trunk
13:44
Fixes to the application file format document. check-in: f3db82e049 user: drh tags: trunk
2014-03-26
18:53
Version 3.8.4.2 check-in: 2f86548772 user: drh tags: trunk, release, version-3.8.4.2
18:12
Add notes for the 3.8.4.2 patch release. check-in: 35bef59b0d user: drh tags: trunk
2014-03-17
18:30
Add a note about the use of checklists to the "testing.html" page. check-in: 835c236ee8 user: drh tags: trunk
18:05
Fix a hyperlink to the "application file format" page. check-in: 06eecd10f7 user: drh tags: trunk
2014-03-15
12:25
One more pass, with a few minor corrections, over the application file format document. check-in: 0dc508ed1b user: drh tags: trunk
2014-03-14
22:27
More edits to the application-file-format document. check-in: c0ac5630f2 user: drh tags: trunk
16:35
Further tuning of the application file format document. check-in: 1b422ce8de user: drh tags: trunk
2014-03-13
15:38
Improvements to the application file format document. check-in: 9e12f0cedd user: drh tags: trunk
00:43
First complete draft of the new application file format document. Integrate with the rest of the documentation via hyperlinks. check-in: 6d257b8d92 user: drh tags: trunk
2014-03-12
18:12
First draft of a document that advocates for using SQLite as an application file format. check-in: aa63d85794 user: drh tags: trunk
2014-03-11
15:30
Version 3.8.4.1 check-in: 103145ba79 user: drh tags: trunk, release, version-3.8.4.1
14:53
Update change log, index, and news for version 3.8.4.1 check-in: d1f96df9b2 user: drh tags: trunk
2014-03-10
12:23
The 3.8.4 release. check-in: 9ac72e3702 user: drh tags: trunk
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-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