Documentation Source Text

Timeline
Login

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

112 check-ins using file pages/vtablist.in version 763421176b

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