Documentation Source Text

Timeline
Login

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

191 check-ins using file misc/althttpd.md version 6446b55b82

2018-11-26
12:01
Fix typo in the wal.html document. Leaf check-in: 4182b1655e user: drh tags: branch-3.25
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