Documentation Source Text

All files named "pages/json1.in"
Login

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

History for pages/json1.in

2024-02-25
16:48
[c839483891] part of check-in [dc18e48b7a] Typo fixes in json1.in reported in the forum. (check-in: [dc18e48b7a] user: stephan branch: trunk, size: 48758)
16:46
[266c9919e5] part of check-in [f69258e1a6] Fix typos in JSON document, as pointed out on the forum. (check-in: [f69258e1a6] user: drh branch: branch-3.45, size: 50095)
2024-01-30
13:53
[13fdbe9499] part of check-in [f7e27bf3ff] Updates to news and change log for the 3.45.1 release. (check-in: [f7e27bf3ff] user: drh branch: branch-3.45, size: 50100)
2024-01-24
11:29
[238b344ee9] part of check-in [e8dccbef95] Improvements to the JSON BLOB input bug documentation. (check-in: [e8dccbef95] user: drh branch: branch-3.45, size: 49734)
11:20
[28e1bb14f5] part of check-in [09820fbd5a] Documentation for the JSON BLOB input bug. (check-in: [09820fbd5a] user: drh branch: branch-3.45, size: 49679)
2024-01-21
18:05
[1dae3111f7] part of check-in [256a6e16f5] Fix typos in the JSON documentation. (check-in: [256a6e16f5] user: drh branch: branch-3.45, size: 48759)
2024-01-15
16:38
[4265c63dfb] part of check-in [6be2bb0eca] Fix documentation typos. (check-in: [6be2bb0eca] user: drh branch: trunk, size: 48762)
2024-01-09
20:59
[155a61aacf] part of check-in [01061bb92b] Merge typo fixes from branch-3.44 (check-in: [01061bb92b] user: drh branch: trunk, size: 48761)
2023-12-22
00:30
[54a15f0ac1] part of check-in [d6ad496d9a] Fix typo in json documentation. (check-in: [d6ad496d9a] user: drh branch: trunk, size: 48765)
2023-12-21
18:54
[0671cc26de] part of check-in [035da7a439] More refinements to the JSONB documentation. (check-in: [035da7a439] user: drh branch: trunk, size: 48763)
18:44
[66f0759b06] part of check-in [3bfd93c03c] Further backing off of JSONB formatting details. Go full-in on calling it just an SQLite internal parse-tree format. (check-in: [3bfd93c03c] user: drh branch: trunk, size: 48921)
18:08
[0f86bc6b50] part of check-in [95010ca778] Undocument the JSONB format. Application developers should not know what the internal design of JSONB looks like. JSONB should be just a proprietary internal data structure for SQLite. (check-in: [95010ca778] user: drh branch: trunk, size: 48826)
15:28
[6cfffd2bfc] part of check-in [d7107682a0] Minor clarifications and typo fixes in the JSON documentation. (check-in: [d7107682a0] user: drh branch: trunk, size: 49813)
2023-12-16
21:28
[620029509b] part of check-in [275938caa9] Enhancements to JSON documentation. (check-in: [275938caa9] user: drh branch: trunk, size: 49779)
15:16
[f45694c6c9] part of check-in [df2e20f27b] Fix typos in JSON function documentation. (check-in: [df2e20f27b] user: drh branch: trunk, size: 48803)
2023-12-13
14:27
[f3ab0d6254] part of check-in [8b9039994b] Updates to JSON documentation. (check-in: [8b9039994b] user: drh branch: trunk, size: 48802)
2023-12-05
16:07
[0bb5532263] part of check-in [f6fad8006b] Further tweaks for the JSONB documentation. (check-in: [f6fad8006b] user: drh branch: jsonb, size: 49129)
15:39
[cb6d25c91c] part of check-in [83e6af3514] Updates to JSONB documentation. (check-in: [83e6af3514] user: drh branch: jsonb, size: 49105)
14:43
[8328a77315] part of check-in [3b673fad86] Merge the latest trunk changes into the jsonb branch. Update with the latest documentation about JSONB. (check-in: [3b673fad86] user: drh branch: jsonb, size: 48076)
2023-10-24
18:03
[c5142f6962] part of check-in [908071d8d5] New text and hyperlinks associated with aggregate ORDER BY. (check-in: [908071d8d5] user: drh branch: trunk, size: 38504)
2023-10-12
11:46
[d7523ec0e3] part of check-in [e95f7ea68f] Further clarification of JSONB and typo fixes. (check-in: [e95f7ea68f] user: drh branch: jsonb, size: 45792)
11:40
[fa6a4626a1] part of check-in [3f84dd678e] Further clarification to what JSONB is and why it is useful. (check-in: [3f84dd678e] user: drh branch: jsonb, size: 45757)
2023-10-11
16:07
[7707d47f32] part of check-in [0ae7f4829c] Further enhancements to the JSONB documentation to help clarify its design and purpose. (check-in: [0ae7f4829c] user: drh branch: jsonb, size: 44880)
10:57
[db9b7190ae] part of check-in [be93ea1043] Enhancements to the JSONB documentation in response to feedback. (check-in: [be93ea1043] user: drh branch: jsonb, size: 44342)
2023-10-02
18:57
[616dc4d89d] part of check-in [943ec0eecd] Fix the spelling of PostgreSQL. (check-in: [943ec0eecd] user: drh branch: jsonb, size: 44340)
18:51
[5132242051] part of check-in [686b8716f9] Initial cut attempt at JSONB documentation. (check-in: [686b8716f9] user: drh branch: jsonb, size: 44339)
2023-08-11
20:15
[187461972b] part of check-in [83c1de26ae] Be explicit that json_valid() returns NULL on a NULL input. (check-in: [83c1de26ae] user: drh branch: trunk, size: 38501)
2023-08-01
17:34
[f2d9d092d1] part of check-in [abce4ae7d0] New examples of using the -> and ->> operators. (check-in: [abce4ae7d0] user: drh branch: trunk, size: 38473)
2023-07-19
19:13
[a44b7f6ad2] part of check-in [561c0607e9] Lower the performance estimate for JSON parsing to a more conservative 250 MB/s, which is a number we can easily meet. I'm not sure where the 1 GB/s figure came from. (check-in: [561c0607e9] user: drh branch: branch-3.42, size: 38362)
2023-05-12
17:36
[3494398b57] part of check-in [6d15d8641c] Typos fixed and phrasing improved for the new JSON documentation. (check-in: [6d15d8641c] user: drh branch: trunk, size: 38360)
2023-05-08
20:17
[0577d56f74] part of check-in [43d43a2b97] Fix a typo in JSON documentation. (check-in: [43d43a2b97] user: drh branch: trunk, size: 38361)
17:45
[237af42241] part of check-in [6908866970] Additional clarification to the JSON5 enhancement documentation. (check-in: [6908866970] user: drh branch: trunk, size: 38364)
2023-05-05
15:49
[63d20320be] part of check-in [9a65bdf937] Reduce the JSON maximum nesting depth to 1000. (check-in: [9a65bdf937] user: drh branch: trunk, size: 38203)
2023-05-03
18:38
[ea45b70f49] part of check-in [9fe07cb0bd] Minor enhancements to the JSON documentation. (check-in: [9fe07cb0bd] user: drh branch: trunk, size: 38203)
2023-05-02
17:03
[e772f80b50] part of check-in [e6a4cea8fe] Add sqlite3_sleep() change to the change log. Fix typo in JSON docs. (check-in: [e6a4cea8fe] user: drh branch: trunk, size: 38049)
2023-05-01
18:27
[03087a9d36] part of check-in [844b3af7fe] More documentation tweaks in preparation for the 3.42.0. (check-in: [844b3af7fe] user: drh branch: trunk, size: 38052)
17:02
[47c3db08fe] part of check-in [f77ffdbd60] Documentation of the JSON5 enhancement. (check-in: [f77ffdbd60] user: drh branch: trunk, size: 38051)
2023-04-04
23:20
[c5ff232c49] part of check-in [92d830ab0e] Express that last JSON fact absent perplexing repetition. (check-in: [92d830ab0e] user: larrybr branch: trunk, size: 33539)
23:16
[530d2f2f2d] part of check-in [a572bb5a9f] Mention absence of special treatment for Unicode escape sequences in JSON functions. (check-in: [a572bb5a9f] user: larrybr branch: trunk, size: 33541)
2023-02-15
20:50
[d03a37020b] part of check-in [7962d5cbe2] Minor json_quote() typo fix reported in the forum. (check-in: [7962d5cbe2] user: stephan branch: trunk, size: 33203)
2023-01-21
23:07
[fe31b7a147] part of check-in [7f680aab5f] Typo fixes in JSON documentation. (check-in: [7f680aab5f] user: drh branch: trunk, size: 33203)
14:42
[652d36bf70] part of check-in [82435642b2] Fix subject-verb agreement in one sentence in the JSON documentation. (check-in: [82435642b2] user: drh branch: trunk, size: 33203)
2022-06-24
16:56
[a3a9437254] part of check-in [b4f619f6b0] Fixes to the json_quote() documentation. (check-in: [b4f619f6b0] user: drh branch: trunk, size: 33216)
2022-04-19
12:59
[20fc2d66fe] part of check-in [85cf758980] Typo fix in JSON doc. (check-in: [85cf758980] user: larrybr branch: trunk, size: 33154)
2022-03-27
00:22
[ccb372641f] part of check-in [9784cacc48] Fix incorrect use of NULL instead of null in JSON function docs. (check-in: [9784cacc48] user: drh branch: branch-3.38, size: 33153)
2022-02-23
09:40
[b4ac357bee] part of check-in [5d05643c80] Fix json examples as noted in forum (https://sqlite.org/forum/forumpost/f783a3f65a) (check-in: [5d05643c80] user: larrybr branch: trunk, size: 33153)
2022-02-09
13:46
[8235e071fa] part of check-in [7c47d9cb0c] Minor tweaks to the JSON documentation. (check-in: [7c47d9cb0c] user: drh branch: trunk, size: 33160)
2022-01-20
23:31
[b079351105] part of check-in [921013da18] Grammar improvements where noted by https://sqlite.org/forum/forumpost/6712173dd2 (check-in: [921013da18] user: drh branch: branch-3.37, size: 29949)
21:38
[d7e9418e25] part of check-in [96d1781d44] Grammar improvements where noted by https://sqlite.org/forum/forumpost/6712173dd2 (check-in: [96d1781d44] user: larrybr branch: trunk, size: 32750)
2022-01-12
20:46
[8c49dc829e] part of check-in [f04d4fdb9b] Minor grammar fix for JSON functions doc (check-in: [f04d4fdb9b] user: larrybr branch: trunk, size: 32753)
2022-01-11
14:09
[fafa6da83d] part of check-in [f688a6b35c] Update JSON documentation for the addition of the -> and ->> operators and because JSON functions are moved into the core. (check-in: [f688a6b35c] user: drh branch: json-in-core, size: 32756)
12:26
[8299bd2072] part of check-in [cff708dfef] Enhance the documentation of json_extract() to point out the difference in behavior compared to MySQL. (check-in: [cff708dfef] user: drh branch: branch-3.37, size: 29952)
2022-01-07
01:10
[fda8b07bc1] part of check-in [6757f3c805] Fix a minor typo in the JSON function documentation. (check-in: [6757f3c805] user: drh branch: trunk, size: 28773)
2020-09-14
11:04
[4e0ce56f67] part of check-in [3d6dfc9933] Two more typo fixes. (check-in: [3d6dfc9933] user: drh branch: branch-3.33, size: 28773)
11:00
[9d5821b904] part of check-in [21a593daf3] Fix typo in Json documentation. (check-in: [21a593daf3] user: drh branch: branch-3.33, size: 28781)
2020-04-06
18:59
[eaad7af484] part of check-in [de7905fcbb] Fix various minor HTML coding errors pointed out by Gisbert on the forum. (check-in: [de7905fcbb] user: drh branch: branch-3.31, size: 28782)
2020-04-01
19:40
[0019050248] part of check-in [e754041fb1] Fix a typo in the JSON1 documentation. (check-in: [e754041fb1] user: drh branch: branch-3.31, size: 28780)
2020-03-30
14:22
[b15a3ed39a] part of check-in [a9b40f21bb] Fix typo in the JSON documentation. (check-in: [a9b40f21bb] user: drh branch: branch-3.31, size: 28779)
2019-11-23
00:22
[20e5c73041] part of check-in [604ac8689d] Documentation updates for new features. (check-in: [604ac8689d] user: drh branch: trunk, size: 28778)
2019-03-01
13:27
[f6a2f69966] part of check-in [393a3d19ae] Update the JSON parsing speed in the json1.html documentation. (check-in: [393a3d19ae] user: drh branch: branch-3.27, size: 27776)
2018-09-21
10:16
[5c0d9d9a86] part of check-in [2bdb2d7e21] Fix a harmless typo in the json documentation. (check-in: [2bdb2d7e21] user: drh branch: trunk, size: 27778)
2018-09-19
11:04
[a48a8ccd66] part of check-in [7eef7f4c93] Fix a typo in the JSON extension documentation. (check-in: [7eef7f4c93] user: drh branch: trunk, size: 27801)
2018-09-14
17:42
[73c5064cd4] part of check-in [c68e153fc6] Fix minor typos detected by the spell checker. (check-in: [c68e153fc6] user: drh branch: trunk, size: 27801)
2017-11-05
22:22
[2ac41705ca] part of check-in [0d9fba9226] On the JSON1 documentation, make sure all arguments in the Overview section are italicized. (check-in: [0d9fba9226] user: drh branch: branch-3.21, size: 27807)
2017-04-11
19:15
[5325220c02] part of check-in [0bcdcaff9c] Update the JSON1 documentation to state the 2000-level limit on recursion. (check-in: [0bcdcaff9c] user: drh branch: trunk, size: 27799)
2017-04-08
11:38
[1c058364be] part of check-in [16bd995f65] Clarify what it means when it says "JSON1 is not available by default." (check-in: [16bd995f65] user: drh branch: trunk, size: 27439)
2017-03-23
23:45
[6b82df0fc2] part of check-in [3c4519094f] Add documentation for the json_patch() SQL function. (check-in: [3c4519094f] user: drh branch: trunk, size: 27247)
2016-09-14
18:40
[d7062f7926] part of check-in [858d993381] Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: [858d993381] user: drh branch: trunk, size: 25825)
2016-09-01
15:15
[96fe67d4f1] part of check-in [08908c99e5] Simplify the JSON documentation for better display on mobile. (check-in: [08908c99e5] user: drh branch: mobile-friendly, size: 25828)
2016-07-23
21:45
[03175eef67] part of check-in [d0a0b0987f] Tweaks to the JSON extension docs. (check-in: [d0a0b0987f] user: drh branch: trunk, size: 26134)
19:42
[2b8d3e0d6f] part of check-in [3506feb7c7] Add documentation for the json_quote() SQL function. Updates to the change log. (check-in: [3506feb7c7] user: drh branch: trunk, size: 26201)
2016-01-06
11:05
[12715f3528] part of check-in [ecbe9a0cbc] Add the "News" for the 3.10.0 release and fix some typos. Add hashes and correct dates to the change log. (check-in: [ecbe9a0cbc] user: drh branch: trunk, size: 25799)
2015-12-31
14:06
[9449189e02] part of check-in [5077172640] Update the change log with the latest enhancements. (check-in: [5077172640] user: drh branch: bubble-generator-tkpath, size: 25799)
2015-10-12
05:51
[950350d208] part of check-in [1c92bfea70] More documentation updates for 3.9.0. (check-in: [1c92bfea70] user: drh branch: trunk, size: 24808)
2015-10-09
14:45
[5500eafebf] part of check-in [d9e14a871b] Further updates in support of 3.9.0. Mark FTS5 has being officially released. (check-in: [d9e14a871b] user: drh branch: trunk, size: 25548)
2015-10-08
00:21
[aa9c0c8261] part of check-in [543413f753] Minor English grammar changes. (check-in: [543413f753] user: drh branch: trunk, size: 25527)
2015-10-07
22:42
[9bd28be7bb] part of check-in [255ed0fac7] Fix a couple typos in the new docs. (check-in: [255ed0fac7] user: mistachkin branch: trunk, size: 25525)
15:30
[31c43c2ef9] part of check-in [de0fb99b82] Add a fragment for "howtocompile" in the JSON1 documentation. (check-in: [de0fb99b82] user: drh branch: trunk, size: 25523)
2015-09-15
12:37
[4d878ca5ac] part of check-in [833012c6a9] Fix a typo in the JSON documentation. (check-in: [833012c6a9] user: drh branch: trunk, size: 25487)
2015-09-11
16:14
[ddd7a7bc6a] part of check-in [af1be7762c] Minor updates to json1 and table-valued function documentation. (check-in: [af1be7762c] user: drh branch: trunk, size: 25490)
15:36
[4387989984] part of check-in [854fe12156] Still more typo corrections and clarification for the json1 documentation. (check-in: [854fe12156] user: drh branch: trunk, size: 25526)
15:23
[959315d191] part of check-in [51f0e6c448] Fix typos, improve wording, and add more examples to the json1 documentation. (check-in: [51f0e6c448] user: drh branch: trunk, size: 25321)
01:22
[df38681f49] part of check-in [ad30053732] Update the json1 documentation to reflect the recent changes that make use of subtype to avoid the '$$' goofiness, and the addition of the json() function. (check-in: [ad30053732] user: drh branch: trunk, size: 23315)
2015-09-10
19:27
[b09e2b7b9a] part of check-in [02e2ca3d77] Fix another typo in the json1 documentation. (check-in: [02e2ca3d77] user: drh branch: trunk, size: 22665)
18:51
[f38246f830] part of check-in [0fcd73bb5a] Fix another typo in the json1 documentation. (check-in: [0fcd73bb5a] user: drh branch: trunk, size: 22663)
18:21
[6bdee02c7b] part of check-in [aafe027cf0] Add a how-to-compile section to the json1 documentation. And fix many typos. (check-in: [aafe027cf0] user: drh branch: trunk, size: 22662)
17:21
[f2eed25180] part of check-in [5cc19499aa] Update the json1 documentation to describe the new "path" column of json_tree(). (check-in: [5cc19499aa] user: drh branch: trunk, size: 21292)
03:43
[ad82d3adf1] part of check-in [4793854de9] Improvements and clarification for the json1 documentation. (check-in: [4793854de9] user: drh branch: trunk, size: 20982)
2015-09-09
20:26
[85d34db1c1] part of check-in [e5c50d4f24] Typo fixes in the examples of the json1 document. (check-in: [e5c50d4f24] user: drh branch: trunk, size: 20551)
19:01
[2c066f2865] part of check-in [bc16b0015f] Add examples to the json1 documentation. (check-in: [bc16b0015f] user: drh branch: trunk, size: 20337)
02:06
[7356c58fe5] part of check-in [57b4eafa71] Fix a typo in the json1 documentation. (check-in: [57b4eafa71] user: drh branch: trunk, size: 15189)
02:04
Added: [01d95ebb2b] part of check-in [ea6f64590b] First draft of json1 documentation. (check-in: [ea6f64590b] user: drh branch: trunk, size: 15179)