Documentation Source Text

Timeline
Login

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

27 descendants and 50 ancestors of [e167521765]

2019-10-16
18:07
Fix typos in the lemon documentation. Leaf check-in: 85bc3983a5 user: drh tags: trunk
2019-10-14
00:26
Further clarification of automatic affinity conversion rules. check-in: 3a3335a61e user: drh tags: trunk
00:20
Clarification of the automatic conversion rules for inserting TEXT into a NUMERIC column. check-in: 9840457b31 user: drh tags: trunk
2019-10-11
03:26
Version 3.30.1 check-in: bb0f52c956 user: drh tags: trunk
2019-10-10
17:35
Preparing for the 3.30.1 patch release. check-in: d161e25a2e user: drh tags: trunk
2019-10-06
15:33
Update the speed-and-size spreadsheet with 3.30.0 data. check-in: 7a74244235 user: drh tags: trunk
2019-10-04
15:08
Update chronology.in and changes.in with the correct release hashes. check-in: 1433012434 user: drh tags: trunk
14:58
Add a News entry for 3.30.0. Set the release date. check-in: 0cbc8d6315 user: drh tags: trunk
2019-10-02
12:39
Fix the history hyperlinks on the checklist app. check-in: 5cb74ba705 user: drh tags: trunk
11:41
Merge branch-3.29 enhancements into trunk, and in particular the hd_adunit change. check-in: caa36aeea0 user: drh tags: trunk
11:36
Add the ability to put an ad unit at the top of the index page and the download page. If the file "adunit.txt" exists in the build directory, then the content of that file is copied into the appropriate spot on those two pages. Leaf check-in: ea232463fc user: drh tags: branch-3.29
10:40
Typos and minor enhancements to the althttpd.md document. check-in: 5140eb346c user: drh tags: trunk
2019-09-28
19:02
Typo fixes. check-in: 7a37431be5 user: drh tags: trunk
2019-09-27
17:55
Updates so that documentation agrees with requirement marks. check-in: f1a1831162 user: drh tags: trunk
11:30
Merge fixes from the 3.20 branch. check-in: de8b5d698b user: drh tags: trunk
11:30
Type fixes check-in: 003eb4df17 user: drh tags: trunk
2019-09-26
19:34
Update the RBU documentation to remove the constraint about it not working with indexes on expressions. check-in: e7771db6cc user: drh tags: trunk
19:24
More documentation on how PRAGMA index_info and PRAGMA index_xinfo handle indexes on expressions. check-in: d9d337b927 user: drh tags: trunk
19:02
Fix introspection pragma documentation to show that they are now on by default. Add documentation for the TCL Interface config method. check-in: a94ea31acb user: drh tags: trunk
15:24
Adjustments to the document indexes. check-in: ede6ba1df3 user: drh tags: trunk
2019-09-24
10:30
Use single-quoted strings in the documention for PRAGMA encoding. check-in: 4c6aa056b7 user: drh tags: branch-3.29
2019-09-20
17:37
Fix a minor typo in the transaction documentation. check-in: 83b8745219 user: drh tags: branch-3.29
2019-09-16
14:49
Add SQLITE_DIRECTONLY to the change log and documentation. Fix a typo in changes to the index_info pragma. check-in: 518f7b3bdd user: drh tags: trunk
14:09
Remove documentation fixes from the release branch. check-in: b10a80aacd user: drh tags: trunk
2019-09-13
17:55
Fix a bug in the documentation generator for PRAGMAs. check-in: d83262cc8b user: drh tags: branch-3.29
2019-08-15
16:03
More precise description of when SQLITE_MASTER can be updated in the FAQ. check-in: 5a6c1fea3c user: drh tags: branch-3.29
2019-08-12
11:54
Trying to improve the documentation on transactions. check-in: ead5e472f0 user: drh tags: branch-3.29
2019-08-06
17:02
Improved documentation on how EXPLAIN only affects run-time but some PRAGMA statements operate at prepare-time and are thus unaffected by EXPLAIN. check-in: e167521765 user: drh tags: branch-3.29
2019-08-05
20:39
Back out the previous change. We are instead going to modify the code to match the documentation. check-in: 3578d6c47b user: drh tags: branch-3.29
12:55
Update the documentation on the affinity of the columns of VIEWs and subqueries that are generated from expressions to match the actual implementation of 10 years standing - namely such columns have BLOB affinity, not no affinity. Ticket https://www.sqlite.org/src/info/d52a29a9e6bc55c5 check-in: 16a418966a user: drh tags: branch-3.29
2019-07-16
13:44
Updates to the testing document. check-in: 0d69a8d268 user: drh tags: branch-3.29
2019-07-15
17:48
Minor typos fixes in the lemon documentation. check-in: bd1181fb39 user: drh tags: trunk
17:17
Fix a missing space in the selfcontained.html webpage. check-in: 127e0a0347 user: drh tags: trunk
2019-07-13
16:24
Remove obsolete and unsupported BNF and TEXT representations of the grammar. check-in: b02f76d76f user: drh tags: trunk
2019-07-11
16:31
More typo fixes in quirks.html check-in: f6681985cd user: drh tags: trunk
16:01
Fix typos in the quirks document. check-in: 596c4951a0 user: drh tags: trunk
14:15
Add the "quirks.html" document to the list of overview documents in the documentation summary. check-in: 085c470f26 user: drh tags: trunk
13:28
Add another example of using a stale file descriptor to the howtocorrupt page. check-in: 8a4435f7ae user: drh tags: trunk
2019-07-10
17:38
Version 3.29.0 check-in: 059d7ea707 user: drh tags: trunk, release, version-3.29.0
12:40
Update the speed-and-size spreadsheet. check-in: ab8568d80c user: drh tags: trunk
12:02
Add news for the 3.29.0 release. check-in: c3bd426c86 user: drh tags: trunk
11:45
Fix typos check-in: 7a5056a138 user: drh tags: trunk
2019-07-09
13:13
Minor tweaks to the change log and to the documentation for SQLITE_DQS. check-in: d3b763b6a7 user: drh tags: trunk
09:50
Merge documentation fixes from the 3.28 release. check-in: 02ab9d6bd3 user: drh tags: trunk
09:48
Fix documentation typo. Leaf check-in: ee5e3f5b43 user: drh tags: branch-3.28
2019-07-02
13:25
Fix to the 12-step procedure for generalized schema modifications. Additional text trying to describe why schema modifications are hard in SQLite. check-in: df84d97d7b user: drh tags: trunk
12:47
Add documentation for the SQLITE_DQS compile-time option. Adjust the documentation so that the default is now -DSQLITE_DQS=3. check-in: e2807b06c2 user: drh tags: trunk
2019-06-17
14:14
Add notes about the new sqlite3_db_config() interfaces. Enhanced discussion of the double-quoted string literal misfeature. check-in: ab87f9f72b user: drh tags: trunk
13:56
Track the revised DQS interface. Closed-Leaf check-in: 09cea3924b user: drh tags: new-dbconfig-options
2019-06-15
15:24
Documentation on the new SQLITE_DBCONFIG options. check-in: 4ebc1051c2 user: drh tags: new-dbconfig-options
2019-06-12
20:31
Fix the description of how collation is computed to indicate that the collation is not blocked by a CAST operator. Fix for ticket https://www.sqlite.org/src/info/b148fa61059fb6c2. check-in: 9f887f15e5 user: drh tags: trunk
10:55
Enhancements to the change log. check-in: 06b9f7898d user: drh tags: trunk
2019-06-11
15:54
Clarify the semantics of a CAST to NUMERIC. Ticket https://www.sqlite.org/src/tktview/afdc5a29dc check-in: 7a51b32537 user: drh tags: trunk
13:40
Clarify how mathematical operators function given string or blob operands. Ticket https://www.sqlite.org/src/tktview/1819598c09 check-in: e0f700bb6c user: drh tags: trunk
02:59
Augment the affinity rules to state that the affinity of a COLLATE operator is the same as the affinity of its left-hand side. Ticket https://www.sqlite.org/src/tktview/d60b3cd7cb check-in: 722f0828b3 user: drh tags: trunk
2019-05-23
19:37
Add a row for 3.29.0 to the speed-and-size chart. check-in: 7502249d01 user: drh tags: trunk
2019-05-21
11:14
IE11 does not understand a 308 redirect, so always use a 301 redirect instead. check-in: 91021e98e3 user: drh tags: trunk
02:48
Use the <!DOCTYPE html> header on all pages. check-in: b5aef4cfad user: drh tags: branch-3.28
2019-05-17
20:39
Enhance the PRAGMA journal_mode=OFF documentation to make it clear that ordinary SQL can corrupt the database file while in that mode. See ticket https://www.sqlite.org/src/info/f4ec250930342e0c check-in: 5f361950a7 user: drh tags: trunk
17:22
Fix a harmless compiler warning about the return value of freopen() in althttpd. check-in: 445195faaf user: drh tags: trunk
17:20
Some redirects are now permanent. check-in: dd8def223f user: drh tags: trunk
2019-05-10
11:38
Fix a typo in the documentation for ANALYZE. check-in: 0917d5f9d6 user: drh tags: branch-3.28
2019-05-08
17:26
Document the fact that using PRAGMA case_sensitive_like in a database that uses LIKE operators in the schema can lead to problems. check-in: bc4c1a7626 user: drh tags: trunk
16:53
Clarify the ON CONFLICT clause documentation to make clear that FK violations always work as ABORT or ROLLBACK, never FAIL, IGNORE, or REPLACE. check-in: 90a2cca5d0 user: drh tags: trunk
2019-05-02
19:03
Use freopen() rather than assigning to "stdin" in althttpd.c. check-in: 229fda6dfb user: drh tags: trunk
16:25
Attempt to clarify the scope of when UPSERT processing applies. check-in: aae75b6ac2 user: drh tags: branch-3.28
2019-04-30
20:37
More "whynotgit.html" updates. check-in: 71cccf3d65 user: drh tags: branch-3.28
20:15
Further enhancements to the whynotgit.html page. check-in: 763fc99770 user: drh tags: branch-3.28
2019-04-29
19:27
Further clarification to the assert.html document. check-in: ef3822f76d user: drh tags: branch-3.28
18:45
Add documentation for the ".recover" command to the shell tool page. check-in: 51202caa59 user: dan tags: trunk
16:21
Merge changes from the 3.28 branch. check-in: d220b2f30c user: drh tags: trunk
15:46
Soften the criticism of Go because of their decision to omit assert() from the language. check-in: 4a40995c05 user: drh tags: branch-3.28
13:51
Update the file-format document to indicate that de-duplication of index columns in WITHOUT ROWID tables does not occur if the columns have different collating sequences. check-in: 3047c99f8a user: drh tags: trunk
2019-04-28
00:46
Fix althttpd.c so that it builds on non-linux machines. check-in: 02b0d4d406 user: drh tags: trunk
2019-04-27
21:01
Start a change log for version 3.29.0. check-in: 4e1bc9c5f0 user: drh tags: trunk
18:42
Updates to the althttpd.md documentation. check-in: 7dcc5545d1 user: drh tags: trunk
11:27
Fix a typo in althttpd.c - restore the behavior of index.cgi. check-in: 8cda91e897 user: drh tags: trunk
2019-04-24
19:28
The attack that the previous check-in sought to mitigate has stopped. So comment-out the change of the previous check-in. check-in: 4e3b689944 user: drh tags: trunk