2 ms·
I've been experimenting with the combo of the "jq" JSON query language and SQL via a custom SQLite function. I bundled the result as a plugin for my Datasette p
by simonw 7y ago
I've been experimenting with the combo of the "jq" JSON query language and SQL via a custom SQLite function. I bundled the result as a plugin for my Datasette project: https://github.com/simonw/datasette-jq https://github.com/simonw/datasette-jq
Here's an example query: https://datasette-jq-demo.datasette.io/demo?sql=select%0D%0A++package%2C%0D%0A++jq%28%0D%0A++++info%2C%0D%0A++++%22%7Bsummary%3A+.info.summary%2C+author%3A+.info.author%2C+versions%3A+.releases%7Ckeys%7Creverse%7D%22%0D%0A++%29%2C%0D%0A++info%0D%0Afrom%0D%0A++packages https://datasette-jq-demo.datasette.io/demo?sql=select%0D%0A...