3 ms·
This makes me wonder, is there a SQLite equivalent for JSON based data?
by pokstad 5y ago
This makes me wonder, is there a SQLite equivalent for JSON based data?
- kevmo314 5y agoSQLite is a good equivalent :D https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html
- karl42 5y agoFor some JSON files, sqlite-utils' memory command works great. E.g. sqlite-utils memory 'SELECT * FROM a JOIN b USING (pkey)' a.json b.json See https://sqlite-utils.datasette.io/en/stable/cli.html#querying-data-directly-using-an-in-memory-database https://sqlite-utils.datasette.io/en/stable/cli.html#queryin...
- onion2k 5y agoYou could use jq to do something similar.
- ZeroGravitas 5y agoThe other tools mentioned are all good, theres also jiq, which lets you run jq interactively against an input until you get the incantation right, then confirm it to get the full output. https://github.com/fiatjaf/jiq https://github.com/fiatjaf/jiq