Documentation Source Text

Timeline
Login

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

500 most recent check-ins

2019-10-18
02:16
Fix a typo in the "quirks.html" document. Leaf check-in: 7dce3c2f8a user: drh tags: trunk
2019-10-16
18:07
Fix typos in the lemon documentation. 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-09-04
15:18
Update the speed-and-size spreadsheet with the latest figures. check-in: 33e05d1299 user: drh tags: trunk
2019-08-29
17:19
Add a description of NULLS FIRST and NULLS LAST. Add a note about the addition of sqlite3_drop_modules(). check-in: a7856e4125 user: drh tags: trunk
2019-08-15
23:05
Mention new defensive capabilities in the security.html page. check-in: b714ca6b96 user: drh tags: trunk
22:48
Update the change log with the latest enhancements. check-in: b3e162d6ec user: drh tags: trunk
16:12
Update the change log and the SQLITE_ENABLE_STAT3 documentation. check-in: 4c942f942c user: drh tags: trunk
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-14
17:19
In dashboard output, group outcomes by platform. check-in: 76662698a8 user: drh tags: trunk
16:54
Merge the test dashboard development line into trunk. check-in: ed6e0d08a7 user: drh tags: trunk
2019-08-12
11:54
Trying to improve the documentation on transactions. check-in: ead5e472f0 user: drh tags: branch-3.29
10:27
Minor improvements to dashboard. Closed-Leaf check-in: 44eb5d574e user: drh tags: test-dashboard
2019-08-07
21:59
Fix typo in comment. check-in: b0c5406903 user: mistachkin tags: trunk
19:23
Minor changes to the dashboard. check-in: 90a47a80c2 user: drh tags: test-dashboard
18:00
Improvements to the outcome display in the dashboard app. check-in: ed3480d864 user: drh tags: test-dashboard
17:46
The "outcomes" page on the dashboard automatically reloads every 5 minutes. check-in: 448a7b73d2 user: drh tags: test-dashboard
16:43
Updates to the dashboard.tcl app and its client-side library. First working code. check-in: c773092c19 user: drh tags: test-dashboard
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
20:39
Back out the previous change. We are instead going to modify the code to match the documentation. check-in: e16ada80d6 user: drh tags: trunk
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
12:54
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: 07b7749da8 user: drh tags: trunk
11:51
Show a table of outcomes in the dashboard.tcl app. check-in: 1f66b2f1a9 user: drh tags: test-dashboard
2019-08-02
17:54
In the checklist application, improve the submenu and simplify the login processing. (Originally checked in on the wrong branch.) check-in: ee656f1e92 user: drh tags: trunk
17:49
In the checklist application, improve the submenu and simplify the login processing. check-in: 20a5bb3601 user: drh tags: test-dashboard
15:52
Add an initial version of the client-side uplink library. check-in: 4e0da90810 user: drh tags: test-dashboard
2019-08-01
20:50
Initial code for a testing dashboard application. Not yet functional. check-in: 67d3af93de user: drh tags: test-dashboard
16:46
Update the /env method of the checklist application to work better with the latest version of Wapp for CGI. check-in: b1400ebb42 user: drh tags: trunk
16:36
Fix the checklist editing function on the checklist application so that it works correctly with Fossil CGI. check-in: 9d872b74d9 user: drh tags: trunk
02:44
Update the change log. check-in: 6ec9f2a9c8 user: drh tags: trunk
2019-07-27
16:09
Improvements to the header comment on the checklist application, bringing it up-to-date with the actual implementation. Added a prototype checklist database file. check-in: e8d378f753 user: drh tags: trunk
15:39
Add the CGI-Environment and Source-code submenu links to the checklist application. check-in: a5c38ef1bf user: drh tags: trunk
15:28
In the checklist application, add a /self method and make the magic database name "top" refer to the lexically largest database file. check-in: 752d433361 user: drh tags: trunk
15:13
Fixes to the checklist CGI so that it works better as a Fossil CGI extension. check-in: 41933da084 user: drh tags: trunk
2019-07-26
20:22
Update the checklist.tcl script to align with the latest code on the website. check-in: ef7dae4ce8 user: drh tags: trunk
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. check-in: 296e23a4b8 user: drh tags: trunk
2019-07-16
13:44
Updates to the testing document. 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
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
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
13:20
Sanitize the search string when doing a search against the changelog. check-in: 0a969667a7 user: drh tags: trunk
13:08
In althttpd.c, add a newline after error message replies. check-in: 12f6c3b314 user: drh tags: trunk
2019-02-25
16:46
Add a news item for the 3.27.2 release. check-in: f52168899f user: drh tags: trunk
16:10
Version 3.27.2 check-in: 4604e54aca user: drh tags: trunk, release, version-3.27.2
2019-02-18
20:35
Fix typos in the fileformat2.html page. check-in: eecca5ae5e user: drh tags: trunk
15:33
Change "the following three queries" to "the following four queries" in fts5.in. check-in: b5b65a3c13 user: dan tags: trunk
15:22
Clarification of the StrAppend() routine in althttpd.c. check-in: 90fe325e31 user: drh tags: trunk
2019-02-16
16:42
Extra defensive coding in althttpd.c. check-in: 2ae41f4427 user: drh tags: trunk
15:41
Enhancements to the althttpd.c SCGI mechanism: Added the "fallback:" and "relight:" lines to the *.scgi specification file format. check-in: 1c981267ee user: drh tags: trunk
2019-02-15
21:21
Send the SCGI environment variable with a value of "1" on SCGI requests. check-in: 216ba4ebe1 user: drh tags: trunk
20:56
Extra security in althttpd.c. check-in: 45c1cd9fae user: drh tags: trunk
20:31
Add SCGI support to the althttpd.c web server. check-in: 201d18b836 user: drh tags: trunk
20:31
Mention the use of SCGI in the althttpd.md file. Closed-Leaf check-in: d2ad0c8ca6 user: drh tags: althttpd-scgi
20:27
Updates to comments. Use size_t instead of int where appropriate. check-in: 5faf086850 user: drh tags: althttpd-scgi
20:14
Preliminary support for SCGI in althttpd. check-in: b3aaed91ba user: drh tags: althttpd-scgi
18:16
In althttpd.c, refactor some of the CGI processing logic as a preliminary step toward adding SCGI support. check-in: 3e667aef3a user: drh tags: trunk
17:00
Enhancements to althttpd.c: Add the --input FILE command-line option to simplify debugging using lldb. Improvements to comments. check-in: a537e6f3fc user: drh tags: trunk
11:43
Fix a typo in the ALTER TABLE documentation. check-in: 625c9fbdad user: drh tags: trunk
2019-02-12
13:54
Fix a typo in loadext.html. check-in: 4efb429d19 user: drh tags: trunk
12:27
Clarify how the SQLITE_OK_LOAD_PERMANENTLY return value should be used. check-in: 8182293dd8 user: drh tags: trunk
2019-02-11
13:24
Fix "asterix" typo in fts5.in. check-in: 569262e571 user: dan tags: trunk
13:21
Add documentation for the fts3/4/5 remove_diacritic options. check-in: 34f973966a user: dan tags: trunk
2019-02-08
16:06
The change of removing deprecated PRAGMAs with SQLITE_OMIT_DEPRECATED was backed out, so remove it from the change log. check-in: 0ed8a559a1 user: drh tags: trunk
13:54
Improved text for the 3.27.1 news article. check-in: b5727d3e83 user: drh tags: trunk
13:41
Add a news item for 3.27.1. check-in: c563fbbd64 user: drh tags: trunk
13:22
Version 3.27.1 check-in: 65b2939d78 user: drh tags: trunk, release, version-3.27.1
13:04
Changes for version 3.27.1. check-in: 287ea23516 user: drh tags: trunk
2019-02-07
18:10
Fix the chronology entry for 3.27.0. check-in: 79e69bbf6e user: drh tags: trunk
17:06
Version 3.27.0 check-in: f120fbc6f8 user: drh tags: trunk, release, version-3.27.0
16:59
Update the size and performance graph spreadsheet. check-in: 5c6358b7e1 user: drh tags: trunk
14:31
Fix typos detected by spellcheck. check-in: 8c65dc2deb user: drh tags: trunk
13:59
Add back the sponsors section to the front page. check-in: 3b7ad43873 user: drh tags: trunk
13:47
Merge changes from the 3.26.0 release branch. check-in: 9d6e96fd8f user: drh tags: trunk
13:42
Add news for 3.27.0 check-in: 7a25788e4c user: drh tags: trunk
2019-02-05
16:45
Update to the change log. check-in: f9f945c599 user: drh tags: trunk
12:58
Clarification to the VACUUM INTO documentation. check-in: c7001012e1 user: drh tags: trunk
2019-02-01
22:06
Fix typos and omissions in the change log. check-in: 91188df9ec user: drh tags: trunk
16:57
Clarification of "billion" and "trillion" on the most-used page. check-in: ca148dd5c0 user: drh tags: trunk
16:55
Clarification of usage claims on the index page. check-in: 20fa2ff51e user: drh tags: trunk
14:44
Fix a typo on the index page. check-in: 139fa7c746 user: drh tags: trunk
2019-01-31
17:51
Add documentation for SQLITE_CONFIG_MEMDB_MAXSIZE. check-in: cb850cf9a5 user: drh tags: trunk
2019-01-29
18:59
Fix a typo in the date-time function documentation. Leaf check-in: 0866c95aaf user: drh tags: branch-3.26
2019-01-28
20:31
Updates to the change log for version 3.27.0. check-in: 03bca65239 user: drh tags: trunk
12:16
Fix typo on the "PRAGMA database_list" documentation. check-in: 70943cf0c8 user: drh tags: branch-3.26
2019-01-22
20:59
Clean up links in the arch.html and opcode.html documents. check-in: ea5ed63f07 user: drh tags: trunk
2019-01-09
19:56
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. check-in: fd152b335d user: drh tags: branch-3.26
19:54
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. check-in: 83da33aabc user: drh tags: trunk
2018-12-26
12:00
Fix typo on the security.html webpage. check-in: 2ffc105f81 user: drh tags: branch-3.26
2018-12-15
11:12
Fix a typo in the assert.html document. check-in: 538a9a3099 user: drh tags: branch-3.26
02:51
Fix a typo in the code of ethics. check-in: 6e0f306cb7 user: drh tags: branch-3.26
01:17
Merge defense-against-dark-arts fixes from trunk. check-in: a8707b40a7 user: drh tags: branch-3.26
2018-12-14
19:01
Fix typos in the defense-against-dark-arts document. check-in: 94ad3e51e7 user: drh tags: trunk
15:54
Rename the "security.html" document as "Defense Against Dark Arts". Add the additional recommendation to avoid memory-mapped I/O on untrusted database files. check-in: 11d0259504 user: drh tags: trunk
2018-12-10
12:52
Futher homepage enhancements. Improvements and typo fixes on secondary pages. check-in: e6aa1d2d9a user: drh tags: trunk
12:34
Further tweaks to the homepage. check-in: dd073d8325 user: drh tags: trunk
12:09
Improvements to the homepage. check-in: 818a7ac30c user: drh tags: branch-3.26
12:08
Improvements to the homepage. check-in: 893d161a74 user: drh tags: trunk
11:48
Update the change log. check-in: 22f1dff034 user: drh tags: trunk
00:54
Fix the "Latest Release" on the front page. check-in: 2b5acd3ccf user: drh tags: branch-3.26
00:52
Begin a new change log entries for 3.27.0. check-in: 41f9becb46 user: drh tags: trunk
2018-12-09
22:31
Omit the sponsor links from the homepage. check-in: 551ce8e2ad user: drh tags: branch-3.26
22:30
Omit the sponsor links from the homepage. check-in: 3c035c0759 user: drh tags: trunk
22:23
Preliminary documentation for VACUUM INTO check-in: 130193a5b9 user: drh tags: trunk
2018-12-06
15:20
Enhanced ALTER TABLE documentation, and in particular show the dangers of not following the generalized 12-step ALTER TABLE procedure precisely. check-in: 4ffbc3f635 user: drh tags: trunk
2018-12-01
20:55
Adjust the date for 3.26.0 in the speed and size chart. check-in: 41f2b76661 user: drh tags: trunk
19:17
Enhancements to the geopoly documentation. check-in: 3ab6e3f6a6 user: drh tags: trunk
12:41
Version 3.26.0 check-in: 7463317ee9 user: drh tags: trunk, release, version-3.26.0
2018-11-30
21:04
Fix documentation typos. check-in: 297fc5035b user: drh tags: trunk
2018-11-28
14:59
Update the speed-and-size spreadsheet with the latest performance numbers. check-in: 71c9a6d2b0 user: drh tags: trunk
10:21
Further enhancements to the Quirks document. check-in: 8a0206bb29 user: drh tags: trunk
10:08
Fix a typo on the quirks.html page. check-in: dd1def55d8 user: drh tags: trunk
2018-11-26
18:57
Caution users to have well-defined column names in VIEWs. check-in: 5a0203cdca user: drh tags: trunk
12:01
Merge typo fix from the 3.25 branch. check-in: 121aeee579 user: drh tags: trunk
12:01
Fix typo in the wal.html document. Leaf check-in: 4182b1655e user: drh tags: branch-3.25
2018-11-24
20:58
In the GeoPoly documentation, mention that geopoly_ccw() can be used to correct vertex order after geopoly_xform(). check-in: bfc897c9c0 user: drh tags: trunk
20:24
Minor enhancements and updates to various documents. check-in: 9e12c649c9 user: drh tags: trunk
19:14
Update the speed-and-size spreadsheet and the cpu.html page. Also make minor tweaks to the omitted.html page. check-in: 555bf82e10 user: drh tags: trunk
2018-11-21
21:46
Improvements to the althttpd documentation. check-in: 44a1928f55 user: drh tags: trunk
2018-11-16
17:33
Update the speed-and-size chart for version 3.26.0 (beta). check-in: f7ada093c1 user: drh tags: trunk
14:35
Add the SQLITE_CONSTRAINT return from xBestIndex to the change log. check-in: 14b1451274 user: drh tags: trunk
14:33
More fixes to the virtual table documentation. check-in: 70c4eaad4d user: drh tags: trunk
14:30
Explain the use of SQLITE_CONSTRAINT as a return value from xBestIndex. check-in: 52c277f049 user: drh tags: trunk
01:45
Fix a typo in csv.html. check-in: ccee8fa12e user: drh tags: trunk
01:43
Improvements to documentation on the CSV virtual table. check-in: c0ef40b603 user: drh tags: trunk
2018-11-15
16:53
Remove all hyperlinks to CVSTrac in preparation for shutting down all CVSTrac servers, which are now unmaintained for 10 years and are showing their age. check-in: 3c24a2c7f6 user: drh tags: trunk
2018-11-13
19:55
Improvements to documentation associated with new features in version 3.26.0. check-in: 3d96456389 user: drh tags: trunk
2018-11-12
15:24
Enhancements to the documentation regarding security and shadow tables. check-in: 7b6b7a791b user: drh tags: trunk
13:39
Begin adding a change log for version 3.26.0. check-in: a74a421c12 user: drh tags: trunk
2018-11-07
20:07
Merge changes from the 3.25 branch. check-in: 3b8a91bbce user: drh tags: trunk
17:35
Improvements to the documentation of the busy method in the TCL interface. Words contributed by flightaware. check-in: bf23032b75 user: drh tags: branch-3.25
2018-11-05
20:41
Version 3.25.3 check-in: d2c8e25ac9 user: drh tags: release, version-3.25.3, branch-3.25
16:42
Preparation for the 3.25.3 patch release. check-in: 176a9535a2 user: drh tags: branch-3.25
2018-10-31
18:16
Update the Bloomberg logo to conform to their most recent. check-in: 4c305230da user: drh tags: branch-3.25
2018-10-29
16:43
Fix a typo on the prosupport.html page. check-in: a2738e8e4d user: drh tags: branch-3.25
2018-10-25
20:19
Merge changes from the 3.25 branch. check-in: efd5b055b2 user: drh tags: trunk
01:40
Add a link from the code of ethics back to the code of conduct. check-in: 5e6fe2c1d5 user: drh tags: branch-3.25
2018-10-24
19:30
Fix typo in codeofethics.in. check-in: e59abc19a7 user: drh tags: branch-3.25
19:26
Fix typos in the codeofconduct.html document. check-in: 626d883e22 user: drh tags: branch-3.25
18:30
Rename the codeofconduct.html page to codeofethics.html. Create a new codeofconduct.html page that references the MCPG. check-in: b65ec66abe user: drh tags: branch-3.25
11:37
Pull in all the changes on the 3.25 branch. check-in: 097d5fec34 user: drh tags: trunk
2018-10-23
20:20
Omit the sponsor links from the homepage. check-in: 62248cde6a user: drh tags: branch-3.25
18:44
Fix CoC typos. check-in: af1ee4516a user: drh tags: branch-3.25
13:58
Fix a typo in the CoC. check-in: 90656237d0 user: drh tags: branch-3.25
13:51
Further clarification to the CoC, to try to forestall misinterpretation of the scope and intent. check-in: 8883859ae3 user: drh tags: branch-3.25
04:25
Update the preface to the code-of-conduct to clarify to whom the rule applies, and also to add an enforcement mechanism and a mechanism to deal with new developers who have concerns about the rule. check-in: f5ef4b0991 user: drh tags: branch-3.25
2018-10-22
16:07
Update RBU documentation to include REPLACE command rows. check-in: a9594020c6 user: dan tags: trunk
15:42
Fix a typo on the dbstat.html page. check-in: 07eea695f1 user: drh tags: branch-3.25
2018-10-14
20:33
Fix typo on the GLOB documentation. check-in: ddacae7fd0 user: drh tags: branch-3.25
2018-10-03
12:59
Add documentation for missing result codes. check-in: 76e1292157 user: drh tags: branch-3.25
2018-09-28
23:43
Initial documentation for the MEMSTAT virtual table. check-in: 6f48ca52cf user: drh tags: trunk
20:59
Fix typos on th enew dbpage.html page. check-in: 966ccc894f user: drh tags: trunk
20:51
Add documentation on the sqlite_dbpage virtual table. check-in: 86e3ea9245 user: drh tags: trunk
17:08
Add documentation for the geopoly_regular() function. check-in: 7804034c38 user: drh tags: trunk
2018-09-27
13:06
Say that the recursive part of a CTE may not use aggregate or window functions. check-in: cf2f8cbd8f user: drh tags: branch-3.25
12:56
Say that the recursive part of a CTE may not use aggregate or window functions. check-in: aa1202143a user: drh tags: trunk
2018-09-26
19:52
Fix a formatting error in the rtree.html document. check-in: 3b812913fe user: drh tags: branch-3.25
15:19
Merge changes from the 3.25 branch. check-in: 2e3a732177 user: drh tags: trunk
2018-09-25
19:32
Version 3.25.2 check-in: 8c31c0cd8c user: drh tags: release, version-3.25.2, branch-3.25
19:28
Clarification to the order of arguments in like() and glob(). check-in: 86e05fde50 user: drh tags: branch-3.25
19:28
Update the sha3 sum for sqlite3.c for version 3.25.2. check-in: 31377cc26a user: dan tags: branch-3.25
19:13
Add hashes to the 3.25.2 change log. check-in: 2770eeff69 user: drh tags: branch-3.25
16:26
Improvements to the legacy_alter_table pragma documentation. Typo fix in the change log. check-in: db3facf719 user: drh tags: branch-3.25
15:02
Preliminary changes for version 3.25.2. check-in: e00e728eae user: drh tags: branch-3.25
2018-09-24
14:46
Clarify the operation of the "weekday" date and time modifier. check-in: b4b8f35ef1 user: drh tags: branch-3.25
14:38
Improved linkage to window functions. check-in: 1c7ab913f0 user: drh tags: branch-3.25
12:40
Document the SQLITE_QUERY_PLANNER_LIMIT and SQLITE_QUERY_PLANNER_LIMIT_INCR compile-time options. check-in: 55fce17e3c user: drh tags: trunk
2018-09-21
10:16
Fix a harmless typo in the json documentation. check-in: 2bdb2d7e21 user: drh tags: trunk
2018-09-19
11:04
Fix a typo in the JSON extension documentation. check-in: 7eef7f4c93 user: drh tags: trunk
2018-09-18
20:33
Add news to the 3.25.1 release. check-in: e81118eeb9 user: drh tags: trunk
20:26
Version 3.25.1 check-in: 6ffc80634e user: drh tags: trunk, release, version-3.25.1
2018-09-17
18:38
Initial change log for version 3.25.1. check-in: 9daac74fb0 user: drh tags: trunk
12:48
Fix typo. check-in: be9d86ac89 user: mistachkin tags: trunk
2018-09-15
04:26
Version 3.25.0 check-in: 9089e073c4 user: drh tags: trunk, release, version-3.25.0
2018-09-14
17:42
Fix minor typos detected by the spell checker. check-in: c68e153fc6 user: drh tags: trunk
16:54
Add news for the 3.25.0 release. check-in: 884ea7b3ed user: drh tags: trunk
16:34
The application_id is a signed integer. check-in: 3580ba4b5b user: drh tags: trunk
15:54
Update the speed-and-size spreadsheet with the latest measurements. check-in: 37ab9b40af user: drh tags: trunk
2018-09-13
12:50
Updates to the geopoly documentation. check-in: f1742a52f5 user: drh tags: trunk
2018-09-12
10:49
Fix typos in the windowfunctions.html document. check-in: 221cce4209 user: drh tags: trunk
2018-09-11
22:44
Fix typos in the geopoly document. check-in: 81cf14c724 user: drh tags: trunk
18:17
Updates to the change log. check-in: 5c91ca999e user: drh tags: trunk
2018-09-10
14:56
Update the change log with recent bug fixes. check-in: eba1c4fd81 user: drh tags: trunk
2018-09-06
21:37
Improvements to the RENAME COLUMN syntax diagram. check-in: c951c8c482 user: drh tags: trunk
20:36
Fix a long-standing typo in the ALTER TABLE documentation. check-in: 9b5947f2ee user: drh tags: trunk
20:34
Update the documentation to reflect the enhancements to ALTER TABLE. check-in: c3c04a7bb4 user: drh tags: trunk
20:05
Update the ALTER TABLE bubble diagram to show the RENAME COLUMN syntax. check-in: f995368f57 user: drh tags: trunk
20:02
Merge documentation fixes from the 3.24.0 release branch. check-in: 4235bb053e user: drh tags: trunk
19:09
Updates the speed and size graph spreadsheet. check-in: e772c0fa3a user: drh tags: trunk
2018-09-05
09:58
Fixes to the geopoly documentation. check-in: ab4f7977fb user: drh tags: trunk
2018-09-03
10:57
Fix a typo in the CREATE TABLE documentation. check-in: aff4908d94 user: drh tags: trunk
10:46
Fix a typo in the testing.html document. check-in: fb87225a7a user: drh tags: trunk
2018-09-02
10:12
Fix a duplicate anchor in the lang.in page. Leaf check-in: 718909cfaf user: drh tags: branch-3.24
2018-08-27
20:52
Enhancements to the virtual table documentation to describe the operation of SQLITE_INDEX_CONSTRAINT_FUNCTION. check-in: f3d8866e42 user: drh tags: trunk
17:15
First cut at documentation for the Geopoly module. check-in: a007133016 user: drh tags: trunk
2018-08-25
14:56
Fix a duplicate fragment name in lang_expr.html check-in: 8ffd68dac7 user: drh tags: trunk
2018-08-15
13:21
Pre-expand key railroad diagrams in the windowfunctions.html page. check-in: 61483bc834 user: drh tags: trunk
2018-08-08
17:36
Fixes to the CGI handling in althttpd.c. check-in: 6faf1e47b9 user: drh tags: trunk
2018-08-06
01:42
Fix typos in the windowfunction documentation. check-in: ab3b52646c user: drh tags: trunk
2018-08-01
07:08
In althttpd.c, make sure all file descriptors other than 0, 1, and 2 are closed prior to launching CGI. check-in: c84d76df63 user: drh tags: trunk
2018-07-30
20:16
Enhancement to the how-to-corrupt document. check-in: 06a6ca5d34 user: drh tags: branch-3.24
2018-07-27
23:56
Sublists in the change log are a-b-c instead of 1-2-3. check-in: 3e5cf6efac user: drh tags: trunk
23:55
Change log updates. check-in: 6a6488d91d user: drh tags: trunk
2018-07-23
18:32
Improved documentation for snapshots. check-in: 62d574457f user: drh tags: trunk
12:58
Update the size and speed spreadsheet check-in: 328bad0eed user: drh tags: trunk
11:17
Merge changes from branch-3.24 check-in: 777501f7ed user: drh tags: trunk
11:16
Prosupport edits. check-in: fb2699cc28 user: drh tags: branch-3.24
11:02
Merge changes from the 3.24 branch. check-in: 137b4b6a0f user: drh tags: trunk
11:00
Further changes to the prosupport documentation. check-in: 00457c34b5 user: drh tags: trunk
10:53
Changes to information on support packages. check-in: 5caed7a191 user: drh tags: branch-3.24
10:51
Changes to information on support packages. check-in: 7e685f86a9 user: drh tags: trunk
2018-07-13
20:31
Add docs for fts5 unicode61 tokenizer option "categories". check-in: e32e877119 user: dan tags: trunk
2018-07-11
11:08
Update the keyword list with all of the new keywords added for UPSERT and window functions. check-in: 824b38d28e user: drh tags: trunk
2018-07-07
17:44
Update the "small footprint" docs to put the size at 600KB instead of 500KB, as we have crossed that threshold with the addition of window functions. check-in: eeaadb7da2 user: drh tags: trunk
17:36
Minor changes to the windows function documentation. check-in: ff1e1e885a user: drh tags: trunk
2018-07-06
20:43
Work on the window function documentation, including importing the new syntax diagrams. check-in: 6d60e5d021 user: drh tags: trunk
18:30
Update the syntax diagrams to include the new window function syntax. check-in: f7a6a2f7c2 user: drh tags: trunk
2018-07-05
21:13
Fix typo in the RANGE documentation of windows functions. check-in: 463da73728 user: drh tags: trunk
2018-07-02
08:00
Add a sentence to the FTS3/4 documentation to make it clear that only columns that are part of the FTS3/4 table declaration exist, even if an external content table with more columns is in use. check-in: ea0f0b4c4a user: dan tags: trunk
2018-06-30
20:30
New entries in the change log. check-in: 5ef0fc4e97 user: drh tags: trunk
20:23
Create a change log for version 3.25.0 check-in: 5697c09027 user: drh tags: trunk
2018-06-26
18:24
Mention that UPSERT does not work for virtual tables. check-in: 887762cf99 user: drh tags: branch-3.24
17:48
Improve the example of how to create a new aggregate window function in windowfunctions.in. check-in: 873c1ea4b7 user: dan tags: trunk
2018-06-25
20:35
Add documentation for implementing new aggregate window functions. check-in: b5a81b3bdf user: dan tags: trunk
2018-06-22
16:14
Add further examples to windowfunctions.in. check-in: 84418fef8d user: dan tags: trunk
2018-06-21
21:00
Improve windowfunctions.in. check-in: 7094fcac78 user: dan tags: trunk
2018-06-20
21:13
Add beginning of documentation for window functions in new file windowfunctions.in. check-in: c1e5cf0cb1 user: dan tags: trunk
2018-06-15
19:12
Fix missing "const" in the documentation of the argv parameters to the xCreate and xConnect methods in the sqlite3_module object. check-in: 2ee890a53a user: drh tags: branch-3.24
2018-06-09
22:13
Fix typos in the compile.html page. check-in: 10c05df9fb user: drh tags: branch-3.24
2018-06-08
13:41
Fix the -auth redirect logic to avoid duplicating part of the URL. check-in: 76396bf1df user: drh tags: trunk
13:21
Use https for all internal hyperlinks. Leaf check-in: 59e5f9e3da user: drh tags: branch-3.24-https
2018-06-07
18:29
In althttpd.c, add the "anyone" line to the -auth file syntax. This allows inserting an -auth file that reads "http-redirect \n anyone" and which will force HTTP connections to redirect to HTTPS. check-in: 9005943d91 user: drh tags: trunk
2018-06-05
23:20
Clarification that the overwrite optimization does not affect the behavior of triggers. check-in: 27b8057665 user: drh tags: branch-3.24
13:43
Add hyperlinks for "index b-tree" and "table b-tree". check-in: 35ca8da032 user: drh tags: trunk
2018-06-04
19:41
Add the upsert-clause.gif image. check-in: 7d927bcea1 user: drh tags: trunk
19:28
Add the final date and various hashes for the 3.24.0 release. check-in: c300836d83 user: drh tags: trunk
2018-06-01
17:41
Add the Sanderson book to the books.html page. check-in: 97f6d1477c user: drh tags: trunk
2018-05-31
19:14
Typo fixes. check-in: db85f0efae user: drh tags: trunk
17:37
Miscellaneous typo fixes and minor enhancements. check-in: 1a236e279d user: drh tags: trunk
16:43
Create a News article about the 3.24.0 release. check-in: 6cb0e35932 user: drh tags: trunk
13:17
Add a size graph with units of mibibytes. check-in: d6256c1615 user: drh tags: trunk
13:11
Update the speed and size graph. check-in: 696489a7db user: drh tags: trunk
2018-05-29
18:35
Document (with links) that SQLite is a LoC Recommended Storage Format. check-in: 2ab12e598f user: drh tags: trunk
15:55
Change log updates due to review of sqlite3.c diffs from prior release. check-in: 4a562f8d21 user: drh tags: trunk
2018-05-26
01:59
Show the apSqlParam field that was added to the sqlite3_rtree_query_info object in version 3.8.11. check-in: b5582fa868 user: drh tags: trunk
2018-05-25
22:50
Fix a typo in the rtree documentation. check-in: fe9ab1ba5b user: drh tags: trunk
18:17
Improved wording on the OsQuery description. check-in: 1a2d15781d user: drh tags: trunk
17:50
Add the vtablist.html page. check-in: 3d073f02d7 user: drh tags: trunk
12:54
Clarification of xUpdate behavior in the virtual table documentation. check-in: 36334d1830 user: drh tags: trunk
2018-05-23
20:21
Updates to the speed and size graph. check-in: b25c5620c3 user: drh tags: trunk
18:06
Update the change log to mention the sqlite_sequence bug. check-in: b31a1c8b32 user: drh tags: trunk
2018-05-22
15:40
Better phrasing of the read-only WAL mode disadvantage in wal.html. check-in: 729be21bb1 user: drh tags: trunk
15:31
Read-only WAL mode in 3.22, not 3.20. check-in: f5137e463c user: drh tags: trunk
15:28
Update information on read-only WAL-mode databases to conform with the new capabilities added in version 3.22.0. check-in: ba027764e3 user: drh tags: trunk
2018-05-19
14:21
Updates to the TH3 documentation. check-in: ac3ef1f6aa user: drh tags: trunk
2018-05-18
18:02
Merge fixes from the 3.23 branch. check-in: 45753832a8 user: drh tags: trunk
18:02
Update docs for the r-tree auxiliary columns. check-in: daa211f9cd user: drh tags: trunk
2018-05-17
20:40
Updates to the change log and other documentation pages. check-in: 4c3f0e6adb user: drh tags: trunk
10:02
New advantage of SQLite Archives: Bypass firewall censorship. Leaf check-in: ef0b96b340 user: drh tags: branch-3.23
2018-05-09
10:11
Merge fixes from the 3.23 branch. check-in: cc22fb914a user: drh tags: trunk
10:10
Fix documentation typos. check-in: 9d89e82c5d user: drh tags: trunk
2018-05-08
14:32
More details on the UPSERT documentation. check-in: 7ca811b29f user: drh tags: trunk
13:35
Mention the cell-overwrite optimization on the change log. check-in: d324d1a30e user: drh tags: trunk
2018-05-04
16:43
Documentation for SQLITE_ENABLE_SORTER_REFERENCES. check-in: 183931a121 user: drh tags: trunk
05:03
Update the speed-and-size spreadsheet. check-in: 0fdc011d0b user: drh tags: trunk
02:36
Begin revising the EXPLAIN QUERY PLAN document. More work is needed here. Update the change log. check-in: f07b7a3a18 user: drh tags: trunk
2018-04-30
22:39
More detail on synchronous=NORMAL. check-in: 13c3dff046 user: drh tags: branch-3.23
22:27
Update the change log. Fix typo in virtual table documentation. check-in: 32c5dad1b2 user: drh tags: trunk
2018-04-25
00:02
Updates to the change log. check-in: 6d211fe371 user: drh tags: trunk
2018-04-20
00:00
Document the fact that UPSERTs count INSERT operations but not UPDATEs. check-in: fcfd6e8be6 user: drh tags: trunk
2018-04-19
13:28
Preliminary documentation for upsert. check-in: 74564b6da7 user: drh tags: trunk
10:24
Start the change log for 3.24.0 check-in: 1f4c6d050e user: drh tags: trunk
2018-04-14
18:49
Fix incorrect hyperlink to xkcd in the whynotgit.html document. check-in: ee9866f9cc user: drh tags: trunk
11:48
Add a link to the lobsters discussion to whynotgit.html. check-in: 08879e07be user: drh tags: trunk
11:12
Improve the focus of the "open-source, not open-contribution" section of the Copyright page. check-in: 1e4dabf140 user: drh tags: trunk
11:02
Add a link to the revision history of the whynotgit.html document. check-in: 34c5347f0b user: drh tags: trunk
10:22
Minor edits to whynotgit.html due to Reddit comments. check-in: 2ad4610bdf user: drh tags: trunk
2018-04-13
15:09
Fix a minor formatting issue in the tempfiles.html document. check-in: 9f03d7ca10 user: drh tags: trunk
2018-04-12
18:21
More tweaks to the whynotgit.html document. check-in: 200882d3ff user: drh tags: trunk
18:08
Fix yet another typo in whynotgit.html check-in: 13eff8bb25 user: drh tags: trunk
17:04
Fix a typo on the optoverview.html document. check-in: 5272d8d61d user: drh tags: trunk
15:31
There are "hundreds of billions", not "tens of billions" of SQLite database files in circulation - in the rowidtable.html document. check-in: c34168d55b user: drh tags: trunk
14:47
Tweaks to the whynotgit.html page. check-in: 149486cfb5 user: drh tags: trunk
14:09
Correct details in the description of the SHM file format. check-in: d40d77faa2 user: drh tags: trunk
2018-04-11
17:10
Fix a typo in the whynotgit.html document. check-in: b4af616809 user: drh tags: trunk
14:29
Update the whynotgit.html article. check-in: e9e9759f68 user: drh tags: trunk
11:29
Fix duplicate ticket link in the change log for 3.23.1. check-in: 4d52786c5d user: drh tags: trunk
03:33
Fix a typo in the whynotgit.html page. check-in: 36bacb0ca7 user: drh tags: trunk
2018-04-10
18:53
Fix another typo in whynotgit.html check-in: dc2c4c372b user: drh tags: trunk
18:26
Fix typos in the whynotgit.html document. check-in: 4b40ee5303 user: drh tags: trunk
17:44
Version 3.23.1 check-in: f7fce883af user: drh tags: trunk, release, version-3.23.1
17:09
Fix a typo in the whynotgit.html document. check-in: 44fe2354a1 user: drh tags: trunk
13:48
Update the performance and size spreadsheet. Update the cpu.html page with the latest graph. check-in: 9e3acfbfab user: drh tags: trunk
12:36
Changes for the 3.23.1 patch release. check-in: 21ae80926f user: drh tags: trunk
01:09
Merge fixes from the 3.23.0 branch. check-in: 2ca5d3c1c4 user: drh tags: trunk
00:29
Fix a typo in the whynotgit.html document. Leaf check-in: 737022637a user: drh tags: version-3.23
00:24
Add the Why SQLite Does Not Use Git document. (Cherrypick from trunk) check-in: 50c596f536 user: drh tags: version-3.23
00:21
Add the Why SQLite Does Not Use Git document. check-in: 1b4a90faa0 user: drh tags: trunk
2018-04-09
22:34
Fix typos in cpu.html. check-in: fc3877b543 user: drh tags: version-3.23
01:19
Fix typo in the lang_createindex.html document. check-in: f8c8d8614f user: drh tags: version-3.23
2018-04-07
12:00
Fix a typo on the "when to use" page. check-in: 1963430c3f user: drh tags: version-3.23
11:54
Add "data transfer format" to the use cases for SQLite in the "When to Use" document. check-in: d232f16b87 user: drh tags: version-3.23
2018-04-06
12:16
Align the use of the "BLOB" affinity in lang_createtable.html with the definitions in datatype3.html. check-in: e4161dc6b1 user: drh tags: version-3.23
2018-04-04
00:56
Enhance the how-to-corrupt document to warn against carrying an open database connection across a fork(). check-in: 516e342f08 user: drh tags: version-3.23
2018-04-03
12:02
Work on the "quirks.html" page. The page is still incomplete, but I need to divert attention to other issues so I'm checking in partial changes. check-in: 508297d763 user: drh tags: trunk
2018-04-02
21:24
Fix a typo in the CLI document. check-in: 7bf84d856a user: drh tags: version-3.23
15:25
Updates to the "serverless" page to talk about resent definitions of that word. Add a skeleton for the "quirks" document. check-in: 1e78d197a1 user: drh tags: trunk
11:10
Version 3.23.0 check-in: 9f377d4453 user: drh tags: trunk, release, version-3.23.0
2018-03-30
18:41
More spelling errors fixed. check-in: c9667def97 user: drh tags: trunk
18:33
Fix typos discovered by spell-check. check-in: e436f9d464 user: drh tags: trunk
18:12
Add news and update metrics in testing.html. check-in: 9f7ee8332a user: drh tags: trunk
18:08
Bring the speed-and-size spreadsheet up-to-date. check-in: f80a29418e user: drh tags: trunk
17:15
Fix a close-requirement mark in optoverview.html. check-in: 2f6a562725 user: drh tags: trunk
2018-03-29
18:55
Fix a bad unicode character in the books.html page. check-in: 1db40a5e0e user: drh tags: trunk
2018-03-28
15:54
A couple more minor changes in the change log. check-in: ac0b5884a5 user: drh tags: trunk
15:11
Add mention of sqlite3changeset_apply() hardening to the change log. check-in: 156259f9a6 user: drh tags: trunk
2018-03-27
12:51
Update the speed and size chart. check-in: e704c03dfe user: drh tags: trunk
2018-03-24
08:53
Typo fixes and wording improvements. check-in: ff59449da3 user: drh tags: trunk
2018-03-23
23:09
Typos and minor wording changes to the CoC intro to bring it into alignment with the trunk. Leaf check-in: 29d1943774 user: drh tags: branch-3.22
23:08
Fix typo and minor wording change in the CoC. check-in: 43b0cc26d6 user: drh tags: trunk
23:02
Minor simplification to the overview in the CoC. check-in: 03da80f8be user: drh tags: trunk
22:56
Copy the new CoC overview from trunk. check-in: 3b828f75e4 user: drh tags: branch-3.22
22:56
Further rework of the overview to the CoC. check-in: 3015ed3356 user: drh tags: trunk
19:16
Rework the overview section of the CoC. check-in: 647aab3db2 user: drh tags: trunk
18:18
Cross-reference whyc.html to the HN and Reddit comments. check-in: a8bc3a4771 user: drh tags: trunk
17:50
Tweaks to the new assert documentation. check-in: 19d3bdb7e3 user: drh tags: trunk
17:42
Updates to the whyc.html and assert.html documentation pages. check-in: e7ab215c5b user: drh tags: trunk
14:53
Clarification of text in the new optoverview.html section on the LEFT JOIN Optimization. check-in: 9e6750c1fc user: drh tags: trunk
14:46
Update syntax diagrams and expression text to cover the new TRUE and FALSE literals and the IS TRUE and IS FALSE operators. check-in: dfdf980e6c user: drh tags: trunk
14:30
Add TRUE and FALSE to the syntax diagrams as new literal values. check-in: 1d1c0fc6ec user: drh tags: trunk
11:47
Fix typos. Clarification to the CoC in response to criticism. check-in: 79f3efbc86 user: drh tags: trunk
2018-03-22
18:55
Further enhancement to the optimizer overview document, giving the change log for 3.23.0 something to link to. check-in: 219fa13637 user: drh tags: trunk
13:36
Refactor the optoverview.html document to be written in HTML with occasional <tcl> tags, rather than in pure TCL, so that it works better with fancy-format. check-in: 69fd8c5ba9 user: drh tags: trunk
12:01
Updates to the change log. check-in: 50c0768dbe user: drh tags: trunk
2018-03-20
13:15
Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. check-in: 015a7ffa9e user: drh tags: branch-3.22
13:14
Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. check-in: fc5ba69bb7 user: drh tags: trunk
2018-03-19
13:46
Document two new bug fixes in the change log. check-in: 58f72e5776 user: drh tags: trunk
2018-03-15
15:13
Updates to the change log. check-in: 6b0d51b8b9 user: drh tags: trunk
14:45
Merge typo fixes from the 3.22.0 branch. check-in: 2fca7bc025 user: drh tags: trunk
11:25
Fix typos in the th3.html document. check-in: 996754464c user: drh tags: branch-3.22
2018-03-14
21:01
Updates to the assert.html document. check-in: 6b0d70f277 user: drh tags: trunk
19:09
Fix a typo in the whyc.html page. check-in: c7663e0c39 user: drh tags: branch-3.22
2018-03-10
20:39
Updates to the TCL interface documentation, plus other minor typo fixes. check-in: 381e82d92b user: drh tags: trunk
18:40
Improvements to ZIP processing in the CLI document. Fix a hyperlink in the sqlar.html document. check-in: 23f1f44cc2 user: drh tags: trunk
15:27
Improvements to the sqlar.html page. check-in: 0a2c8d8f26 user: drh tags: trunk
12:09
Fix a typo in the zipfile.html document. check-in: 7accc324d8 user: drh tags: trunk
12:05
Fix a typo on the printf.html page. check-in: 5c4f29e7bd user: drh tags: trunk
2018-03-09
18:11
Merge search box fixes from the 3.22.0 branch. check-in: 848c37b010 user: drh tags: trunk
18:11
Further improvements to the search script. check-in: 55959de4e8 user: drh tags: branch-3.22
17:59
Improvements to Wapp to clean up the previous XSS fix. check-in: 4652ea52c0 user: drh tags: branch-3.22
17:26
Fix a XSS problem in the search box. check-in: c57271bdec user: drh tags: branch-3.22
2018-03-08
16:27
Improvements to SQLite Archive documentation. check-in: 7647551ed3 user: drh tags: trunk
14:50
New alternative TCLINC and TCLLIB suggestions in the Makefile. check-in: 4cef637367 user: drh tags: trunk
13:39
Continuing work on the sqlar.html document. check-in: 2e4f0d8cda user: drh tags: trunk
12:18
Merge updates from the 3.22.0 release. check-in: 2fa11f57a9 user: drh tags: trunk
00:33
Add the documentation about SQLite Archive files. Updates to the change log. check-in: f49396b55b user: drh tags: trunk
2018-03-05
12:21
Fix a typo in the about.html page. While we were at it, remove some older and largely obsolete text from that page. check-in: 5f83963454 user: drh tags: branch-3.22
2018-02-28
22:21
Enhance the sessions documentation to show the methods of objects. check-in: a0b50e2c3d user: drh tags: trunk
21:50
Fix the sessions documentation generator so that code snippets are indented correctly. check-in: f3445c7d01 user: drh tags: trunk
2018-02-27
22:16
Updates to the althttpd documentation. check-in: 5a87c618a8 user: drh tags: trunk
21:29
Add documentation on althttpd. check-in: d9cb224c9f user: drh tags: trunk
16:36
Create a change log entry for 3.23.0. check-in: 45bd3cdd39 user: drh tags: trunk
2018-02-25
19:24
Be sure to ParseRfc822Date() has enough precision in its output. check-in: 3fed9a6fc9 user: drh tags: trunk
17:29
Fix some missing error codes from the previous althttpd.c check-in. check-in: 5f2e54c6c1 user: drh tags: trunk
17:25
Change the action codes in the althttpd.c log to be consistent numbers, rather than source code line numbers. Include text at the end of a file that will generate a cross-reference table in SQLite. check-in: 8aafa56bb9 user: drh tags: trunk
01:29
Add support for Last-Modified and If-Modified-Since in althttpd.c. check-in: 130feb0aa0 user: drh tags: trunk
2018-02-23
21:41
Add support for the "Test Checklist" named "0demo" in the checklist.tcl application. check-in: 53dab205ad user: drh tags: trunk
21:18
Add a customized version of the checklist.tcl script. check-in: 85e8a997dd user: drh tags: trunk
2018-02-22
20:36
The Makefile should now work out-of-the-box on Ubuntu. check-in: 5b2d8db588 user: drh tags: trunk
19:40
Remove the unused TCLSTUBSFLAGS from the makefiles. check-in: 1412cc8f93 user: drh tags: trunk
19:34
Remove the NAWK macros from the Makefiles, since they are no longer used. check-in: 76b1d7f1d4 user: drh tags: trunk
18:14
First draft of a new quality management plan. Still incomplete. check-in: 295c4e35bc user: drh tags: trunk
13:42
Add a draft of a quality management plan based on DO178B. But the document seems to prolix, and so it is parked on a branch while I explore simpler alternatives. Leaf check-in: 6a64bdf866 user: drh tags: do178b-qm-plan
12:39
Merge the 3.22.0 updates into trunk. check-in: c0ef1f2bd8 user: drh tags: trunk
12:27
Add the code of conduct document. check-in: d0d1d80bc4 user: drh tags: branch-3.22
2018-02-20
13:46
Further refinement of the new printf.html document. check-in: 6c1f37df7f user: drh tags: trunk
02:53
First cut at a separate document for the printf() string formatters. check-in: 664ed2dce4 user: drh tags: trunk
2018-02-19
10:46
Add a list of shadow tables to the fts5 documentation. check-in: 1225bcc93d user: dan tags: trunk
2018-02-17
17:08
Text clarification and typo fixes on the copyright.html page. check-in: 8a0f41df1a user: drh tags: branch-3.22