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