Documentation Source Text

Timeline
Login

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

103 check-ins using file misc/speed-size-graph.ods version b187eb3744

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)
2021-09-13
23:15
New requirements marks in rtree. (check-in: 50c0dfb34c user: drh tags: trunk)
23:06
Continuing improvement to the rtree documentation. (check-in: b253cfff16 user: drh tags: trunk)
19:22
New sample data for illustrating RTREE concepts. (check-in: 8b0f880b08 user: drh tags: trunk)
14:45
Minor fixes to the rtree documentation. (check-in: 39d61b00a3 user: drh tags: trunk)
12:01
Simplifications to the STRICT documentation. (check-in: 71c6908056 user: drh tags: trunk)
11:28
Remove three arguments about why SQLite is not coded in Rust or Go from the "whyc.html" document. (check-in: 74c43386e3 user: drh tags: branch-3.36)
2021-09-10
20:38
Documentation tweaks for RTREE and STRICT tables. Add many requirements marks to RTREE. (check-in: 9f2bb99cd2 user: drh tags: trunk)
2021-09-09
12:53
Update the CVE list with a new CVE that mentions SQLite but has nothing to do with SQLite. (check-in: e972ac344f user: drh tags: branch-3.36)
2021-09-08
19:01
Another typo fix - this time in datatype3.html. (check-in: 1d20e141ec user: drh tags: trunk)
18:52
Fix typo in the STRICT documentation. (check-in: 9f82e552fd user: drh tags: trunk)
2021-09-07
19:28
Clarify schema comparisons for sqldiff. Mention (new) --table sqlite_schema option. (check-in: 16ae2db841 user: larrybr tags: trunk)
2021-08-25
23:23
Change the cves.html document due to the fact that a correction and clarification to CVE-2021-36690 was received and implemented. (check-in: 78013d22aa user: drh tags: branch-3.36)
2021-08-24
21:13
Rename and tweak the "Advantages of Flexible Typing" document. (check-in: 6d8f3f7ffb user: drh tags: trunk)
19:48
Add CVE-2021-36690 to the list. (check-in: 0c07b234f9 user: drh tags: branch-3.36)
19:00
More improvements to datatype documentation. (check-in: d574ce1f35 user: drh tags: trunk)
14:31
First draft of a document defending flexible typing against its critics. (check-in: de16ee6a9e user: drh tags: trunk)
2021-08-23
10:35
Typo fixes. (check-in: c8e3641fb4 user: drh tags: trunk)
2021-08-22
22:48
Proposed new definition of STRICT tables. (check-in: 26a4727f29 user: drh tags: trunk)
2021-08-21
21:04
Fix a typo in the lemon.html documentation page. (check-in: 7d8e36e6eb user: drh tags: branch-3.36)
20:50
De-typo in Lemon doc (check-in: afc57c1161 user: larrybr tags: trunk)
2021-08-20
15:48
Initial documentation for STRICT tables. (check-in: a62eba124d user: drh tags: trunk)
15:27
First bits of documentation about STRICT tables. (Closed-Leaf check-in: 0b842e6e48 user: drh tags: strict-tables)
00:18
Document new STRICT table option (check-in: e668c1ce28 user: larrybr tags: strict-tables)
2021-08-12
10:50
Fix some grammar issues in fts5.in. (check-in: 053c63ecc5 user: dan tags: trunk)
2021-08-11
16:12
Further enhancements to fts5 shadow table data format documentation. (check-in: c5d7ec9a1d user: dan tags: trunk)
2021-08-10
21:18
Further enhancements for fts5 documentation. (check-in: 05ad966e28 user: dan tags: trunk)
2021-08-09
22:00
Begin documenting the fts5 on-disk format. (check-in: 018ff48a67 user: dan tags: trunk)
2021-08-06
22:22
Enhanced SELECT documentation: State explicitly that the value of a bare column in an aggregate query with no input rows is arbitrary. (check-in: cf8be0cd71 user: drh tags: trunk)
2021-08-01
21:40
For .expert command, indicate how to deal with schema using extension functions. (check-in: f1c94aeb9c user: larrybr tags: trunk)
2021-07-30
22:55
Address wee language nits in sqlite3_snprintf() history explication (check-in: f43c4eb1f1 user: larrybr tags: trunk)
2021-07-27
23:51
Bring FAQ on ALTER TABLE up to date (check-in: 9ea300daac user: larrybr tags: trunk)
2021-07-21
12:08
Update the ALTER TABLE ADD COLUMN documentation to discuss its new behavior of verifying CHECK and NOT NULL constraints against preexisting rows. (check-in: 3f4ef35f32 user: drh tags: trunk)
11:50
Add the change log for version 3.37.0. (check-in: ae09c6cd46 user: drh tags: trunk)
2021-07-19
17:02
For the download.html page, add the set the variable LAST_MAJOR_RELEASE directly. We'll have to change this manually with each release. (check-in: 759479fcf6 user: drh tags: trunk)
16:49
Improvements to the documentation on how to enforce required parameters to table-valued functions using SQLITE_ERROR returns from xBestIndex. (check-in: 234ddab3ec user: drh tags: trunk)
16:45
Improvements to the description of how to get good error messages out of xBestIndex for required table-valued function parameters. (Leaf check-in: f6864997ba user: drh tags: xbestindex-errors)
16:44
More precision in the description of operator precedence in the lang_expr.html page. (check-in: faee65e4fa user: drh tags: trunk)
16:36
Minor formatting enhancements to the new precedence description in the Expression documentation. (Closed-Leaf check-in: 43247e25e1 user: drh tags: operator_traits)
16:18
In operators table, colorize (as before). Zap a bad footnote ref. (check-in: 62be0ee30f user: larrybr tags: operator_traits)
02:08
Merge operator precedence/associativity clarifications/additions instigated by forum thread https://sqlite.org/forum/forumpost/b9902fe09a . (check-in: 5b3ed74e59 user: larrybr tags: trunk)
01:58
Op-prec partly reverted to get linkage working. (To be made more organized and coherent later.) (check-in: 11e0ea3d16 user: larrybr tags: operator_traits)
00:03
Operator precedence done, text revised to match, but 5 links broken. (check-in: bd8fb1f74f user: larrybr tags: operator_traits)
2021-07-18
17:27
In big expr railroad chart, make only LIKE get an ESCAPE clause. (check-in: 6fa8195610 user: larrybr tags: trunk)
01:27
reorg operator precedence/associativity/aryness, and for more of them (check-in: 71f8627b5c user: larrybr tags: operator_traits)
2021-07-16
17:20
Update the generate_series() documentation to show that the first argument is now required. Enhance the virtual-table documentation to explain in detail how to construct an xBestIndex method that forces some arguments to a table-valued function to be required. (check-in: 3008d3fbc2 user: drh tags: trunk)
2021-07-15
16:18
Revise TCL integration. (cleaner) Prepare for tool and extension detail doc. (Leaf check-in: b6057aff5f user: larrybr tags: cli_extension)
04:48
More on TCL, both as extension and another execution option. (check-in: 1fadb0c3ad user: larrybr tags: cli_extension)
2021-07-14
20:57
Create predecssor of shell extensibility doc. (check-in: a01e599239 user: larrybr tags: cli_extension)
01:18
Restore accidental delete of deprecated compile option. (check-in: 97db38da0c user: larrybr tags: trunk)
01:11
Correct ancient typo, correct interface function macro exclusiveness assertion (check-in: 3341553596 user: larrybr tags: trunk)
00:33
Update 'Compiler ... Control' section in 'Compile-time Options' (check-in: 466497f575 user: larrybr tags: trunk)
2021-07-05
12:14
Add the word "the" into the title "defense against the dark arts". (check-in: 5b06972cc9 user: drh tags: trunk)
2021-06-30
19:14
Revise HTLM comment CSV table and document it. (check-in: 6260f34689 user: larrybr tags: trunk)
2021-06-28
22:32
Shed extranous div close tag. (check-in: eec2c7dec4 user: larrybr tags: trunk)
2021-06-26
21:20
Add an HTML comment to the download.html page that is easy for scripts to read and extract build product names and metadata. (check-in: a5c082a634 user: drh tags: trunk)
2021-06-23
17:42
Document SQLITE_ENABLE_NORMALIZED option. (check-in: 49eb960b86 user: larrybr tags: trunk)
2021-06-21
04:46
Conform sqlite_parameters schema to implementation. (check-in: 458aa9aa0a user: larrybr tags: trunk)
03:17
Correct name of lsmode() (check-in: 500fb25afc user: larrybr tags: trunk)
2021-06-18
18:45
Version 3.36.0 (check-in: 1207f6c70f user: drh tags: trunk, release, version-3.36.0)
18:34
Add a news item for the 3.36.0 release. (check-in: bcdc3680a5 user: drh tags: trunk)
13:44
Merge the wapp.tcl fix. (check-in: dd65eef797 user: drh tags: trunk)
2021-06-17
22:41
Update the speed and size spreedsheet. (check-in: 4b2bf80ec6 user: drh tags: trunk)