3 ms·
My sqlite-utils tool can load JSON into a SQLite database table: https://sqlite-utils.datasette.io/en/stable/cli.html#inserting-json-data https://sqlite-utils.d
by simonw 4y ago
My sqlite-utils tool can load JSON into a SQLite database table: https://sqlite-utils.datasette.io/en/stable/cli.html#inserting-json-data https://sqlite-utils.datasette.io/en/stable/cli.html#inserti...
It can also be used to run SQL queries against an in-memory database created from one or more JSON or CSV imports: https://simonwillison.net/2021/Jun/19/sqlite-utils-memory/ https://simonwillison.net/2021/Jun/19/sqlite-utils-memory/