Simon Willison’s Weblog

Subscribe

Entries tagged sql in 2019

Filters: Type: entry × Year: 2019 × sql × Sorted by date


sqlite-utils 2.0: real upserts

I just released version 2.0 of my sqlite-utils library/CLI tool to PyPI.

[... 1140 words]

6:48 am / 30th December 2019 / museums, projects, sql, sqlite, upsert, weeknotes, sqliteutils

Weeknotes: datasette-template-sql

Last week I talked about wanting to take ona a larger Datasette project, and listed some candidates. I ended up pushing a big project that I hadn’t listed there: the upgrade of Datasette to Python 3.8, which meant dropping support for Python 3.5 (thanks to incompatible dependencies).

[... 521 words]

10:29 pm / 18th November 2019 / projects, sql, datasette, weeknotes

Types

Years

Months

Tags