Show HN: Catj – A new way to display JSON files

Re:Show HN: Catj – A new way to display JSON files by kara_jade on Friday June 21, 2019 @10:18PM (#20247638)

You can do this easily with the json_tree function from SQLite's JSON1 extension. It's given as an example in the documentation:

  SELECT big.rowid, fullkey, value
    FROM big, json_tree(big.json)
   WHERE json_tree.type NOT IN ('object','array');

[ Parent | on HN ]

Re:Show HN: Catj – A new way to display JSON files by ComputerGuru on Saturday June 22, 2019 @02:16AM (#20248286)

And with the fileio sqlite extension, you can even directly query files (and their contents, and directories recursively too, no less) from SQL.

[ Parent | on HN ]