Documentation Source Text

Timeline
Login

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

44 descendants and 50 ancestors of [4a40995c05]

2019-07-17
13:02
Preliminary documentation for the enhancements to index_info and index_xinfo to support viewing the on-disk representation of WITHOUT ROWID tables. Leaf check-in: 296e23a4b8 user: drh tags: trunk
2019-07-16
13:44
Updates to the testing document. Leaf check-in: 0d69a8d268 user: drh tags: branch-3.29
2019-07-15
19:25
Update syntax diagrams to show the FILTER clause on aggregate functions. Start a change log for version 3.30.0. check-in: ba9800704d user: drh tags: trunk
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
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
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:06
Fix a minor error in the datatype documentation. check-in: a5590f5f81 user: drh tags: trunk
2019-04-05
21:18
Remove an obsolete reference to the addopcodes.tcl script. check-in: efe862885f user: drh tags: trunk
2019-04-04
19:07
Fix a typo. check-in: e6f195d6f4 user: drh tags: trunk
2019-04-02
13:26
Add the four new keywords: EXCLUDE GROUPS OTHERS TIES check-in: 8db10efb63 user: drh tags: trunk
01:06
Update the fts3_tokenizer() documentation to describe how it now wants parameters to be bound. check-in: 30e7de5540 user: drh tags: trunk
2019-04-01
14:45
Merge changes from the 3.27 branch. check-in: 50513b6f28 user: drh tags: trunk
14:44
Improvements to VACUUM documentation - describe more clearly when another transaction might block a vacuum. check-in: 0f897a0268 user: drh tags: branch-3.27
2019-03-29
16:41
Fix spelling error in the previous check-in. check-in: cfd3eb70b4 user: drh tags: trunk
16:40
Mention the ON parsing ambiguity of UPSERT on the UPSERT documentation page. check-in: c3bcaaf1e5 user: drh tags: trunk
2019-03-28
20:22
Remove the "expr FOLLOWING" case from frame-specs that only describe the starting boundary. check-in: 5eff6feebc user: drh tags: trunk
15:23
In the window-defn bubble diagram, change "existing-window-name" to "base-window-name" and make it an indentifier instead of a non-terminal. check-in: 67d1075ce3 user: drh tags: trunk
15:15
Improved railroad diagram for frame-spec. check-in: 6598d28114 user: drh tags: trunk
01:20
Minor tweak to the window function documentation. check-in: 7113d8b989 user: drh tags: trunk
00:46
Work on the window function documentation. check-in: 4b4ef30fa6 user: drh tags: trunk
2019-03-27
19:02
Fix problems in windowfunctions.in. check-in: dac96e63bd user: dan tags: trunk
2019-03-26
14:47
Update the changes long to show the enhancements to window functions. check-in: 1a7fda4c1f user: drh tags: trunk
13:11
Update window functions documentation. check-in: bdc2a67078 user: dan tags: trunk
00:14
Update to the ".parameter" command documentation to conform to the latest implementation. check-in: 9dab48bb9d user: drh tags: trunk
2019-03-25
20:56
Updates to the change log for 3.28.0. check-in: 32b82e8386 user: drh tags: trunk
20:49
Update documentation to match the proposed window function changes. Closed-Leaf check-in: 783032878d user: dan tags: window-functions
15:19
Update the CLI documentation to describe the new --insert option to ".archive" and the behavior change to the --update option. check-in: bf3c223723 user: drh tags: trunk
14:32
Import typo fixes from trunk. check-in: 6f80f0890f user: drh tags: branch-3.27
14:30
Fix a documentation error: The preprocessor macro is SQLITE_HAVE_ZLIB, not SQLITE_USE_ZLIB. However the USE_ZLIB=1 option is what Makefile.msc expects. check-in: 85f5f65d9f user: drh tags: trunk
2019-03-23
16:09
Add a note about the ".breakpoint" shell command to the "debugging.html" page. check-in: 61444ae7e4 user: drh tags: trunk
2019-03-22
15:04
Improvements to the debugging.html webpage. check-in: ad08afecb8 user: drh tags: trunk
2019-03-18
10:26
Updates to the size and speed graph spreadsheet. check-in: c925c91186 user: drh tags: trunk
2019-03-14
01:05
Fix a documentation typo. No changes to code. check-in: 81fdc2faea user: mistachkin tags: trunk
2019-03-07
00:26
Fix typos in the changelog for 3.28.0. check-in: 6bd3d16e85 user: drh tags: trunk
2019-03-06
15:16
Add the new sqlite3_stmt_isexplain() interface to the change log. check-in: 13e71499bd user: drh tags: trunk
15:03
Merge changes from the 3.27 branch. check-in: 00f74a59cd user: drh tags: trunk
2019-03-04
23:49
New expensify logo. check-in: 81ea50fc28 user: drh tags: branch-3.27
2019-03-02
17:13
Merge fixes from the 3.27 branch. check-in: dcc4d55e47 user: drh tags: trunk
17:12
Add an initial change log for the 3.28 development cycle. check-in: f41d1a3db0 user: drh tags: trunk
2019-03-01
13:27
Update the JSON parsing speed in the json1.html documentation. check-in: 393a3d19ae user: drh tags: branch-3.27
2019-02-28
17:29
Documentation on the bind_falback method of the TCL interface. check-in: fb20146338 user: drh tags: trunk
2019-02-27
23:13
Add a note to the printf() documentation to make clear that the built-in SQLite printf() does not implement positional parameters. check-in: e0c57dd3d0 user: drh tags: branch-3.27
16:51
Add documentation for the Tcl command "db function" -returntype option. check-in: 2f154421cf user: dan tags: trunk
13:46
Updates to the althttpd.md documentation. check-in: 9ea89e32bf user: drh tags: trunk