Simon Willison’s Weblog

Subscribe

August 2020

110 posts: 5 entries, 10 links, 5 quotes, 90 beats

Aug. 9, 2020

Datasette 0.46 (via) I just released Datasette 0.46 with a security fix for an issue involving CSRF tokens on canned query pages, plus a new debugging tool, improved file downloads and a bunch of other smaller improvements.

# 4:57 pm / csrf, projects, security, datasette

Release csvs-to-sqlite 1.1 — Convert CSV files into a SQLite database
Release datasette-json-html 0.6 — Datasette plugin for rendering HTML based on JSON values
Release datasette-json-html 0.6.1 — Datasette plugin for rendering HTML based on JSON values

Aug. 10, 2020

TIL Enabling WAL mode for SQLite database files — I was getting occasional `Error: database is locked` messages from a Datasette instance that was running against a bunch of different SQLite files that were updated by cron scripts (my personal [Dogsheep](https://dogsheep.github.io/)).
TIL Attaching a bash shell to a running Docker container — Use `docker ps` to find the container ID:
Release sqlite-utils 2.15 — Python CLI utility and library for manipulating SQLite databases

Aug. 11, 2020

TIL Packaging a Python CLI tool for Homebrew — I finally figured out how to package [Datasette](https://github.com/simonw/datasette) for installation with Homebrew. My package was accepted into Homebrew core, which means you can now install it like this:

Aug. 12, 2020

TIL How to call pip programatically from Python — I needed this for the `datasette install` and `datasette uninstall` commands, see [issue #925](https://github.com/simonw/datasette/issues/925).
Release datasette 0.47 — An open source multi-tool for exploring and publishing data
Release datasette 0.47.1 — An open source multi-tool for exploring and publishing data
Release sqlite-utils 2.15.1 — Python CLI utility and library for manipulating SQLite databases
TIL Customizing my zsh prompt — I got fed up of the default macOS `zsh` prompt:
Release datasette 0.47.2 — An open source multi-tool for exploring and publishing data

Aug. 13, 2020

We’re generally only impressed by things we can’t do - things that are beyond our own skill set. So, by definition, we aren’t going to be that impressed by the things we create. The end user, however, is perfectly able to find your work impressive.

@gamemakerstk

# 3:12 pm / productivity

Release datasette-graphql 0.12 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

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

Visit 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.

[... 1,009 words]

Release datasette-graphql 0.12.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

Aug. 14, 2020

Release datasette-cluster-map 0.11 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette-cluster-map 0.11.1 — Datasette plugin that shows a map for any data with latitude/longitude columns
TIL Pointing a custom subdomain at Read the Docs — I host the documentation for Datasette on [Read the Docs](https://readthedocs.org/). Until today it lived at https://datasette.readthedocs.io/ but today I moved it to a custom subdomain, https://docs.datasette.io/

Aug. 15, 2020

Release asgi-csrf 0.7a0 — ASGI middleware for protecting against CSRF attacks
Release asgi-csrf 0.7 — ASGI middleware for protecting against CSRF attacks
TIL Code coverage using pytest and codecov.io — I got my [asgi-csrf](https://github.com/simonw/asgi-csrf) Python package up to 100% code coverage. Here's [the pull request](https://github.com/simonw/asgi-csrf/issues/13).
Release datasette-upload-csvs 0.5 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette 0.47.3 — An open source multi-tool for exploring and publishing data
Release datasette-saved-queries 0.2.1 — Datasette plugin that lets users save and execute queries

Aug. 16, 2020

Release datasette-graphql 0.12.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette 0.48 — An open source multi-tool for exploring and publishing data
Release datasette-cluster-map 0.12 — Datasette plugin that shows a map for any data with latitude/longitude columns

2020 » August

MTWTFSS
     12
3456789
10111213141516
17181920212223
24252627282930
31