4 ms·
That does seem cool. So there are sufficient functions to iterate through collections that might be stored in a single row of a JSON column?
by MoonWalk 6mo ago
That does seem cool. So there are sufficient functions to iterate through collections that might be stored in a single row of a JSON column?
- duskwuff 6mo agoYes, using the table-valued JSON functions like JSON_EACH and JSON_TREE (which works recursively). Details: https://sqlite.org/json1.html#table_valued_functions_for_parsing_json_json_each_jsonb_each_json_tree_and_jsonb_tree_ https://sqlite.org/json1.html#table_valued_functions_for_par...