This tip is for when you are working on a Python command-line application that runs using that program's name, as opposed to typing `python my_scri...

I was trying to use `group_concat()` to glue together some column values into a stiched together Markdown document. My first attempt looked like this:

Carelessly including the output of `json.dumps()` in an HTML page can lead to an XSS hole, thanks to the following:

I tried out [rqlite](https://github.com/rqlite/rqlite) today, a "lightweight, distributed relational database, which uses SQLite as its storage eng...

I ran https://simonwillison.net/ through [PageSpeed Insights](https://pagespeed.web.dev/) and it warned me that my static assets were not being ser...

When comparing secrets, passwords etc it's important to use a constant-time compare function to avoid timing attacks.

I wanted to redirect https://global-power-plants.datasettes.com/ to https://datasette.io/ - I decided to spin up a Cloudflare Pages site to do the ...

I figured out how to use a JSON API to run a very limited Google search today in a legit, non-screen-scraper way.