René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"experimenting with sqlite json","articleBody":"This is to get handy in json in sql\r\n\r\nhere, tr\r\n\r\n```\r\nDROP TABLE IF EXISTS packages;\r\nCREATE TABLE packages(datas JSON);\r\npydef py_pydeptree(s):\r\n    \"get a json experience from pip\"\r\n    import pipdeptree as pdt\r\n    pkgs = pdt.get_installed_distributions()\r\n    dist_index = pdt.build_dist_index(pkgs)\r\n    tree = pdt.construct_tree(dist_index)\r\n    result=pdt.render_json_tree(tree, indent=4).replace('\\n', '\\n')  # no need to remove newline ?\r\n    return (\"%s\" %  result);\r\n\r\nINSERT INTO packages select py_pydeptree('hi');\r\n\r\n````\r\n\r\n\r\n````\r\n-- select  datas  from packages;\r\n--select json_type(datas) from packages;\r\n--select atom, fullkey, value from packages, json_tree(packages.datas) where json_tree.type NOT IN ('object','array');\r\n\r\nwith x as (select json_extract(Value,'$.key') package\r\n                , json_extract(Value,'$.package_name') name\r\n                , json_extract(Value,\"$.installed_version\")version\r\n                ,  json_extract(Value,'$.dependencies') Dependancies\r\n           from packages , json_each(packages.datas))\r\nselect * from x\r\n\r\n```","author":{"url":"https://github.com/stonebig","@type":"Person","name":"stonebig"},"datePublished":"2020-05-02T11:12:22.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":12},"url":"https://github.com/850/winpython/issues/850"}