Simon Willison’s Weblog

Subscribe

April 2021

41 posts: 6 entries, 5 links, 3 quotes, 27 beats

April 21, 2021

TIL Filter by comma-separated values in the Django admin — I have a text column which contains comma-separated values - inherited from an older database schema.

April 24, 2021

TIL Constructing GeoJSON in PostgreSQL — In order to efficiently generate a GeoJSON representation of a vast number of locations, I'm currently experimenting with generating the GeoJSON directly inside a PostgreSQL SQL query using `json_build_object()` and friends.

April 25, 2021

Release django-sql-dashboard 0.9a0 — Django app for building dashboards using raw SQL queries
Release django-sql-dashboard 0.9a1 — Django app for building dashboards using raw SQL queries
Release django-sql-dashboard 0.10a0 — Django app for building dashboards using raw SQL queries
Release django-sql-dashboard 0.10a1 — Django app for building dashboards using raw SQL queries

April 26, 2021

TIL Django Admin action for exporting selected rows as CSV — I wanted to add an action option to the Django Admin for exporting the currently selected set of rows (or every row in the table) as a CSV file.

Weeknotes: Vaccinate The States, and how I learned that returning dozens of MB of JSON works just fine these days

Visit Weeknotes: Vaccinate The States, and how I learned that returning dozens of MB of JSON works just fine these days

On Friday VaccinateCA grew in scope, a lot: we launched a new website called Vaccinate The States. Patrick McKenzie wrote more about the project here—the short version is that we’re building the most comprehensive possible dataset of vaccine availability in the USA, using a combination of data collation, online research and continuing to make a huge number of phone calls.

[... 1,109 words]

Release django-sql-dashboard 0.11a0 — Django app for building dashboards using raw SQL queries

Over the past several months, everyone in the industry who provides any kind of free CPU resources has been dealing with a massive outbreak of abuse for cryptocurrency mining. The industry has been setting up informal working groups to pool knowledge of mitigations, communicate when our platforms are being leveraged against one another, and cumulatively wasting thousands of hours of engineering time implementing measures to deal with this abuse, and responding as attackers find new ways to circumvent them.

Drew DeVault, SourceHut

# 11:52 pm / continuous-integration, security, bitcoin

April 28, 2021

A CSV export, JSON import workflow for bulk updating our data

I just added missing counties to around 1200 of our locations using a combination of tricks, and I thought they’d make a good blog post.

[... 1,429 words]

2021 » April

MTWTFSS
   1234
567891011
12131415161718
19202122232425
2627282930