Simon Willison’s Weblog

Subscribe

Saturday, 19th June 2021

Joining CSV and JSON data with an in-memory SQLite database

Visit Joining CSV and JSON data with an in-memory SQLite database

The new sqlite-utils memory command can import CSV and JSON data directly into an in-memory SQLite database, combine and query it using SQL and output the results as CSV, JSON or various other formats of plain text tables.

[... 1,507 words]

2021 » June

MTWTFSS
 123456
78910111213
14151617181920
21222324252627
282930