3 ms·
My sqlite-utils tool can pipe JSON directly into a SQLite table, creating a table with the right schema if it doesn't exist yet: https://sqlite-utils.datasette.
by simonw 3y ago
My sqlite-utils tool can pipe JSON directly into a SQLite table, creating a table with the right schema if it doesn't exist yet: https://sqlite-utils.datasette.io/en/stable/cli.html#inserting-json-data https://sqlite-utils.datasette.io/en/stable/cli.html#inserti...
- LikesPwsh 3y agoThat project looks great. The MSSQL equivalent would be DbaTools, in case anyone is looking. https://docs.dbatools.io/Write-DbaDbTableData.html https://docs.dbatools.io/Write-DbaDbTableData.html