Simon Willison’s Weblog

Subscribe

Entries tagged sqlite, csv

Filters: Type: entry × sqlite × csv × 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

Weeknotes: Datasette Writes

As discussed previously, the biggest hole in Datasette’s feature set at the moment involves writing to the database.

[... 604 words]

6:34 am / 26th February 2020 / csv, plugins, sqlite, threads, datasette, weeknotes

New in Datasette: filters, foreign keys and search

I’ve released Datasette 0.13 with a number of exciting new features (Datasette previously).

[... 1143 words]

9:17 pm / 25th November 2017 / csv, projects, search, sqlite, datasette

Types

Years

Tags