- January - 7 entries, 14 links, 3 quotes
- 4th: Weeknotes: Taking a break in Moss Landing
- 11th: What's new in sqlite-utils 3.20 and 3.21: --lines, --text, --convert
- 12th: How I build a feature
- 14th: Datasette 0.60: The annotated release notes
- 18th: Weeknotes: s3-credentials prefix and Datasette 0.60
- 25th: Weeknotes: python_requires, documentation SEO
- 31st: Writing better release notes
- February - 5 entries, 12 links, 2 quotes
- March - 9 entries, 10 links, 2 quotes
- 5th: Why I invented "dash encoding", a new encoding scheme for URL paths
- 10th: shot-scraper: automated screenshots for documentation, built on Playwright
- 12th: Weeknotes: Distracted by Playwright
- 14th: Scraping web pages from the command line with shot-scraper
- 14th: Instantly create a GitHub repository to take screenshots of a web page
- 19th: Weeknotes: Tildes not dashes, and the big refactor
- 23rd: SQLite Happy Hour - a Twitter Spaces conversation about three interesting projects building on SQLite
- 24th: Datasette 0.61: The annotated release notes
- 28th: Weeknotes: datasette-auth0
- April - 5 entries, 15 links
- 8th: Pillar Point Stewards, pypi-to-sqlite, improvements to shot-scraper and appreciating datasette-dashboards
- 18th: Building a Covid sewage Twitter bot (and other weeknotes)
- 24th: Useful tricks with pip install URL and GitHub
- 27th: Weeknotes: Parallel SQL queries for Datasette, plus some middleware tricks
- 28th: Automatically opening issues when tracked file content changes
- May - 6 entries, 20 links
- 4th: Datasette Lite: a server-side Python web application running in a browser
- 6th: Weeknotes: Datasette Lite, nogil Python, HYTRADBOI
- 16th: Weeknotes: Camping, a road trip and two new museums
- 23rd: Bundling binary tools in Python wheels
- 26th: Weeknotes: Building Datasette Cloud on Fly Machines, Furo for documentation
- 31st: A Datasette tutorial written by GPT-3
- June - 8 entries, 7 links, 2 quotes
- 5th: How to use the GPT-3 language model
- 7th: Weeknotes: Datasette Cloud ready to preview
- 12th: A tiny web app to create images from OpenStreetMap maps
- 12th: Twenty years of my blog
- 19th: Weeknotes: datasette-socrata, and the last 10%...
- 20th: Joining CSV files in your browser using Datasette Lite
- 23rd: First impressions of DALL-E, generating images from text
- 30th: s3-ocr: Extract text from PDF files stored in an S3 bucket
- July - 4 entries, 25 links, 2 quotes
- August - 5 entries, 24 links, 2 quotes
- 11th: Litestream backups for Datasette Cloud (and weeknotes)
- 17th: Plugin support for Datasette Lite
- 21st: Analyzing ScotRail audio announcements with Datasette - from prototype to production
- 25th: Building a searchable archive for the San Francisco Microscopical Society
- 29th: Stable Diffusion is a really big deal
- September - 9 entries, 28 links, 9 quotes
- 1st: Notes on the SQLite DuckDB paper
- 5th: Exploring the training data behind Stable Diffusion
- 12th: Prompt injection attacks against GPT-3
- 16th: Weeknotes: Datasette Lite, s3-credentials, shot-scraper, datasette-edit-templates and more
- 16th: I don't know how to solve prompt injection
- 17th: You can't solve AI security problems with more AI
- 29th: Exploring 10m scraped Shutterstock videos used to train Meta's Make-A-Video text-to-video model
- 30th: A tool to run caption extraction against online videos using Whisper and GitHub Issues/Actions
- 30th: Weeknotes: Datasette Cloud preview invitations
- October - 8 entries, 28 links, 3 quotes
- 1st: Software engineering practices
- 5th: Is the AI spell-casting metaphor harmful or helpful?
- 12th: Weeknotes: Publishing data using Datasette Cloud
- 14th: Automating screenshots for the Datasette documentation using shot-scraper
- 19th: Measuring traffic during the Half Moon Bay Pumpkin Festival
- 23rd: Weeknotes: DjangoCon, SQLite in Django, datasette-gunicorn
- 27th: Datasette 0.63: The annotated release notes
- 29th: The Perfect Commit
- November - 8 entries, 18 links, 3 quotes
- 5th: It looks like I'm moving to Mastodon
- 6th: What to blog about
- 8th: Mastodon is just blogs
- 9th: Designing a write API for Datasette
- 13th: Datasette is 5 today: a call for birthday presents
- 20th: Tracking Mastodon user numbers over time with a bucket of tricks
- 23rd: Weeknotes: Implementing a write API, Mastodon distractions
- 26th: Coping strategies for the serial project hoarder
- December - 8 entries, 13 links, 5 quotes
- 2nd: Datasette's new JSON write API: The first alpha of Datasette 1.0
- 4th: A new AI game: Give me ideas for crimes to do
- 5th: AI assisted learning: Learning Rust with ChatGPT, Copilot and Advent of Code
- 5th: Weeknotes: datasette-ephemeral-tables, datasette-export
- 11th: Over-engineering Secret Santa with Python cryptography and Datasette
- 15th: Datasette 1.0a2: Upserts and finely grained permissions
- 20th: Weeknotes: Datasette 0.63.3, datasette-ripgrep
- 31st: 2022 in projects and blogging