Documentation Source Text

Timeline
Login

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

100 most recent check-ins

2018-06-22
16:14
Add further examples to windowfunctions.in. Leaf 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. Leaf 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
18:33
Fix typos discovered by spell-check. check-in: e436f9d464 user: drh tags: trunk
18:12
Add news and update metrics in testing.html. check-in: 9f7ee8332a user: drh tags: trunk
18:08
Bring the speed-and-size spreadsheet up-to-date. check-in: f80a29418e user: drh tags: trunk
17:15
Fix a close-requirement mark in optoverview.html. check-in: 2f6a562725 user: drh tags: trunk
2018-03-29
18:55
Fix a bad unicode character in the books.html page. check-in: 1db40a5e0e user: drh tags: trunk
2018-03-28
15:54
A couple more minor changes in the change log. check-in: ac0b5884a5 user: drh tags: trunk
15:11
Add mention of sqlite3changeset_apply() hardening to the change log. check-in: 156259f9a6 user: drh tags: trunk
2018-03-27
12:51
Update the speed and size chart. check-in: e704c03dfe user: drh tags: trunk
2018-03-24
08:53
Typo fixes and wording improvements. check-in: ff59449da3 user: drh tags: trunk
2018-03-23
23:09
Typos and minor wording changes to the CoC intro to bring it into alignment with the trunk. Leaf check-in: 29d1943774 user: drh tags: branch-3.22
23:08
Fix typo and minor wording change in the CoC. check-in: 43b0cc26d6 user: drh tags: trunk
23:02
Minor simplification to the overview in the CoC. check-in: 03da80f8be user: drh tags: trunk
22:56
Copy the new CoC overview from trunk. check-in: 3b828f75e4 user: drh tags: branch-3.22
22:56
Further rework of the overview to the CoC. check-in: 3015ed3356 user: drh tags: trunk
19:16
Rework the overview section of the CoC. check-in: 647aab3db2 user: drh tags: trunk