Via [this comment](https://news.ycombinator.com/item?id=34197637) on Hacker News I started exploring the [ClickHouse Playground](https://clickhouse...

For a Django application I'm working on ([this issue](https://github.com/simonw/django-sql-dashboard/issues/44)) I have a form that can be quite a ...

Day 85 of 90 Days of DevOps - DevOps Metrics and KPIs. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

I ran into problems with my AWS Lightsail instance: it exceeded the CPU burst quota for too long and was suspended, and I couldn't figure out how t...

I noticed this morning that one of my Datasette installations had the [Geopoly](https://www.sqlite.org/geopoly.html) SQLite extension enabled. I do...

When SQLite executes a query, it does so by executing a sequence of virtual machine operations.

Day 84 of 90 Days of DevOps - Continuous Learning Culture. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

For [Datasette Desktop](https://datasette.io/desktop) I chose to bundle a full version of Python 3.9 inside my `Datasette.app` application. I did t...

Day 83 of 90 Days of DevOps - Documentation and Knowledge Sharing. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

I wanted to create a file with a shell one-liner where the file lived somewhere owned by root.

Day 82 of 90 Days of DevOps - Team Collaboration and Communication. Part of the Best Practices & Culture series covering essential DevOps concepts and hands-on practices.

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

I wanted to grant a PostgreSQL user (or role) read-only access to a specific list of tables.

[Fly](https://fly.io/) has a GraphQL API which is used by some of their own tools - I found it while [browsing around their code](https://github.co...

I've been experimenting with a tool for generating the content for a weekly Substack newsletter by querying the Datasette API for my blog and assem...

Day 80 of 90 Days of DevOps - WebAssembly and Future Tech. Part of the Serverless & Advanced Topics series covering essential DevOps concepts and hands-on practices.

If you installed `datasette` using `pipx install datasette` you can install additional plugins with `pipx inject` like so:

I wanted to render some markdown in Python but with the following extra features:

This recipe runs a Python script to update a README, then commits it back to the parent repo but only if it has changed:

Day 79 of 90 Days of DevOps - Edge Computing and CDN. Part of the Serverless & Advanced Topics series covering essential DevOps concepts and hands-on practices.

Helping people setup development environments (and fix them when they break) can be incredibly frustrating. I'm really excited about cloud-based de...

Day 78 of 90 Days of DevOps - GraphQL and Modern APIs. Part of the Serverless & Advanced Topics series covering essential DevOps concepts and hands-on practices.

I wanted to run some Django tests - using `pytest-django` and with Django configured to pick up the `DATABASE_URL` environment variable via [dj-dat...

My [blog](https://simonwillison.net/) was showing poor performance, with some pages taking several seconds to load or even failing entirely.