Simon Willison’s Weblog

Subscribe

July 2020

88 posts: 6 entries, 21 links, 7 quotes, 54 beats

July 1, 2020

Release asgi-csrf 0.6 — ASGI middleware for protecting against CSRF attacks
Release datasette 0.45a5 — An open source multi-tool for exploring and publishing data

entr: rerun your build when files change. “WHY DID NOBODY TELL ME ABOUT THIS BEFORE?!?!” is one of my favourite genres of blog post.

# 3:58 pm / julia-evans

Release datasette-auth-tokens 0.2 — Datasette plugin for authenticating access using API tokens
Release datasette-auth-tokens 0.2.1 — Datasette plugin for authenticating access using API tokens
Release datasette 0.45 — An open source multi-tool for exploring and publishing data

Datasette 0.45: The annotated release notes

Datasette 0.45, out today, features magic parameters for canned queries, a log out feature, improved plugin documentation and four new plugin hooks.

[... 863 words]

Release datasette-init 0.2 — Ensure specific tables and views exist on startup
Release datasette-glitch 0.1 — Utilities to help run Datasette on Glitch
Release datasette-saved-queries 0.2 — Datasette plugin that lets users save and execute queries
Release datasette-write 0.1 — Datasette plugin providing a UI for executing SQL writes against the database

July 2, 2020

Better Python Decorators with wrapt (via) Adam Johnson explains the intricacies of decorating a Python function without breaking the ability to correctly introspect it, and discusses how Scout use the wrapt library by Graham Dumpleton to implement their instrumentation library.

# 9:48 pm / decorators, python, adam-johnson

July 3, 2020

How to find what you want in the Django documentation (via) Useful guide by Matthew Segal to navigating the Django documentation, and tips for reading documentation in general. The Django docs have a great reputation so it’s easy to forget how intimidating they can be for newcomers: Matthew emphasizes that docs are rarely meant to be read in full: the trick is learning how to quickly search them for the things you need to understand right now.

# 3:04 pm / django, documentation

July 4, 2020

The future will not be like the past. The comfortable Victorian and Georgian world complete with grand country houses, a globe-spanning British empire, and lords and commoners each knowing their place, was swept away by the events that began in the summer of 1914 (and that with Britain on the “winning” side of both world wars.) So too, our comfortable “American century” of conspicuous consumer consumption, global tourism, and ever-increasing stock and home prices may be gone forever.

Tim O'Reilly

# 4:06 pm / tim-oreilly, covid19

July 6, 2020

Release datasette-search-all 0.3 — Datasette plugin for searching all searchable tables at once
Release datasette-configure-fts 1.0 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-edit-schema 0.2a — Datasette plugin for modifying table schemas

July 7, 2020

sba-loans-covid-19-datasette (via) The treasury department released a bunch of data on the Covid-19 SBA Paycheck Protection Program Loan recipients today—I’ve loaded the most interesting data (the $150,000+ loans) into a Datasette instance.

# 2:42 am / data-journalism, projects, datasette, covid19

GitHub Actions: Manual triggers with workflow_dispatch (via) New GitHub Actions feature which fills a big gap in the offering: you can now create “workflow dispatch” events which provide a button for manually triggering an action—and you can specify extra UI form fields that can customize how that action runs. This turns Actions into an interactive automation engine for any code that can be wrapped in a Docker container.

# 4:33 am / docker, github-actions

When data is messy. I love this story: a neural network trained on images was asked what the most significant pixels in pictures of tench (a kind of fish) were: it returned pictures of fingers on a green background, because most of the tench photos it had seen were fisherfolk showing off their catch.

# 7:03 pm / machine-learning, ai

July 8, 2020

Release datasette-media 0.3 — Datasette plugin for serving media based on a SQL query
Release sqlite-utils 2.11 — Python CLI utility and library for manipulating SQLite databases

July 9, 2020

Weeknotes: SBA Covid-19 PPP loans, Datasette talks, Datasette plugin upgrades

Visit Weeknotes: SBA Covid-19 PPP loans, Datasette talks, Datasette plugin upgrades

This week I’ve mainly been exploring Small Business Administration Covid-19 loans data, pitching some talks and upgrading some plugins for compatibility with Datasette 0.44+.

[... 524 words]

Release github-to-sqlite 2.3 — Save data from GitHub to a SQLite database

July 10, 2020

TIL Paginating through the GitHub GraphQL API with Python — (See also [Building a self-updating profile README for GitHub](https://simonwillison.net/2020/Jul/10/self-updating-profile-readme/) on my blog)

Building a self-updating profile README for GitHub

Visit Building a self-updating profile README for GitHub

GitHub quietly released a new feature at some point in the past few days: profile READMEs. Create a repository with the same name as your GitHub account (in my case that’s github.com/simonw/simonw), add a README.md to it and GitHub will render the contents at the top of your personal profile page—for me that’s github.com/simonw

[... 599 words]

July 11, 2020

TIL Using heroku pg:pull to restore a backup to a macOS laptop — Today I worked out how to use the Heroku `pg:pull` command and [Postgres.app](https://postgresapp.com/) to pull a Heroku backup to my laptop.
Release datasette-publish-fly 1.0 — Datasette plugin for publishing data using Fly

zhiiiyang/zhiiiyang profile README (via) This is a brilliant hack: a GitHub profile README that uses an action to retrieve the author’s latest tweet (using R), render it as a PNG screenshot in headless Chrome via rstudio/webshot2 and embed that image in their profile.

# 5:47 pm / github, r, github-actions

July 13, 2020

Release datasette-auth-passwords 0.1 — Datasette plugin for authentication using passwords

2020 » July

MTWTFSS
  12345
6789101112
13141516171819
20212223242526
2728293031