Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release twitter-to-sqlite 0.22 — Save data from Twitter to a SQLite database
TIL Publishing to a public Google Cloud bucket with gsutil — I decided to publish static CSV files to accompany my https://cdc-vaccination-history.datasette.io/ project, using a Google Cloud bucket (see [cdc-vaccination-history issue #9](https://github.com/simonw/cdc-vaccination-history/issues/9)).
Release datasette-statistics 0.1.1 — SQL statistics functions for Datasette
Release datasette-statistics 0.1 — SQL statistics functions for Datasette
Release json-flatten 0.2 — Python functions for flattening a JSON object to a single dictionary of pairs, and unflattening that dictionary back to a JSON object
TIL Configuring auto-update for an Electron app — This is _almost_ really simple. I used [electron/update-electron-app](https://github.com/electron/update-electron-app) for it, the instructions for which are:
Release datasette-app 0.2.1 — The Datasette macOS application
Release datasette-app-support 0.11.5 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.11.4 — Part of https://github.com/simonw/datasette-app
TIL Cumulative total over time in SQL — This is a quick trick for creating a cumulative chart of the total number of items created over time based just on their creation date.
Release datasette-app 0.2.0 — The Datasette macOS application
Release datasette-app-support 0.11.3 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.11.2 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.11.1 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.11 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.10 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.9 — Part of https://github.com/simonw/datasette-app
Release datasette-write 0.2 — Datasette plugin providing a UI for executing SQL writes against the database
Release datasette-schema-versions 0.2 — Datasette plugin that shows the schema version of every attached database
Release datasette-app-support 0.8 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.7 — Part of https://github.com/simonw/datasette-app
TIL Bundling Python inside an Electron app — For [Datasette Desktop](https://datasette.io/desktop) I chose to bundle a full version of Python 3.9 inside my `Datasette.app` application. I did this in order to support installation of plugins via `pip install` - you can read more about my reasoning in [Datasette Desktop—a macOS desktop application for Datasette](https://simonwillison.net/2021/Sep/8/datasette-desktop/).
TIL Signing and notarizing an Electron app for distribution using GitHub Actions — I had to figure this out for [Datasette Desktop](https://github.com/simonw/datasette-app).
TIL Attaching a generated file to a GitHub release using Actions — For [Datasette Desktop](https://github.com/simonw/datasette-app) I wanted to run an action which, when I created a release, would build an asset for that release and then upload and attach it.
Release datasette-import-table 0.3 — Datasette plugin for importing tables from other Datasette instances
Release datasette-app Datasette Desktop 0.1.0 — The Datasette macOS application
Release datasette-app-support 0.6 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.5 — Part of https://github.com/simonw/datasette-app
Release pids 0.1.2 — A tiny Python library for generating public IDs from integers
Release datasette-app-support 0.4 — Part of https://github.com/simonw/datasette-app

Beats

Years

Tags