Documentation Source Text

Timeline
Login

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

50 check-ins occurring around 71cccf3d65808549.

2019-07-09
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)
02:51
State that the COLLATE operator does not change affinity. (Leaf check-in: 5395fed295 user: drh tags: mistake)
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)
17:18
In althttpd.c, disallow a single particular user-agent string that is recently appearing in spider attacks. (check-in: 01c0f297c1 user: drh tags: trunk)
2019-04-19
23:40
Clarify the documentation on PRAGMA cache_size to explain that the cache size will go up or down in proportion to a change in page size. (check-in: 184e897473 user: drh tags: trunk)
2019-04-18
16:39
Althttpd now prefers /home over /index.html if it exists. (check-in: 87856f6c54 user: drh tags: trunk)
16:34
Change althttpd.c to search for /home after /index.html if not filename is given. (check-in: efdc1b8e66 user: drh tags: trunk)
2019-04-17
19:17
Remove unmatched close parenthesis from fileformat.html. (check-in: 41027bf4a9 user: dan tags: trunk)
15:17
Additional information about the SQLITE_IOERR_SHMSIZE error code. (check-in: 5c5e6f523a user: drh tags: trunk)
2019-04-16
19:52
Version 3.28.0 (check-in: 8084bf3aaf user: drh tags: trunk, release, version-3.28.0)
17:15
Fix typos. (check-in: 5bdcbe6918 user: drh tags: trunk)
17:08
Add a news entry for the 3.28.0 release. (check-in: 4136052d27 user: drh tags: trunk)
15:20
Updates to the change log. (check-in: 1309ba3c39 user: drh tags: trunk)
2019-04-15
22:32
Update the speed-and-size spreadsheet. (check-in: 3fc49bdac0 user: drh tags: trunk)
2019-04-13
15:45
Wording changes in defense-against-dark-arts. (check-in: adb3c10d3e user: drh tags: trunk)
15:33
Additional suggestions for defense against dark arts. (check-in: b41d1c753f user: drh tags: trunk)
2019-04-08
18:08
Fix a minor error in the datatype documentation. (Leaf check-in: 87bef3d123 user: drh tags: branch-3.27)