Documentation Source Text

Timeline
Login

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

50 descendants and 50 ancestors of 8efac9af2bbff420472bd34c490b0ea61098eb80

2010-11-18
16:21
Update the documentation to be explicit that a parent key must not be a rowid. (check-in: d1edb27943 user: drh tags: trunk)
01:11
Another minor change to the EQP documentation. (check-in: 1aff231013 user: drh tags: trunk)
2010-11-17
22:30
Tweak to the text of the EQP documentation. (check-in: 5f2171a4cb user: drh tags: trunk)
01:32
Add the sqlite3_stmt_readonly() function to the change log. (check-in: c591c1b79d user: drh tags: trunk)
2010-11-15
18:43
Add additional requirements marks and reword a few sentences in eqp.html. (check-in: 09966391b1 user: drh tags: trunk)
17:35
Minor fixes for sample code in eqp.in. (check-in: 897bd4f88e user: dan tags: trunk)
14:32
Add the Airbus logo to the "famous.html" page. Update the changes for 3.7.4. (check-in: c0a45dd7fa user: drh tags: trunk)
13:15
Fix a typo from the fts3.html document. (check-in: c547f4b6c1 user: drh tags: trunk)
2010-11-13
19:00
Move the examples on lang_explain.html to new document eqp.html. (check-in: 0c8678b577 user: dan tags: trunk)
17:10
Update EXPLAIN QUERY PLAN examples to match changes to sqlite. (check-in: 3f8c0a0c1f user: dan tags: trunk)
2010-11-12
17:40
Add evidence marks to examples on lang_explain.html. (check-in: 360fe45245 user: dan tags: trunk)
2010-11-11
17:47
Add extra documentation for EXPLAIN QUERY PLAN. (check-in: 759dfb93a1 user: dan tags: trunk)
2010-11-10
18:43
Add some more documentation for EXPLAIN QUERY PLAN. (check-in: 37f6e9f261 user: dan tags: trunk)
2010-11-03
01:22
Updates to PRAGMA locking_mode and WAL documentation. (check-in: 8ff1145035 user: drh tags: trunk)
2010-11-02
14:46
Documentation of the WAL in EXCLUSIVE locking-mode changes. (check-in: 0aa0be4de5 user: drh tags: trunk)
2010-10-14
17:27
Fix the join-op syntax diagram so that it allows LEFT JOIN in addition to LEFT OUTER JOIN. (check-in: 1a0decefd2 user: drh tags: trunk)
2010-10-08
16:09
Changes to lang_createtable.html. (check-in: dcfeca529f user: dan tags: trunk)
02:37
Changes to the website for version 3.7.3. (check-in: c800d719f4 user: drh tags: trunk)
2010-10-06
13:47
Updates to the file format documentation. (check-in: 8f5cfd48d2 user: drh tags: trunk)
12:23
Update the change documentation for the 3.7.3 release. Fixes to the description of the index_info pragma. (check-in: d009514359 user: drh tags: trunk)
2010-10-01
19:03
Clarify that if a CHECK expression evaluates to NULL, it is not a constraint violation. (check-in: 217545f050 user: dan tags: trunk)
2010-09-30
18:23
Fix a typo on lang_createtable.html. (check-in: 2d50d47170 user: dan tags: trunk)
16:31
Add missing image: numeric-literal.gif. (check-in: d1c65c4e95 user: drh tags: trunk)
16:15
Added a syntax diagram for numeric literals, especially floating point literals. (check-in: 598ff451ef user: drh tags: trunk)
2010-09-29
18:22
Fix a problem with the definition of the DEFAULT clause on lang_conflict.html. (check-in: 73b4c1e498 user: dan tags: trunk)
11:10
Change "'CREATE TABLE AS' statements" to "'CREATE TABLE ... AS SELECT ...' statements" on lang_createtable.html. (check-in: 4534ea5789 user: dan tags: trunk)
04:20
Fix documentation typos in testing.html and in fileformat2.html. (check-in: ac93c65159 user: drh tags: trunk)
01:38
Various documentation typo fixes and updates. (check-in: 161f14d929 user: drh tags: trunk)
2010-09-28
17:38
Changes to the CREATE TABLE documentation. (check-in: 2092d92251 user: dan tags: trunk)
2010-09-24
19:00
Update the REINDEX syntax diagram to allow for no arguments. (check-in: f55ccb05aa user: drh tags: trunk)
18:59
Document the effect of the "REINDEX;" statement. (check-in: 6405a81c7b user: dan tags: trunk)
17:58
Fixes and testability improvements to lang_vacuum.html. (check-in: 91efaa0fc0 user: dan tags: trunk)
07:59
Add a definition for interpreting the result of an expression as a boolean value (e.g. for WHERE or HAVING clauses) to lang_expr.html. Link to this from lang_update.html, lang_delete.html and lang_select.html instead of repeating the definition on each page. (check-in: 36c1765653 user: dan tags: trunk)
2010-09-23
18:46
Changes to lang_update.html. (check-in: 32506c4e82 user: dan tags: trunk)
2010-09-21
16:58
Further changes to lang_update.html. (check-in: e7259b8c39 user: dan tags: trunk)
2010-09-20
19:09
Changes to lang_update.html to make it more testable. (check-in: 5df6adc2a9 user: dan tags: trunk)
2010-09-18
18:52
Tweaks to lang_insert.html. (check-in: 15cc2204a5 user: dan tags: trunk)
15:03
Remove the tags from a couple of untestable statements in lang_select.html. (check-in: 0df9f2d381 user: dan tags: trunk)
2010-09-17
19:52
Update the syntax diagram GIF files. (check-in: 2adf0c0cca user: drh tags: trunk)
17:08
Modify syntax diagrams to show that LIMIT and OFFSET clauses are now expressions, not constant integers. And to make it clear that "OUTER" and "NATURAL OUTER" joins are not supported. (check-in: 5db62da333 user: dan tags: trunk)
00:50
Add coverage percentages to the bottom of the requirements matrix. (check-in: 0f0f4c2b6f user: drh tags: trunk)
2010-09-16
18:50
Change the documentation for LIMIT and OFFSET clauses to be more testable. (check-in: 1cb27a268e user: dan tags: trunk)
2010-09-15
22:17
Updates to the documentation for the new sqlite3_soft_heap_limit64() interface. (check-in: 5d170249d2 user: drh tags: trunk)
18:54
Changes to make the documentation for ORDER BY more testable. (check-in: 095cad2463 user: dan tags: trunk)
2010-09-14
19:10
Adding additional comparison operators to the list in datatype3.html. (check-in: a43ee1e871 user: drh tags: trunk)
18:57
Fix a recently introduced error regarding collation sequences and compounds SELECT statements. (check-in: 8d9fe20890 user: dan tags: trunk)
13:25
Add <> to the list of comparison operators in datatype3.html. (check-in: 838bd2b455 user: drh tags: trunk)
2010-09-13
18:56
Changes to SELECT documentation related to compound SELECT operators. (check-in: 182ba19363 user: dan tags: trunk)
12:06
Added documentation on the SQLITE_4_BYTE_ALIGNED_MALLOC compile-time option. (check-in: dc93bef322 user: drh tags: trunk)
2010-09-11
17:46
Change to requirement marks in lang.in. (check-in: b5882b3f8f user: dan tags: trunk)
2010-09-10
19:11
Minor changes to lang.in. (check-in: 8efac9af2b user: dan tags: trunk)
2010-09-09
19:08
Bug in "fossil rename" prevented the removal of fileformat.in from working. This checkin deletes it, which we know works. (check-in: 95550b75ee user: drh tags: trunk)
18:48
Change some testable statement formatting marks in lang.in. (check-in: a4b6b57093 user: dan tags: trunk)
12:31
Disable the older fileformat document. This makes documentation builds run much faster. Also fix some typos. (check-in: 7cab8e90e4 user: drh tags: trunk)
11:32
Combine two requirements into one in lang_select.html. (check-in: 85d1540336 user: dan tags: trunk)
09:51
Fix a broken link in lang_select.html. (check-in: 53081e3979 user: dan tags: trunk)
2010-09-08
19:01
Clarifications to lang_select.html (check-in: 49e2c0eae6 user: dan tags: trunk)
2010-09-07
14:58
Added link to the Belorussion translation of the FAQ. Added links from parameter binding to SQLITE_LIMIT_VARIABLE_NUMBER. Added section to the "How SQLite Is Tested" document describing disabled optimization tests. (check-in: 71ae536af0 user: drh tags: trunk)
2010-09-06
19:12
Fix some mistakes in lang_select.html. (check-in: 55e829f468 user: dan tags: trunk)
2010-09-04
18:36
Fix a couple of errors in the recent changes to lang_select.html. (check-in: b47f9e77a6 user: dan tags: trunk)
2010-09-03
19:07
Changes to lang_select.html to make it more testable. (check-in: 2441ba87c8 user: dan tags: trunk)
2010-09-02
23:37
Tweaks to the formatting of the requirements traceability matrix. (check-in: e4a472e7f6 user: drh tags: trunk)
19:21
Reword some testable statements related to scalar subqueries in lang_expr.html. (check-in: 573431382a user: dan tags: trunk)
11:52
Add section to lang_expr.html for the EXISTS operator. (check-in: c8e9d99b1d user: dan tags: trunk)
04:20
More typo fixes. (check-in: db66d3a1d4 user: shaneh tags: trunk)
04:20
Add a couple of other typo checking heuristics. (check-in: effb349be5 user: shaneh tags: trunk)
2010-09-01
11:49
New hyperlinks to FTS and RTree. New requirement that automatically generated rowids must be positive. (check-in: ddcf89bab0 user: drh tags: trunk)
2010-08-31
16:49
Fix typo in fts3.html pointed out on the mailing list. (check-in: 8873618014 user: dan tags: trunk)
16:14
Add a fragment for the custom r-tree query section of the r-tree docs. Add the addition of custom r-tree query to the "changes" page. (check-in: c96a663926 user: drh tags: trunk)
15:53
Expand the description of the large-transaction limitatioo for WAL mode. Identify additional requirements in the second file format document. (check-in: 400de5a3af user: drh tags: trunk)
15:03
Add a link to example geometry callback code to rtree.in. (check-in: ed402895f8 user: dan tags: trunk)
11:01
Add documentation for custom r-tree geometry callbacks to rtree.in (check-in: 7e421e2c51 user: dan tags: trunk)
2010-08-30
15:10
More typo and spelling fixes. (check-in: d7a2085524 user: shaneh tags: trunk)
15:09
More updates to custom word list. (check-in: 2bbdfeeb37 user: shaneh tags: trunk)
15:09
Simplified interface to aspell. (check-in: d06b98415b user: shaneh tags: trunk)
13:36
Fix more spelling mistakes and typos. Additional changes for consistency in word usage. (check-in: 9425bd7118 user: shaneh tags: trunk)
13:33
Updated custom word list. (check-in: 46ad923cc2 user: shaneh tags: trunk)
13:32
Pass location of custom word list to spell_chk.sh as an arg. (check-in: a75f0b1a75 user: shaneh tags: trunk)
00:42
Copy the spell-check exception list into the buid directory. Add "SQLite" to the spell-check exception list. (check-in: 99a59a73ff user: drh tags: trunk)
00:13
Updates to the queryplanner.html document. (check-in: 33d6d684cb user: drh tags: trunk)
2010-08-28
05:48
Fix documentation typos. (check-in: 78fe166463 user: shaneh tags: trunk)
05:33
Tweaks to the custom dictionary used for spell checking. (check-in: b5e80cf302 user: shaneh tags: trunk)
2010-08-27
21:09
Add spell check for generated docs using aspell (make spell). (check-in: 047dfe3550 user: shaneh tags: trunk)
11:20
Minor fixes to CAST documentation. (check-in: 302d0bb876 user: dan tags: trunk)
2010-08-26
19:07
Changes to CAST expression documentation to make for more testable statements. (check-in: 6c20f79cbc user: dan tags: trunk)
2010-08-24
13:11
Modifications to documentation for CASE expressions. (check-in: 6c47d70dc0 user: dan tags: trunk)
2010-08-23
22:51
Preparation for the 3.7.2 release. (check-in: 7bf266483d user: drh tags: trunk)
2010-08-21
19:11
Preparations for the 3.7.1 release. (check-in: fb2b8b097b user: drh tags: trunk)
2010-08-14
12:25
Break a big testable statement in lang_expr.html into several smaller blocks. (check-in: 61d45eaf94 user: dan tags: trunk)
2010-08-13
17:44
Enhancements to the description of how the COLLATE operator works. (check-in: 17093bc7d6 user: drh tags: trunk)
2010-08-12
17:55
Initial identification of requirements in the fileformat2.html document. (check-in: 8925c8c2e1 user: drh tags: trunk)
16:26
Work on the queryplanner.html document. (check-in: e8152063fb user: drh tags: trunk)
14:38
Update the file format documentation for the new 64K page size. Add a caution to the WAL document. Omit annoying echos in the script that removes requirement marks from the documentation. (check-in: 0ec9f2cb8f user: drh tags: trunk)
2010-08-10
05:58
Fix typos reported on the mailing list. (check-in: a85aaa0b62 user: drh tags: trunk)
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. (check-in: d9e242f92a user: drh tags: trunk)
14:30
Fix a typo in the datatype3.html document. (check-in: 9fec2f9dda user: drh tags: trunk)
2010-08-06
17:49
First draft of the queryplanner.html document. (check-in: 1da52815fa user: drh tags: trunk)
2010-08-04
12:03
Fix a broken hyperlink from lang_conflict.html to foreignkeys.html. (check-in: 5b960cc498 user: drh tags: trunk)
2010-08-03
13:14
ON CONFLICT does in fact work with CHECK constraints. Fix the documentation to show this. The docs used to be right, but were broken by the prior check-in. (check-in: 5395a69f2f user: drh tags: trunk)
02:26
Updates to language documentation. (check-in: c412626afe user: drh tags: trunk)
2010-08-02
18:03
Updates to documentation for ATTACH. (check-in: 213b37eef1 user: drh tags: trunk)