alt Hacker NewsThat does seem cool. So there are sufficient functions to iterate through collections that might be stored in a single row of a JSON column?
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?
Yes, 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_par...