- January - 7 entries, 9 links, 4 quotes
- 3rd: Weeknotes: A flurry of not-quite-finished features
- 7th: APIs from CSS without JavaScript: the datasette-css-properties plugin
- 10th: Weeknotes: datasette-export-notebook, PyInstaller packaged Datasette, CBSAs
- 17th: Weeknotes: Still pretty distracted
- 24th: Drawing shapes on a map to query a SpatiaLite database (and other weeknotes)
- 25th: Datasette 0.54: The annotated release notes
- 31st: Weeknotes: datasette-leaflet, datasette-plugin cookiecutter upgrades
- February - 11 entries, 11 links, 6 quotes
- 4th: Serving map tiles from SQLite with MBTiles and datasette-tiles
- 7th: Weeknotes: Mostly messing around with map tiles
- 7th: Video introduction to Datasette and sqlite-utils
- 14th: Weeknotes: Finally, an intro video for Datasette
- 19th: Open source projects: consider running office hours
- 21st: Cross-database queries in SQLite (and weeknotes)
- 22nd: Getting started
- 23rd: Spinning up a new Django app to act as a backend for VaccinateCA
- 24th: Importing data from Airtable into Django, plus a search engine for all our code
- 25th: Django admin customization, JSON in our PostgreSQL
- 28th: Trying to end the pandemic a little earlier with VaccinateCA
- March - 13 entries, 15 links, 3 quotes
- 1st: Drawing the rest of the owl
- 2nd: API ready for testing, first video status update
- 3rd: Replaying logs to exercise the new API
- 5th: Git scraping, the five minute lightning talk
- 6th: The simplest possible call queue
- 7th: Weeknotes: Datasette and Git scraping at NICAR, VaccinateCA
- 7th: New call queue ready to test. Also geography.
- 9th: APIs for importing locations
- 14th: Weeknotes: tableau-to-sqlite, django-sql-dashboard
- 15th: VIAL is now live, plus django-sql-dashboard
- 21st: Weeknotes: django-sql-dashboard widgets
- 23rd: The Airtable formulas at the heart of everything
- 28th: Weeknotes: SpatiaLite 5, Datasette on Azure, more CDC vaccination history
- April - 6 entries, 5 links, 3 quotes
- 1st: VIAL: Preparing for some collaborative testing
- 4th: Animated choropleth of vaccinations by US county
- 12th: Porting VaccinateCA to Django
- 18th: Weeknotes: The Aftermath
- 26th: Weeknotes: Vaccinate The States, and how I learned that returning dozens of MB of JSON works just fine these days
- 28th: A CSV export, JSON import workflow for bulk updating our data
- May - 5 entries, 16 links, 2 quotes
- June - 5 entries, 17 links, 3 quotes
- 3rd: Weeknotes: Docker architectures, sqlite-utils 3.7, nearly there with Datasette 0.57
- 12th: Weeknotes: New releases across nine different projects
- 19th: Joining CSV and JSON data with an in-memory SQLite database
- 25th: Notes on streaming large API responses
- 28th: Weeknotes: sqlite-utils updates, Datasette and asgi-csrf, open-sourcing VIAL
- July - 9 entries, 21 links, 2 quotes
- 1st: PAGNIs: Probably Are Gonna Need Its
- 6th: Django SQL Dashboard 1.0
- 13th: Weeknotes: Fun with Unix domain sockets
- 16th: Datasette 0.58: The annotated release notes
- 17th: It doesn't take much public creativity to stand out as a job candidate
- 21st: Weeknotes: sqlite-transform 1.1, Datasette 0.58.1, datasette-graphql 1.5
- 22nd: Datasette - an ecosystem of tools for working with small data
- 28th: The Baked Data architectural pattern
- 29th: Weeknotes: datasette-remote-metadata, sqlite-transform --multi
- August - 6 entries, 20 links, 8 quotes
- 3rd: Exploring the SameSite cookie attribute for preventing CSRF
- 6th: Apply conversion functions to data in SQLite columns with the sqlite-utils CLI tool
- 14th: Datasette on Codespaces, sqlite-utils API reference documentation and other weeknotes
- 22nd: Weeknotes: Getting my personal Dogsheep up and running again
- 28th: Dynamic content for GitHub repository templates using cookiecutter and GitHub Actions
- 30th: Building a desktop application for Datasette (and weeknotes)
- September - 4 entries, 9 links, 2 quotes
- October - 3 entries, 11 links, 1 quote
- November - 5 entries, 9 links, 3 quotes
- 3rd: s3-credentials: a tool for creating credentials for S3 buckets
- 4th: How to build, test and publish an open source Python library
- 5th: Weeknotes: datasette-jupyterlite, s3-credentials and a Python packaging talk
- 15th: Weeknotes: git-history, created for a Git scraping workshop
- 22nd: Weeknotes: Apache proxies in Docker containers, refactoring Datasette
- December - 5 entries, 15 links, 2 quotes
- 1st: Weeknotes: Shaving some beautiful yaks
- 7th: git-history: a tool for analyzing scraped data collected using Git and SQLite
- 8th: Weeknotes: git-history, bug magnets and s3-credentials --public
- 16th: Weeknotes: Trapped in an eternal refactor
- 24th: Weeknotes: datasette-tiddlywiki, filters_from_request