Simon Willison’s Weblog

Subscribe

Entries tagged projects, sqliteutils in 2019

Filters: Type: entry × Year: 2019 × projects × sqliteutils × 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

Logging to SQLite using ASGI middleware

I had some fun playing around with ASGI middleware and logging during our flight back to England for the holidays.

[... 2535 words]

10:30 pm / 16th December 2019 / django, logging, projects, sqlite, datasette, asgi, weeknotes, sqliteutils

Tracking PG&E outages by scraping to a git repo

PG&E have cut off power to several million people in northern California, supposedly as a precaution against wildfires.

[... 833 words]

11:32 pm / 10th October 2019 / datajournalism, projects, scraping, sqlite, datasette, gitscraping, digitalocean, sqliteutils

sqlite-utils: a Python library and CLI tool for building SQLite databases

sqlite-utils is a combination Python library and command-line tool I’ve been building over the past six months which aims to make creating new SQLite databases as quick and easy as possible.

[... 1237 words]

3:29 am / 25th February 2019 / opensource, projects, sqlite, datasette, sqliteutils

Types

Years

Months

Tags