Documentation Source Text

Timeline
Login

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

50 most recent check-ins

2021-11-30
14:49
Add a brief note to explain that a query that uses an automatic index is what other database engines might call a "hash join". (Leaf check-in: 9bb8566076 user: drh tags: trunk)
2021-11-29
18:52
First cut at improving the date/time function documentation to incorporate the new unixepoch() function and new modifiers. (check-in: 7b3c3b904e user: drh tags: trunk)
2021-11-27
14:18
Version 3.37.0 (check-in: 1595e46492 user: drh tags: trunk, release, version-3.37.0)
14:09
Merge 3.36.0 documentation enhancements into trunk. (check-in: 7953fb4e89 user: drh tags: trunk)
14:07
Add a news item for version 3.37.0. (check-in: 157a35795e user: drh tags: trunk)
2021-11-26
21:13
Minor spelling corrections. (check-in: 89f61d3ed7 user: drh tags: trunk)
14:04
Update the speed-size spreadsheet. (check-in: 071c9e56ed user: drh tags: trunk)
2021-11-20
13:21
Update the constraint documentation to clarify that constraints are checked during INSERT and UPDATE but not during query operations. See forum thread 47dae2beebf94254. (check-in: 23603e03cd user: drh tags: trunk)
12:38
Updates to the speed-size graph spreadsheet. (check-in: 40702937bb user: drh tags: trunk)
2021-11-17
15:30
Spelling fixups for Custom Builds (check-in: 708d7b3cda user: larrybr tags: trunk)
2021-11-10
19:19
Fix spelling in copyright page. (check-in: 34fef5908f user: larrybr tags: trunk)
2021-11-08
13:35
For CLI, say .dump produces UTF-8 (not ASCII) (check-in: 299986cb19 user: larrybr tags: trunk)
2021-11-05
20:03
Update the release date. Add mention of the SQLITE_OPEN_EXRESCODE option. (check-in: 551858fb43 user: drh tags: trunk)
2021-11-03
16:36
Remove a superfluous requirement mark from the STRICT documentation. (check-in: d9cb0ac27f user: drh tags: trunk)
2021-11-02
23:03
Bring CLI doc up to date, including new .archive options. (check-in: ce75cac3ba user: larrybr tags: trunk)
21:19
Clarify sqlite3_threadsafe() return in threadsafe.html. (check-in: fafb4edaa3 user: larrybr tags: trunk)
2021-11-01
21:09
Clarification of the meaning of STRICT. (check-in: d7050c6de3 user: drh tags: trunk)
2021-10-31
23:29
Add the sqlite3_autovacuum_pages() interface to the change log. (check-in: 9550cf29a1 user: drh tags: trunk)
2021-10-22
20:05
Correct result code SQLITE_MAX_SQL_LENGTH stated limit. (check-in: bc36b83f47 user: larrybr tags: trunk)
19:22
Add a note about CVE-2021-42169. (Leaf check-in: 9c2a89cd40 user: drh tags: branch-3.36)
2021-10-21
17:18
Update documentation on fuzzing. (check-in: 242615f039 user: drh tags: trunk)
2021-10-14
17:25
Fix a typo in requirement markup. Change the candidate release date for 3.37.0 to 2021-11-16. (check-in: 7da3b63866 user: drh tags: trunk)
2021-10-13
15:12
Remove SQLITE_OPEN_EXCLUSIVE from the change log. (check-in: 511bfd3675 user: drh tags: trunk)
2021-10-12
03:48
For CLI build examples, use -o to avoid some puzzlement. (check-in: a62b13320f user: larrybr tags: trunk)
2021-10-11
14:49
Combine duplicative CLI notes. (check-in: 93af46f150 user: larrybr tags: trunk)
04:27
Further detail --safe preclusions. (check-in: 531902c835 user: larrybr tags: trunk)
2021-10-08
17:02
Add documentation for "PRAGMA writable_schema=RESET". (check-in: 7cb21e6a2b user: drh tags: trunk)
2021-10-06
19:08
Fix all "TBD" marks in the qmplan.html document. This is not to say that the QM document is finished - much more detail could be added - but at least every major section now has *some* text. (check-in: 4e1cf8e022 user: drh tags: trunk)
17:40
Updates to the qmplan. (check-in: a0218a251d user: drh tags: trunk)
17:12
Grammar de-nit QM plan (check-in: c527df416c user: larrybr tags: trunk)
16:02
Grammatical de-nit (check-in: 2034fc7ee6 user: larrybr tags: trunk)
14:45
Add documentation for the .open command and the --safe option for the CLI. (check-in: 4e3774bc1f user: drh tags: trunk)
10:14
Fix typo in the sign() documentation. (check-in: 6a78846f93 user: drh tags: branch-3.36)
2021-10-05
18:01
Remove duplicative section number from Atomic Commit page. (check-in: 109c9a31c8 user: drh tags: branch-3.36)
17:51
Remove duplicative section number from Atomic Commit page. (check-in: 6ae3aa33a7 user: larrybr tags: trunk)
2021-10-01
14:35
Push the proposed release date for 3.37.0 back to 2021-12-01. Improvements to the change long and to the CLI documentation. There are TBDs in the CLI documentation that we need to return to before the release. (check-in: d67110f163 user: drh tags: trunk)
2021-09-29
16:36
Minor update to documentation of the custom rtree query API. (check-in: 44188b09f0 user: dan tags: trunk)
13:20
Merge fixes from the 3.36 branch into trunk. (check-in: 5c9ed197fb user: drh tags: trunk)
13:12
Do not try to index the context of <svg> markup for search. (check-in: 4e9e946291 user: drh tags: branch-3.36)
2021-09-28
17:15
Clarify use of xInverse method for windows functions (check-in: 7d1d0f2166 user: larrybr tags: trunk)
2021-09-27
23:42
Improve note on STRICT and de-nit ALTER TABLE overview (check-in: ab3009fd7c user: larrybr tags: trunk)
2021-09-24
23:48
Update the change log and the pragma documentation for the new table_list pragma. (check-in: 21477e3b60 user: drh tags: trunk)
00:28
Correct over-lenient delete ... order by limit syntax diagram. (Per https://sqlite.org/forum/forumpost/35b89409e5 ) (check-in: 0ab7d5fa06 user: larrybr tags: trunk)
2021-09-17
17:52
Add a section to the WITHOUT ROWID documentation that explains how to use the PRAGMA index_info command to distinguish between ordinary tables and WITHOUT ROWID tables. (check-in: 91c83c24c4 user: drh tags: trunk)
11:52
Add new requirement marks to the STRICT table documentation. Also fix a typo there. (check-in: 992b5d7660 user: drh tags: trunk)
2021-09-16
18:05
Correct a single requirement in the RTREE documentation. (check-in: 70af09cf7e user: drh tags: trunk)
2021-09-14
19:55
Typo fix in rtree documentation. (check-in: 13e88e4693 user: drh tags: trunk)
19:16
Fix some busted requirements marks in the EXPR documentation. Add the 64() suffix to sqlite3_changes and sqlite3_total_changes() in the SQL core function documentation. (check-in: a9ef8137bd user: drh tags: trunk)
18:27
RTree documentation fixes. (check-in: c2fe6c397b user: drh tags: trunk)
11:16
Scan ext/rtree/*.test for "evidence" marks. (check-in: 184fb42b4f user: dan tags: trunk)