Simon Willison’s Weblog

Subscribe

September 2021

54 posts: 4 entries, 9 links, 2 quotes, 39 beats

Sept. 13, 2021

Release datasette-app-support 0.11.4 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.11.5 — Part of https://github.com/simonw/datasette-app
Release datasette-app 0.2.1 — The Datasette macOS application

Datasette Desktop 0.2.0: The annotated release notes

Visit Datasette Desktop 0.2.0: The annotated release notes

Datasette Desktop is a new macOS desktop application version of Datasette, an “open source multi-tool for exploring and publishing data” built on top of SQLite. I released the first version last week—I’ve just released version 0.2.0 (and a 0.2.1 bug fix) with a whole bunch of critical improvements.

[... 2,208 words]

Sept. 14, 2021

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

Sept. 16, 2021

Release datasette-statistics 0.1 — SQL statistics functions for Datasette
Release datasette-statistics 0.1.1 — SQL statistics functions for Datasette

Sept. 19, 2021

Weeknotes number 100

This entry marks my 100th weeknotes, which I’ve managed to post once a week (plus or minus a few days) consistently since 13th September 2019.

[... 593 words]

Sept. 20, 2021

egghead screencasting technical guide (via) Detailed guide to producing high quality screencasts—software to use, audio tips, editing workflow—from the egghead.io online instructor platform.

# 5:39 pm / screencasting

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

Sept. 21, 2021

Release twitter-to-sqlite 0.22 — Save data from Twitter to a SQLite database

Sept. 22, 2021

TIL Loading lit from Skypack — [Lit 2](https://lit.dev/blog/2021-09-21-announcing-lit-2/) stable was released today, offering a tiny, feature-full framework for constructing web components using modern JavaScript.
Release sqlite-utils 3.17.1 — Python CLI utility and library for manipulating SQLite databases
Release datasette-render-markdown 2.0 — Datasette plugin for rendering Markdown
Release datasette-notebook 0.1a0 — A markdown wiki and dashboarding system for Datasette
Release datasette-notebook 0.1a1 — A markdown wiki and dashboarding system for Datasette

Sept. 23, 2021

Release datasette-template-request 0.1 — Expose the Datasette request object to custom templates

Introducing Partytown 🎉: Run Third-Party Scripts From a Web Worker (via) This is just spectacularly clever. Partytown is a 6KB JavaScript library that helps you move gnarly poorly performing third-party scripts out of your main page and into a web worker, so they won’t destroy your page performance. The really clever bit is in how it provides sandboxed access to the page DOM: it uses a devious trick where a proxy object provides getters and setters which then make blocking API calls to a separate service worker, using the mostly-forgotten xhr.open(..., false) parameter that turns off the async default for an XMLHttpRequest call.

# 6:29 pm / async, javascript, webworkers, serviceworkers

File not found: A generation that grew up with Google is forcing professors to rethink their lesson plans (via) This is fascinating: as-of 2017 university instructors have been increasingly encountering students who have absolutely no idea how files and folders on a computer work. The new generation has a completely different mental model of how applications work, where everything is found using search and data mostly lives inside the application that you use to manipulate it.

Gradually, Garland came to the same realization that many of her fellow educators have reached in the past four years: the concept of file folders and directories, essential to previous generations’ understanding of computers, is gibberish to many modern students.

# 10:49 pm / teaching, usability, computer-literacy

Sept. 24, 2021

New tool: an nginx playground. Julia Evans built a sandbox tool for interactively trying out an nginx configuration and executing test requests through it. I love this kind of tool, and Julia’s explanation of how they built it using a tiny fly.io instance and a network namespace to reduce the amount of damage any malicious usage could cause is really interesting.

# 6:44 pm / nginx, security, julia-evans, fly

Sept. 26, 2021

django-upgrade (via) Adam Johnson’s new CLI tool for upgrading Django projects by automatically applying changes to counter deprecations made in different versions of the framework. Uses the Python standard library tokenize module which gives it really quick performance in parsing and rewriting Python code. Exciting to see this kind of codemod approach becoming more common in Python world—JavaScript developers use this kind of thing a lot.

# 5:42 am / cli, django, python, adam-johnson

Sept. 28, 2021

Weeknotes: CDC vaccination history fixes, developing in GitHub Codespaces

I spent the last week mostly surrounded by boxes: we’re completing our move to the new place and life is mostly unpacking now. I did find some time to fix some issues with my CDC vaccination history Datasette instance though.

[... 514 words]

Sept. 29, 2021

The GIL and its effects on Python multithreading (via) Victor Skvortsov presents the most in-depth explanation of the Python Global Interpreter Lock I’ve seen anywhere. I learned a ton from reading this.

# 5:23 pm / concurrency, gil, python, threads

2021 » September

MTWTFSS
  12345
6789101112
13141516171819
20212223242526
27282930