Documentation Source Text

Timeline
Login

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

200 most recent check-ins using file images/fts3_leaf_node.png version d6b2a480b1

2020-04-06
18:59
Fix various minor HTML coding errors pointed out by Gisbert on the forum. Leaf check-in: de7905fcbb user: drh tags: branch-3.31
2020-04-05
19:14
Include a timeline link in the prerelease snapshot description. check-in: bda8dd11a5 user: drh tags: branch-3.31
2020-04-01
19:40
Fix a typo in the JSON1 documentation. check-in: e754041fb1 user: drh tags: branch-3.31
2020-03-30
14:32
Merge fixes from the 3.31 branch. Leaf check-in: 6155753faf user: drh tags: trunk
14:22
Fix typo in the JSON documentation. check-in: a9b40f21bb user: drh tags: branch-3.31
14:21
Remove unintential control character from the unlock_notify.html document. check-in: 8f5ade2031 user: drh tags: branch-3.31
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