Simon Willison’s Weblog

Subscribe

Entries tagged graphql, sqlite in 2020

Filters: Type: entry × Year: 2020 × graphql × sqlite × Sorted by date


Refactoring databases with sqlite-utils extract

Yesterday I described the new sqlite-utils transform mechanism for applying SQLite table transformations that go beyond those supported by ALTER TABLE. The other new feature in sqlite-utils 2.20 builds on that capability to allow you to refactor a database table by extracting columns into separate tables. I’ve called it sqlite-utils extract.

[... 1345 words]

4:02 pm / 23rd September 2020 / databases, projects, sqlite, graphql, sqliteutils

Weeknotes: Installing Datasette with Homebrew, more GraphQL, WAL in SQLite

This week I’ve been working on making Datasette easier to install, plus wide-ranging improvements to the Datasette GraphQL plugin.

[... 1009 words]

7:46 pm / 13th August 2020 / homebrew, plugins, projects, sqlite, graphql, datasette, weeknotes, sqliteutils

GraphQL in Datasette with the new datasette-graphql plugin

This week I’ve mostly been building datasette-graphql, a plugin that adds GraphQL query support to Datasette.

[... 1249 words]

4:24 am / 7th August 2020 / apis, plugins, projects, sqlite, graphql, datasette, weeknotes

Types

Years

Months

Tags