4 ms·

For 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://sq

by karl42 5y ago

For 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...