Elsewhere

Release datasette-app-support 0.8 — Part of https://github.com/simonw/datasette-app

11th Sep 2021, 12:17 am · datasette

Release datasette-app-support 0.7 — Part of https://github.com/simonw/datasette-app

10th Sep 2021, 5:08 pm · datasette

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/).

8th Sep 2021, 11:38 pm

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

8th Sep 2021, 5:41 pm

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.

8th Sep 2021, 5:04 am

Release datasette-import-table 0.3 — Datasette plugin for importing tables from other Datasette instances

8th Sep 2021, 4:49 am · datasette

Release datasette-app Datasette Desktop 0.1.0 — The Datasette macOS application

8th Sep 2021, 2:40 am · datasette

Release datasette-app-support 0.6 — Part of https://github.com/simonw/datasette-app

7th Sep 2021, 9:57 pm · datasette

Release datasette-app-support 0.5 — Part of https://github.com/simonw/datasette-app

7th Sep 2021, 8:27 pm · datasette

Release pids 0.1.2 — A tiny Python library for generating public IDs from integers

7th Sep 2021, 1:38 am

Release datasette-app-support 0.4 — Part of https://github.com/simonw/datasette-app

4th Sep 2021, 1:49 am · datasette

Release datasette-app-support 0.3 — Part of https://github.com/simonw/datasette-app

3rd Sep 2021, 11:37 pm · datasette

TIL Open external links in an Electron app using the system browser — For [Datasette.app](https://github.com/simonw/datasette-app) I wanted to ensure that links to external URLs would [open in the system browser](https://github.com/simonw/datasette-app/issues/34).

2nd Sep 2021, 9:15 pm

Release datasette-app-support 0.2 — Part of https://github.com/simonw/datasette-app

2nd Sep 2021, 6:38 pm · datasette

Release datasette-app-support 0.1.2 — Part of https://github.com/simonw/datasette-app

31st Aug 2021, 10:40 pm · datasette

Release datasette-app-support 0.1.1 — Part of https://github.com/simonw/datasette-app

31st Aug 2021, 10:35 pm · datasette

Release datasette-app-support 0.1 — Part of https://github.com/simonw/datasette-app

31st Aug 2021, 10:24 pm · datasette

TIL Using the Chrome DevTools console as a REPL for an Electron app — I figured out how to use the Chrome DevTools to execute JavaScript interactively inside the Electron main process. I always like having a REPL for exploring APIs, and this means I can explore the Electron and Node.js APIs interactively.

31st Aug 2021, 9:09 pm

TIL Calculating the AQI based on the Purple Air API for a sensor — [Purple Air](https://www.purpleair.com/) sensors have an API at `https://www.purpleair.com/map.json?show=SENSOR-ID-HERE`, which returns JSON that looks something like this:

31st Aug 2021, 7:46 pm

Release datasette-verify 0.1 — Verify that files can be opened by Datasette

28th Aug 2021, 2:31 am · datasette

Release datasette 0.59a2 — An open source multi-tool for exploring and publishing data

28th Aug 2021, 1:57 am · datasette

Release evernote-to-sqlite 0.3.2 — Tools for converting Evernote content to SQLite

26th Aug 2021, 7:02 pm

Release sqlite-utils 3.17 — Python CLI utility and library for manipulating SQLite databases

24th Aug 2021, 11:42 pm · sqlite, sqlite-utils

TIL Searching all columns of a table in Datasette — I came up with this trick today, when I wanted to run a `LIKE` search against every column in a table.

23rd Aug 2021, 6:48 pm

TIL Histogram with tooltips in Observable Plot — Given an array of datetime objects, I wanted to plot a histogram. But I wanted to automatically pick a bucket size for that histogram that resulted in something interesting, no matter what range of time the individual points covered.

21st Aug 2021, 10:47 pm