Simon Willison’s Weblog

Weeknotes: The Aftermath

18th April 2021

Some tweets that effectively illustrate my week:

“... and nothing broke!”—several days later I can confirm that a few things did indeed break, but thankfully nothing catastrophically so!

— Simon Willison (@simonw) April 16, 2021

My resume: Migrated legacy Rails user model to external API in 30 days with no impact to customers.

Reality: 90% migrated fine, 10% edge cases where I played whack-a-mole for an entire week and deploying multiple times daily. 😂 https://t.co/L6Akkvr5pB

— Damon Cortesi (@dacort) April 16, 2021

Last week we went live with VIAL, the replacement backend I’ve been building for VaccinateCA. This meant we went from having no users to having a whole lot of users, and all of the edge-cases and missing details quickly started to emerge.

So this week I’ve been almost exclusively working my way through those. Not much to report otherwise!

TIL this week

• Using json_extract_path in PostgreSQL
• Listing files uploaded to Cloud Build
• Enabling the fuzzystrmatch extension in PostgreSQL with a Django migration

Releases this week

• django-sql-dashboard: 0.8a2—(17 total releases)—2021-04-14
  Django app for building dashboards using raw SQL queries