Documentation Source Text

Timeline
Login

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

200 most recent check-ins using file pages/unlock_notify.in version 24fca5c67a

2020-04-14
15:35
Fix a typo in rescode.html. (check-in: 786d2dc899 user: dan tags: trunk)
14:08
Fix a typo in limits.in. (check-in: 2664eaab37 user: dan tags: trunk)
2020-03-30
13:05
Updates to the speed-and-size chart. (check-in: ff60a85843 user: drh tags: trunk)
2020-03-27
13:02
Fix a typo in the "compile.html" document. (check-in: ea92357277 user: drh tags: branch-3.31)
2020-03-25
11:25
Fix a memory allocation error in CGI handling of althttpd.c. (check-in: e9a50836bc user: drh tags: trunk)
2020-03-24
16:08
Steer users more strongly toward the SQLite Forum. Remove links to mailing list signup. (check-in: 81624489f5 user: drh tags: branch-3.31)
2020-03-20
12:44
Provide more accurate elapse time measurements in the output log of althttpd.c (check-in: f474634ac8 user: drh tags: trunk)
2020-03-16
15:07
Performance improvement on CGI handling in althttpd.c (check-in: 1ec2d586fc user: drh tags: trunk)
2020-03-15
18:17
Enhance althttpd to support Range: attributes in the HTTP request header. (check-in: 1d3579379c user: drh tags: trunk)
2020-03-12
20:03
Update the support page to direct users to the SQLite Forum instead of to the mailing lists. (check-in: 2a8e648db7 user: drh tags: branch-3.31)
2020-03-06
00:13
Update the NOCASE documentation to make it clear that it uses sqlite3_strnicmp() for comparison and thus stops at the first embedded zero character in the string. (check-in: e751b0c91a user: drh tags: trunk)
2020-03-04
20:27
Small update to deterministic.html to mention generated columns. (check-in: 37b0c51a67 user: drh tags: trunk)
2020-03-03
18:22
Fix documentation typo in fileformat.html. (check-in: 5dacf1a573 user: drh tags: branch-3.31)
14:07
Update the althttpd documentation. (check-in: c7f0891d15 user: drh tags: trunk)
13:59
In the althttpd.c webserver, relax the constraint that filenames cannot begin with "." or "-" for the special "/.well-known/" path. The constraint remains for any URL that does not begin with "/.well-known/". And ".." is still disallowed. This change is necessary due to recent changes to the LetsEncrypt certbot. (check-in: 7027e3e86d user: drh tags: trunk)
2020-02-26
11:09
Fix a formatting problem in rescode.html. (check-in: d35032eb7f user: drh tags: branch-3.31)
2020-02-25
20:57
Initial documentation explaining the NUL characters can appear in the middle of TEXT strings and what to do about it. (check-in: e2299b8b80 user: drh tags: trunk)
2020-02-22
21:35
Fix a typo in datatype3.html. (check-in: ea9656e7d7 user: drh tags: trunk)
12:54
Fix a typo in the when-to-use page. (check-in: ee17d2f67b user: drh tags: branch-3.31)
12:53
Fix a typo in the when-to-use page. (check-in: 556d3bb6c4 user: drh tags: trunk)
2020-02-21
15:57
Fix typos in the testing.html document. (check-in: d4e9b24066 user: drh tags: branch-3.31)
15:27
Fix typos and improve phrasing in testing.in. (check-in: 80df0299e7 user: drh tags: trunk)
2020-02-20
04:01
Workaround for older web browsers that may not always set the 'location.origin' DOM property. (check-in: 5f54ffe04b user: mistachkin tags: trunk)
2020-02-18
20:24
Update the change log. (check-in: baac09c5a2 user: drh tags: trunk)
20:11
Fix the multi-column list display so that it works with documents that have both main and aux outputs. (check-in: 4e47b407a1 user: drh tags: trunk)
2020-02-10
20:43
Improvements to the built-in function lists. (check-in: 8ff2f2f334 user: drh tags: trunk)
20:33
Finish splitting the lang.in source file into separate parts. (check-in: ca272c33f2 user: drh tags: trunk)
17:23
Work toward splitting up the "lang.in" source file into individual source files, one for each language topic. (check-in: 90730870c5 user: drh tags: trunk)
2020-02-08
21:52
Lists with varying numbers of columns depending on screen width are converted to work off of CSS rather than using javascript. (check-in: bae1400568 user: drh tags: trunk)
2020-02-06
23:40
Clarification the UPSERT documentation. (check-in: 271f686636 user: drh tags: branch-3.31)
2020-02-03
16:23
Add change log for 3.32.0. (check-in: 69840d9eb5 user: drh tags: trunk)
2020-01-31
20:15
Attempt to clarify the CREATE TABLE documentation. In the generated column documentation, make it clear that SQLite deliberately ignores the collating sequence of the AS expression when determining the collating sequence of the generated column. (check-in: 91fa93da86 user: drh tags: trunk)
2020-01-29
23:04
Enhancements to the FTS3/4 documentation about the limitations of BOMs in string literals with the simple tokenizer in a UTF16 database. (check-in: 4d11f30804 user: drh tags: trunk)
21:29
Add the SQLITE_OMIT_AUTOINIT compile-time option to the set of recommended compile-time options. (check-in: f250d55692 user: drh tags: trunk)
20:19
Document the byte-order-mark limitation of fts3/4. (check-in: 7e55864b0a user: dan tags: trunk)
2020-01-27
20:02
Version 3.31.1 (check-in: 2ab23690d8 user: drh tags: trunk, release, version-3.31.1)
18:06
Initial changes for the 3.31.1 patch release. (check-in: 505d43b621 user: drh tags: trunk)
2020-01-26
18:03
Fix two documentation typos. (check-in: a7a8ecb98d user: drh tags: trunk)
2020-01-22
19:04
Version 3.31.0 (check-in: 44e1ce5453 user: drh tags: trunk, release, version-3.31.0)
17:53
Add news for the 3.31.0 release. (check-in: 0e92e9f7c1 user: drh tags: trunk)
17:49
Fix documentation typos. (check-in: 1894a02a1f user: drh tags: trunk)
17:13
Updates to the generated column documentation. (check-in: 2d23316bb5 user: drh tags: trunk)
2020-01-21
20:14
Update the speed-and-size spreadsheet. (check-in: 6639a1d518 user: drh tags: trunk)
2020-01-18
22:24
Enhanced documentation for the TCL interface, and especially warnings about the importance of using the -directonly option for application-defined functions. (check-in: 0d0e8a024d user: drh tags: trunk)
00:56
Documentation of two-size lookaside. (check-in: 668d3ca782 user: drh tags: trunk)
2020-01-17
19:03
Add documentation for SQLITE_OMIT_GENERATED_COLUMNS (check-in: df79d373f6 user: drh tags: trunk)
2020-01-15
13:20
Update the speed-size-graph to include timeline graphs. Output the chronology.json file when building. (check-in: e4f8c1c60f user: drh tags: trunk)
02:44
Update the speed-and-size chart. (check-in: 09b9c916d4 user: drh tags: trunk)
2020-01-14
01:57
Finish a first draft of the application-defined function document. (check-in: 66d5ec93a6 user: drh tags: trunk)
2020-01-13
20:33
Continue working to improve the documentation. (check-in: 264d9eef33 user: drh tags: trunk)
15:26
Template for the new "application-defined SQL function page". Improvements to security documentation. (check-in: 36399c3c34 user: drh tags: trunk)
13:33
Typo fixes. (check-in: 19599a7e1b user: drh tags: trunk)
2020-01-10
00:00
Reference the trusted_schema capability in the 3.31.0 change log. (check-in: 0fc93d49ce user: drh tags: trunk)
2020-01-08
11:12
Further clarification that collating functions only work on string values. (Leaf check-in: ba755cbcaa user: drh tags: branch-3.30)
2019-12-26
01:22
Push back the proposed release date for 3.31.0 by a month. (check-in: 157fdd299b user: drh tags: trunk)
2019-12-24
02:33
Document the fact that the R-Tree extension is not capable of doing simultaneous reads and writes. (check-in: a8afb2f905 user: drh tags: trunk)
2019-12-21
17:23
Enhancements and updates to the discussion of fuzzing in the testing document. (check-in: 3bf90e0caa user: drh tags: trunk)
15:22
Enhance CLI documentation to talk more about reading ZIP archives as database files. (check-in: e92fb43396 user: drh tags: trunk)
2019-12-14
11:02
Fix typo on the schema_version pragma documentation. (check-in: 2a413e2e3e user: drh tags: branch-3.30)
2019-12-07
12:14
Update the rtree documentation to report that type affinity is ignored for auxiliary columns. (check-in: 6958f518ec user: drh tags: trunk)
2019-12-06
13:08
Enhance the rtree documentation with more detail about the rules for column names and the affinity of columns in the rtree virtual table. (check-in: 8199b59a39 user: drh tags: trunk)
02:35
Enhance the rtree auxiliary column documentation to point out that constraints such as NOT NULL on auxiliary columns are silently ignored. SQLite ticket https://www.sqlite.org/src/info/8bf76328ac940d52 (check-in: c3ab325994 user: drh tags: trunk)
2019-12-02
21:36
Fix another incorrect date on 3.30.1. (check-in: c2a33222f0 user: drh tags: branch-3.30)
21:35
Fix the date on the 3.30.1 release, which was off by 3:21. (check-in: 12a0fc2e35 user: drh tags: branch-3.30)
2019-11-23
16:36
Fix the CLI documentation to always use ".headers" instead of sometimes using the abbreviated ".header". (check-in: a2762f0319 user: drh tags: trunk)
00:22
Documentation updates for new features. (check-in: 604ac8689d user: drh tags: trunk)
2019-11-19
19:15
Update the documentation to include information about aggregated mode for the DBSTAT table. (check-in: 8abf78baf9 user: drh tags: trunk)
2019-11-18
17:43
Mention the new SQLITE_OPEN_NOFOLLOW option in the change log. (check-in: d3ba10d894 user: drh tags: trunk)
2019-11-14
18:57
Documentation on hard-heap-limit. (check-in: 2252627a39 user: drh tags: trunk)
2019-11-07
12:48
Clarify what the file format ought to be when a WITHOUT ROWID table contains a PRIMARY KEY with redundant columns. This is not a change, but a filling in of previously omitted information. (check-in: 8cd33c0c9d user: drh tags: trunk)
2019-11-02
18:17
Update the keyword list. (check-in: 6904f495e9 user: drh tags: trunk)
12:10
Fix typo on the download page. (check-in: 037e7f6d68 user: drh tags: branch-3.30)
2019-11-01
23:58
Fix documentation for the ".explain auto" command. (check-in: c6125c2ae7 user: drh tags: branch-3.30)
2019-10-29
19:47
Fix typos in generated column documentation. (check-in: 3ec77ae315 user: drh tags: trunk)
16:31
Updates to the generated column documentation. Notate that the legacy_file_format pragma has been removed and replaced by the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). (check-in: 4b80493d37 user: drh tags: trunk)
09:03
Fix typo in the generated columns description. (check-in: eaa1cd343f user: drh tags: trunk)
03:35
Tighten the requirement so that every table must have at least one non-generated column. A STORED column does not count. (check-in: 3103f83e9e user: drh tags: trunk)
01:24
Begin adding documentation for generated columns. (check-in: a558a79107 user: drh tags: trunk)
2019-10-22
13:26
Fix a typo on the whentouse.html page. (check-in: 8b5ba0e2b1 user: drh tags: trunk)
2019-10-21
14:57
Update the CREATE TRIGGER documentation to acknowledge the fact that columns in the UPDATE OF syntax of CREATE TRIGGER need not exist in the table, and that the trigger only fires if one of the columns named in the UPDATE OF clause appear on the left-hand side of one of the terms in the SET clause of the UPDATE statement. (check-in: 998c5310eb user: drh tags: trunk)
2019-10-18
02:16
Fix a typo in the "quirks.html" document. (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)