Documentation Source Text

Timeline
Login

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

50 most recent check-ins

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. (Leaf 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. (Leaf 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)