Documentation Source Text

Timeline
Login

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

50 check-ins occurring around c300836d839035f2.

2018-07-23
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)