SQLite Forum

Possible doc typos for upcoming release

Possible doc typos for upcoming release

(1) By Donald Griggs (dfgriggs) on 2022-01-12 17:01:27 [source]


I've bolded 3 words that may need attention.

The 'auto' modifier can be used to work with date/time values even in cases where it is not know if the julian day number of unix timestamp formats are in use. The 'auto' modifier will automatically select the appropriate format. However, there is a region of ambiguity. Unix timestamps for the first 63 days of 1970 will be interpreted as julian day numbers. The 'auto' modifier is very useful is the dataset is guaranteed to not contain any dates within that region, but should be avoided for applications that might make use of dates in the opening months of 1970.

Thanks as always for the work y'all do. Donald

(2) By Donald Griggs (dfgriggs) on 2022-01-12 18:17:49 in reply to 1 [link] [source]

More possible typos.


An argument with SQL type TEXT it is normally converted into a quoted JSON string even if the input text is well-formed JSON.

4.10. The json_type() function

The json_type(X) function returns the "type" of the outermost element of X. The json_type(X,P) function returns the "type" of the element in X that is selected by path P. The "type" returned by json_type() is one of the following an SQL text values: 'null', 'true', 'false', 'integer', 'real', 'text', 'array', or 'object'.

[The words "array" and "object" are capitalized in section 4.8. Maybe intentional?]

4.8. The json_patch() function The json_patch(T,P) SQL function runs the RFC-7396 MergePatch algorithm to apply patch P against input T. The patched copy of T is returned.

MergePatch can add, modify, or delete elements of a JSON Object, and so for JSON Objects, the json_patch() routine is a generalized replacement for json_set() and json_remove(). However, MergePatch treats JSON Array objects as atomic. MergePatch cannot append to an Array nor modify individual elements of an Array. It can only insert, replace, or delete the whole Array as a single unit. Hence, json_patch() is not as useful when dealing with JSON that includes Arrays, especially Arrays with lots of substructure.

(3) By Larry Brasfield (larrybr) on 2022-01-12 20:51:26 in reply to 2 [link] [source]

Your spelling/grammar pickups have been remedied. Thanks.

Regarding capitalized names: The terms Object and Array are from the JSON spec, and refer to a specific concept rather than carrying only their ordinary meaning. I don't know if they are properly proper nouns in the strictest grammatical sense, but they are close enough that we can borrow the capitalization convention for them. (We strive for clarity rather than worrying about the grammar police! (I to not imply that you are one of those.;-) )