Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around bb4d35e2628320e187f9.
2023-12-01
| ||
20:37 | Remove old code for tokendata=1 queries. (check-in: b0a489e8e1 user: dan tags: fts5-token-data) | |
20:10 | Merge latest trunk with this branch. (check-in: 8258967411 user: dan tags: fts5-token-data) | |
20:09 | Different approach to querying a tokendata=1 table. Saves cpu and memory. (check-in: c523f40895 user: dan tags: fts5-token-data) | |
18:49 | JSON cache is now more effective. (check-in: 443a3f3a8e user: drh tags: jsonb) | |
18:46 | Fix up the JSON cache to work better. (Closed-Leaf check-in: 1fdbc39521 user: drh tags: jsonb-cache) | |
13:28 | Cache is working better, but does not preserve the hasJson5 flag. (check-in: a12add7ab9 user: drh tags: jsonb-cache) | |
12:57 | First attempt to get the JSON text-to-binary cache working. All test cases pass, but the cache seems not to help much. (check-in: 25ed295f30 user: drh tags: jsonb) | |
2023-11-30
| ||
23:36 | Remove all trace of JsonNode from the JSON implementation. The JSONB format is used as the internal binary encoding for searching and editing. (check-in: 11ebb5f712 user: drh tags: jsonb) | |
20:57 | Convert json_valid() over to using only JSONB as its internal format. (check-in: 7b5756fa6d user: drh tags: jsonb) | |
20:34 | Add a basic batch-mode SQL runner for the SAH Pool VFS, for use in comparing it against WebSQL. Bring the WebSQL batch runner up to date, noting that it cannot run without addition of an "origin trial" activation key from Google because that's now the only way to enable WebSQL in Chrome (that part is not checked in because that key is private). Minor code-adjacent cleanups. (check-in: 883990e793 user: stephan tags: trunk) | |
19:29 | Convert json_type() to use JSONB internally. (check-in: 83074835b9 user: drh tags: jsonb) | |
19:11 | Convert json_insert(), json_replace(), and json_set() over to using only JSONB internally. (check-in: 4e2083e86f user: drh tags: jsonb) | |
19:06 | Enhance json_set() and json_insert() so that they create missing substructure. (Closed-Leaf check-in: cc7a641ab5 user: drh tags: jsonb-insert) | |
16:17 | Simplification of the new JSON insert/set test cases. (check-in: 04c0d56443 user: drh tags: jsonb-insert) | |
16:16 | New JSON test cases showing insert or set with missing substructure. (check-in: 6802b6459d user: drh tags: trunk) | |
12:04 | New test cases for insert/set/replace with paths that indicate substructure that does not yet exist. (check-in: 146c717c51 user: drh tags: jsonb-insert) | |
10:00 | Update some OPFS-related help text in WASM tests. Minor cleanups in speedtest1-worker.js. (check-in: 263f6d3a77 user: stephan tags: trunk) | |
00:52 | Convert json_insert(), json_replace(), json_set() to use JSONB internally. Mostly working, but some corner cases are still not quite right. (check-in: 99c8f6bd5c user: drh tags: jsonb-insert) | |
2023-11-29
| ||
20:06 | Convert the json_error_position() routine to use only JSONB internally. (check-in: e7a8ba35bf user: drh tags: jsonb) | |
17:36 | The json_patch() function now operates exclusively on JSONB. This patch also includes improvements to JSONB debug printing routines. (check-in: fee19d0098 user: drh tags: jsonb) | |
16:26 | Fix a duplicate assert() caused by the second cherrypick in the previous check-in. (check-in: f10d4fc4a8 user: drh tags: branch-3.28) | |
16:22 | Fix signed integer overflow in fts5. (check-in: 60e46c7ec6 user: dan tags: fts5-token-data) | |
16:07 | Remove Window objects from the corresponding Select.pWin list when they are deleted, as they are, for example, when the ORDER BY clause is optimized out. (check-in: f9c6e6a710 user: drh tags: branch-3.28) | |
13:47 | In the recovery extension, if a payload size is unreasonably large, it is probably corrupt, so truncate it. (check-in: 988c3179e9 user: drh tags: trunk) | |
12:18 | Merge all the latest trunk enhancements into the jsonb branch. (check-in: 1a59fcab21 user: drh tags: jsonb) | |
02:53 | Increase the patch level to 3.44.3. (check-in: bb4d35e262 user: drh tags: branch-3.44) | |
02:50 | Reference count the Table passed into the OP_VCheck opcode. (check-in: 79e6496bb1 user: drh tags: branch-3.44) | |
02:45 | The assertion change at check-in [7946c79567b0ccd3] is insufficient to fix the problem of a Table object being deleted out from under the OP_VCheck opcode. We need to reference count the Table, which is accomplished here. (check-in: cad269d5e2 user: drh tags: trunk) | |
01:38 | Convert the json_array_length() function to use JSONB instead of JsonNodes. (check-in: 5ab790736d user: drh tags: jsonb) | |
2023-11-28
| ||
23:26 | Fix all known problems with JSONB json_extract(). (check-in: d5f48c57e9 user: drh tags: jsonb) | |
23:18 | Do not set the J subtype when the output is JSONB. (Closed-Leaf check-in: 4f106b64fe user: drh tags: jsonb-extract) | |
20:33 | Preserve flexibility in the format of the RHS of -> and ->> operators found in legacy. (check-in: 6231ec43ad user: drh tags: jsonb-extract) | |
20:25 | Attempt to get json_extract() working with pure JSONB only, and without the use of JsonNode. Mostly working, but there are some differences from legacy in corner cases. (check-in: 8c324af1ec user: drh tags: jsonb-extract) | |
19:43 | Merge latest trunk updates into this branch. (check-in: 554fc13f2c user: dan tags: fts5-token-data) | |
18:16 | The json_remove() function now uses only JSONB, never JsonNodes, internally. (check-in: b69786e746 user: drh tags: jsonb) | |
17:47 | Update this branch with latest changes from trunk. (check-in: bead0d8f5a user: dan tags: begin-concurrent) | |
17:32 | Update this branch with latest changes from trunk. (check-in: 7f1b61a3ea user: dan tags: wal2) | |
17:12 | In SQLITE_ENABLE_SETLK_TIMEOUT builds, use blocking locks in place of sleep() calls when opening a read-transaction. (check-in: 4c055b7a6e user: dan tags: trunk) | |
15:29 | Handle an SQLITE_BUSY_TIMEOUT error if one occurs while attempting a shared lock on a read-lock slot. (Closed-Leaf check-in: 5fbf3906d2 user: dan tags: blocking-dms-lock) | |
13:38 | Activate the ability of json_patch() to work on JSONB. (check-in: 11aba347ff user: drh tags: jsonb) | |
13:35 | All legacy tests are passing. (Closed-Leaf check-in: 2c436806b8 user: drh tags: jsonb-patch) | |
12:28 | The json_patch() code for JSONB compiles and works sometimes, but there are still issues. Incremental check-in. (check-in: e0099464a0 user: drh tags: jsonb-patch) | |
00:27 | More aggressive use of jsonBlobEdit(). Improvements to the MergePatch implementation sketch. (check-in: fbca9570fd user: drh tags: jsonb) | |
2023-11-27
| ||
23:46 | Add untested (#ifdefed-out) code for the MergePatch algorithm against JSONB. Add (and test) the jsonBlobEdit() routine that is needed by the new MergePatch. (check-in: 4d353387fc user: drh tags: jsonb) | |
20:37 | Have SQLITE_ENABLE_SETLK_TIMEOUT builds block when locking a read-lock slot. (check-in: f797baf47c user: dan tags: blocking-dms-lock) | |
19:22 | In SQLITE_ENABLE_SETLK_TIMEOUT builds, use blocking locks in place of sleep() when opening a read-transaction. (check-in: a51ef39998 user: dan tags: blocking-dms-lock) | |
17:13 | Enhance the (SQLITE_DEBUG-only) json_parse() routine so that it shows a decoding of JSONB when given a BLOB argument. (check-in: af26786856 user: drh tags: jsonb) | |
15:57 | Give the json_valid() function an optional second argument that determines what is meant by "valid". (check-in: a4e19ad43d user: drh tags: jsonb) | |
15:08 | Pickup stray oput?() calls that should have gone to stdout. Simplify console line reading, sacrificing speed (which does not matter then) for code size. (Leaf check-in: 8e20645cc2 user: larrybr tags: console-io-lib) | |
12:36 | Convert the json_tree() and json_each() virtual tables over to use JSONB has their internal representation. (check-in: ec18caa3f7 user: drh tags: jsonb) | |