Entries tagged projects, json

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

3 results

Datasette’s new JSON write API: The first alpha of Datasette 1.0

This week I published the first alpha release of Datasette 1.0, with a significant new feature: Datasette core now includes a JSON API for creating and dropping tables and inserting, updating and deleting data.

[... 2817 words]

11:15 pm / 2nd December 2022 / apis, json, projects, datasette

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

Simon Willison’s Weblog