Simon Willison’s Weblog

Archive for 2020

• January - 5 entries, 17 links, 5 quotes
  • Building a sitemap.xml with a one-off Datasette plugin
  • Weeknotes: Improv at Stanford, planning Datasette Cloud
  • Tracking FARA by deploying a data API using GitHub Actions and Cloud Run
  • Weeknotes: Datasette Cloud and zero downtime deployments
  • Weeknotes: datasette-auth-existing-cookies and datasette-sentry
• February - 4 entries, 4 links, 4 quotes
  • Weeknotes: Shaving yaks for Datasette Cloud
  • How to cheat at unit tests with pytest and Black
  • Things I learned about shapefiles building shapefile-to-sqlite
  • Weeknotes: Datasette Writes
• March - 5 entries, 10 links, 2 quotes
  • Weeknotes: datasette-ics, datasette-upload-csvs, datasette-configure-fts, asgi-csrf
  • datasette-search-all: a new plugin for searching multiple Datasette tables at once
  • Weeknotes: COVID-19 numbers in Datasette
  • Weeknotes: this week was absurd
  • Weeknotes: Datasette 0.39 and many other projects
• April - 7 entries, 10 links, 3 quotes
  • Weeknotes: Covid-19, First Python Notebook, more Dogsheep, Tailscale
  • Goodbye Zeit Now v1, hello datasette-publish-now - and talking to myself in GitHub issues
  • datasette-clone
  • Weeknotes: Hacking on 23 different projects
  • Using a self-rewriting README powered by GitHub Actions to track TILs
  • Weeknotes: Datasette 0.40, various projects, Dogsheep photos
  • Weeknotes: Archiving coronavirus.data.gov.uk, custom pages and directory configuration in Datasette, photos-to-sqlite
• May - 4 entries, 19 links, 5 quotes
  • Weeknotes: Datasette 0.41, photos breakthroughs
  • Weeknotes: Working on my screenplay
  • Using SQL to find my best photo of a pelican according to Apple Photos
  • Weeknotes: Datasette 0.43
• June - 6 entries, 14 links, 4 quotes
  • Weeknotes, I guess
  • Datasette 0.44: The annotated release notes
  • How much can you learn from just two columns?
  • Weeknotes: Datasette alphas for testing new plugin hooks
  • A cookiecutter template for writing Datasette plugins
  • Weeknotes: cookiecutter templates, better plugin documentation, sqlite-generate
• July - 6 entries, 21 links, 7 quotes
  • Datasette 0.45: The annotated release notes
  • Weeknotes: SBA Covid-19 PPP loans, Datasette talks, Datasette plugin upgrades
  • Building a self-updating profile README for GitHub
  • Weeknotes: datasette-auth-passwords, a Datasette logo and a whole lot more
  • Weeknotes: datasette-copyable, datasette-insert-api
  • Fun with binary data and SQLite
• August - 5 entries, 10 links, 5 quotes
  • GraphQL in Datasette with the new datasette-graphql plugin
  • Weeknotes: Installing Datasette with Homebrew, more GraphQL, WAL in SQLite
  • Weeknotes: Rocky Beaches, Datasette 0.48, a commit history of my database
  • Weeknotes: California Protected Areas in Datasette
  • Mexican bean shakshuka
• September - 8 entries, 10 links, 5 quotes
  • The "await me maybe" pattern for Python asyncio
  • Weeknotes: airtable-export, generating screenshots in GitHub Actions, Dogsheep!
  • Weeknotes: datasette-dump, sqlite-backup, talks
  • Datasette 0.49: The annotated release notes
  • Weeknotes: datasette-seaborn, fivethirtyeight-polls
  • Executing advanced ALTER TABLE operations in SQLite
  • Refactoring databases with sqlite-utils extract
  • Weeknotes: software carpentry, compiling modules for SQLite
• October - 7 entries, 16 links, 6 quotes
  • Weeknotes: Datasette column actions, plus three new plugins
  • Git scraping: track changes over time by scraping to a Git repository
  • Datasette 0.50: The annotated release notes
  • Weeknotes: Mainly Datasette 0.50
  • Building an Evernote to SQLite exporter
  • Weeknotes: evernote-to-sqlite, Datasette Weekly, scrapers, csv-diff, sqlite-utils
  • Weeknotes: incremental improvements
• November - 6 entries, 21 links, 1 quote
  • Datasette 0.51 (plus weeknotes)
  • Weeknotes: sqlite-utils 3.0 alpha, Git scraping in the zeitgeist
  • Personal Data Warehouses: Reclaiming Your Data
  • Implementing IndieAuth for Datasette
  • Weeknotes: datasette-indieauth, datasette-graphql, PyCon Argentina
  • datasette-ripgrep: deploy a regular expression search engine for your source code
• December - 5 entries, 12 links, 7 quotes
  • Weeknotes: github-to-sqlite workflows, datasette-ripgrep enhancements, Datasette 0.52
  • datasette.io, an official project website for Datasette
  • Build v.s. buy: how billing models affect your internal culture
  • Building a search engine for datasette.io
  • Weeknotes: Datasette internals