Documentation Source Text

Timeline
Login

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

50 most recent check-ins

2026-07-31
15:50
Updates to the change log for 3.54.0 (leaf check-in: d3dc85cf7a user: drh tags: trunk)
15:18
Merge the latest branch-3.53 changes into trunk. (check-in: 2880353c76 user: drh tags: trunk)
2026-07-29
07:40
Typo fix reported in [forum:f97f26bad3]. (leaf check-in: bb3ac9b25a user: stephan tags: branch-3.53)
2026-07-24
19:08
Version 3.53.4 (check-in: 2091e16d3e user: drh tags: branch-3.53)
18:47
Preliminary changes for the 3.53.4 patch release (check-in: 3cc73fde61 user: drh tags: branch-3.53)
2026-07-12
22:22
More refinements to flextypegood.html (check-in: 4d2fe1799b user: drh tags: trunk)
10:22
Further updates to the flextypegood document. (check-in: 90176578df user: drh tags: trunk)
09:27
Add a pointed comment to flextypegood.html stating plainly that I have seen no evidence in support of rigid typing. (check-in: 7023f77d7d user: drh tags: trunk)
09:22
Enhancements to flextypegood.in (check-in: bc9a22568d user: drh tags: trunk)
2026-07-11
15:07
Improvements to the change log entries for date/time functions and to the date/time function documentation. (check-in: 280ab20e1a user: drh tags: trunk)
2026-07-10
16:44
Documentation for SQLITE_LIMIT_SCHEMA. (check-in: b5ae74cd4b user: drh tags: trunk)
2026-07-09
10:37
Clarify the change log (check-in: abb25d92c2 user: drh tags: trunk)
2026-07-08
15:53
Updates to the change log to talk about "--titles always" now being the default behavior in the CLI. (check-in: 6f06155ab0 user: drh tags: trunk)
2026-07-01
19:02
Updates to the 3.54.0 change log and related documentation. (check-in: 28c206373e user: drh tags: trunk)
12:12
Update documentation of date/time functions for the new "weekday -N" and "end of day/month/year" modifiers. (check-in: 4b531a5f93 user: drh tags: trunk)
11:31
Merge branch-3.53 changes into trunk (check-in: 01ea4f4533 user: drh tags: trunk)
11:29
Documentation of recent date/time function enhancements. (closed check-in: 93cace3bc2 user: drh tags: prev-weekday)
2026-06-26
20:21
Version 3.53.3 (check-in: 34f17f63f0 user: drh tags: branch-3.53)
2026-06-24
22:13
Update the CVE listings with CVE-2026-11822 and CVE-2026-11824. (check-in: d7c3061100 user: drh tags: branch-3.53)
09:51
In the json_quote() documentation, fix example output (Forum 2026-06-24T09:38:57Z) and put json_quote() in the correct (alphabetical) order in the index at the top of the page. (check-in: 1fdb16fa11 user: drh tags: branch-3.53)
2026-06-22
11:18
Enhancements to the json_group_array() and json_group_object() documentation. Forum 2026-06-19T14:56:56Z. (check-in: af93a707ae user: drh tags: branch-3.53)
2026-06-20
11:43
Replace a dead external link to strftime(), as reported in [forum:bc3e6a2f9a|forum post bc3e6a2f9a]. (check-in: d75b738864 user: stephan tags: branch-3.53)
2026-06-19
23:57
Add sqlite3_result_str() to the change log. (check-in: 322cd99dad user: drh tags: trunk)
2026-06-16
13:46
New note on the importants of reasonable limits for LIMIT_EXPR_DEPTH and LIMIT_TRIGGER_DEPTH. (check-in: 4069d9d0c9 user: drh tags: branch-3.53)
2026-06-13
15:05
Include mentions of the PRAGMA case_sensitive_like statement in the stale expression indexes documentation. (check-in: 7f680aaf93 user: drh tags: trunk)
2026-06-04
01:35
Merge the latest branch-3.53 changes into trunk. (check-in: f55ea6581d user: drh tags: trunk)
2026-06-03
19:15
Version 3.53.2 (check-in: 91f016cc05 user: drh tags: branch-3.53, version-3.53.2)
17:23
Document that ALTER TABLE ALTER COLUMN DROP NOT NULL removes at least one but no necessarily all NOT NULL constraints from the column. [bugs:/info/2026-05-27T14:43:36Z|Bug 2026-05-27T14:43:36Z]. (check-in: eb89f278c8 user: drh tags: branch-3.53)
2026-05-29
15:17
Update documentation due to the name changes for the diskused() extension and the .diskused dot-command. (check-in: 81171be73f user: drh tags: trunk)
14:19
Add documentation for the analyze() extension function. Mark sqlite3_analyzer as deprecated. (check-in: 236d2fa299 user: drh tags: trunk)
13:28
Minor tweaks to the 3.54.0 change log. (check-in: 4102b95f30 user: drh tags: trunk)
13:01
Updates to the archive sections of the CLI documentation (check-in: b22ba50dfe user: drh tags: trunk)
2026-05-21
16:39
Documentation updates for "PRAGMA defer_foreign_keys" in response to [bugs:/forumpost/c6bf0db6fa|Bug c6bf0db6fa]. (check-in: a4e6c0effc user: drh tags: branch-3.53)
2026-05-20
11:35
Merge recent documentation fixes and enhancements from branch-3.53 into trunk. (check-in: fcb909d221 user: drh tags: trunk)
2026-05-19
17:52
Update documentation to explain that non-deterministic functions are allowed in CHECK constraints due to an historical accident and that the behavior of such constructs is not guaranteed, as long as they do not result in a crash. [bugs:/forumpost/f39a2a2ae7|Bug report f39a2a2ae7] (check-in: 0ac9f7c04f user: drh tags: branch-3.53)
17:18
Update the documentation of the -> and ->> operators for JSON to make it clear the the RHS must either be a full PATH or a number of an alphanumeric text object label. [bugs:/forumpost/a5a024f2b6|Bug report a5a024f2b6]. (check-in: 6e7a48aa55 user: drh tags: branch-3.53)
2026-05-18
20:00
Enhance the JSON documentation to state that the "json" and "root" hidden parameters to json_each() are for constraints only and do not provide reliable results when read. (check-in: 2a34448f5c user: drh tags: branch-3.53)
18:15
Add the "Quirks" subsection to the JSON documentation. (check-in: b9382d3f9b user: drh tags: branch-3.53)
14:37
Fix a typo in the JSON SQL function documentation. (check-in: 15ae100854 user: drh tags: branch-3.53)
2026-05-14
19:13
Fix documentation of the decimal_sum() extension function. Forum post 567e70d078. (check-in: 326545931b user: drh tags: branch-3.53)
15:13
Additional documentation about the generated-column xfer-optimization quirk. (check-in: fb956a415d user: drh tags: trunk)
15:06
Enhancements to the INSERT documentation. (check-in: 89b2adbf07 user: drh tags: trunk)
2026-05-11
19:19
Merge recent branch-3.53 fixes into trunk. (check-in: f4571b803e user: drh tags: trunk)
19:19
Refinements to the new xfer-optimization text. (check-in: d66988d5ce user: drh tags: trunk)
19:09
Add notes about the xfer-optimization to the INSERT documentation page. (check-in: ce17829907 user: drh tags: trunk)
18:45
Information about CVE-2025-70873. (check-in: 272c04c2d8 user: drh tags: branch-3.53)
2026-05-07
15:07
Update with %J and %j changes to printf(), and the latest bug fixes from branch-3.53. (check-in: bb1ac84f0f user: drh tags: trunk)
09:25
More typo fixes (closed check-in: 2b182e6fc9 user: drh tags: format-json)
09:19
Fix incorrect fragment identifier. (check-in: 37e6d6d519 user: drh tags: format-json)
09:14
Documentation for the new %J and %j conversions (check-in: a8040c570b user: drh tags: format-json)