Simon Willison’s Weblog

Subscribe

Entries tagged sqlite, json

Filters: Type: entry × sqlite × json × Sorted by date


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.

[... 1507 words]

10:55 pm / 19th June 2021 / csv, json, projects, sql, sqlite, weeknotes, sqliteutils

Datasette: instantly create and publish an API for your SQLite databases

I just shipped the first public version of datasette, a new tool for creating and publishing JSON APIs for SQLite databases.

[... 968 words]

11:49 pm / 13th November 2017 / apis, json, projects, sqlite, webapis, sanic, docker, datasette

Types

Years

Tags