In reading [Scraping JSON, HTML, and ZIP Files with Pure SQLite](https://observablehq.com/@asg017/scrape-json-html-zip-with-sqlite) by Alex Garcia ...

I stumbled across this API today: https://docs.datasette.io/_/api/v2/docsearch/?q=startup&project=datasette&version=stable&language=en

Day 32 of 90 Days of DevOps - Docker Images and Dockerfile Best Practices. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.

While trying to use [pysqlite3](https://github.com/coleifer/pysqlite3) on macOS I got the following error:

Django 3.1 introduces PostgreSQL `search_type="websearch"` - which gives you search with advanced operators like `"phrase search" -excluding`. Jame...

Today I heard about the [sqlite3-rsync](https://sqlite.org/draft/rsync.html) command, currently available in a branch in the SQLite code repository...

Day 31 of 90 Days of DevOps - Docker Fundamentals and Containers. Part of the Containerization & Orchestration series covering essential DevOps concepts and hands-on practices.

If you [implement Auth0](https://til.simonwillison.net/auth0/oauth-with-auth0) for login, you may be tempted to skip implementing logout. I started...

Day 30 of 90 Days of DevOps - GitOps and Declarative Infrastructure. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.

`lsof` stands for "list open files". Here are some very basic usage notes for the version that ships with macOS.

TIL the Python standard library [struct](https://docs.python.org/3/library/struct.html) module defaults to interpreting binary strings using the en...

Day 29 of 90 Days of DevOps - IaC Testing and Validation. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.

I was getting this intermittent error running my Datasette test suite:

Day 28 of 90 Days of DevOps - Configuration Management at Scale. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.

I've been using [Postgres.app](https://postgresapp.com/) to run PostgreSQL on my Mac for years. I like that it's easy to install, gives me a task t...

I spotted a neat looking project links section on https://pypi.org/project/ExifReader/

Day 27 of 90 Days of DevOps - Ansible Vault and Security. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.

I spotted an intriguing note in the release notes for [osxphotos 0.51.7](https://github.com/RhetTbull/osxphotos/releases/tag/v0.51.7):

I've been experimenting with the HTML [dialog element](https://developer.mozilla.org/en-US/docs/Web/HTML/Element/dialog) recently, for example in m...

I really like [Playwright](https://playwright.dev/) for writing automated tests for web applications using a headless browser. It's pretty easy to ...

Tiny TIL today: I learned how to make an HTTP call to an IPv6 address. The trick is to enclose the address in the URL in square braces:

Tip via Mark Norman Francis [on Twitter](https://twitter.com/cackhanded/status/1423526489623044098):

Day 26 of 90 Days of DevOps - Ansible Roles and Galaxy. Part of the Infrastructure as Code series covering essential DevOps concepts and hands-on practices.

[Datasette](https://datasette.io/) is implemented as an ASGI application.