I figured out this pattern today for testing an HTML table dynamically added to a page by JavaScript, using [Playwright Python](https://playwright....

I wanted to use the GitHub GraphQL API to return all of the repositories on the https://github.com/topics/git-scraping page.

I found myself wanting to register more than one instance of a [Pluggy](https://pluggy.readthedocs.io/) plugin hook inside a single module.

While [working on this issue](https://github.com/simonw/datasette/issues/2461) I figured out a neat pattern for running the tests for my project lo...

I found an MP3 recording of an old talk I gave and decided to use the slides from that talk to create a video using iMovie.

Chris Coyier [wrote about](https://chriscoyier.net/2023/09/29/css-solves-auto-expanding-textareas-probably-eventually/) the new `form-sizing: norma...

I have a text column which contains comma-separated values - inherited from an older database schema.

For [google-drive-to-sqlite](https://github.com/simonw/google-drive-to-sqlite) I wanted a mechanism to recursively return metadata on every file in...

Day 96 of 90 Days of DevOps - 90 Days Recap and Next Steps. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

Day 95 of 90 Days of DevOps - DevOps Success Stories. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

I wanted the ability to test my Python software against specific version of SQLite on macOS. I found a way to do that using [pysqlite3](https://git...

[Steampipe](https://steampipe.io/) build software that lets you query different APIs directly from SQL databases.

Day 94 of 90 Days of DevOps - DevOps Future Trends. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

Day 93 of 90 Days of DevOps - DevOps Resources and References. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

I [decided to add](https://github.com/simonw/datasette-lite/issues/35) automated tests to my [Datasette Lite](https://simonwillison.net/2022/May/4/...

Day 92 of 90 Days of DevOps - DevOps Certifications and Training. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

I wanted to start [a new git repository](https://github.com/simonw/graphql-scraper/tree/828a1efc4307cca6cd378c394c2d33eac2eceb52) containing just t...

Day 91 of 90 Days of DevOps - Community Contributions and Open Source. Part of the Community & Learning series covering essential DevOps concepts and hands-on practices.

For [sqlite-utils issue 250](https://github.com/simonw/sqlite-utils/issues/250) I needed to locate some test CSV files that start with a UTF-8 BOM.

Datasette's [release notes](https://github.com/simonw/datasette/blob/main/docs/changelog.rst) are formatted using Sphinx. Almost every bullet point...

[django-sql-dashboard](https://github.com/simonw/django-sql-dashboard) lets you define a SQL query plus one or more text inputs that the user can p...

Day 90 of 90 Days of DevOps - DevOps Career Path and Growth. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

Day 89 of 90 Days of DevOps - DevOps Tools Ecosystem. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

I live in El Granada, California. Wikipedia calls us [a census designated place](https://en.wikipedia.org/wiki/El_Granada,_California) - we don't h...