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