Simon Willison: TILs on datasette

datasette Writing Playwright tests for a Datasette Plugin - 2024-01-08

I really like Playwright for writing automated tests for web applications using a headless browser. It's pretty easy to install and run, and it works well in GitHub Actions. …

datasette Running Datasette on Hugging Face Spaces - 2023-09-08

Julien Chaumond, this morning (replying to my tweet about my Hugging Face TheBloke model git scraper): …

datasette Remember to commit when using datasette.execute_write_fn() - 2023-08-31

I was writing some code for datasette-auth-tokens that used db.execute_write_fn() like this: …

datasette Using pytest-httpx to run intercepted requests through an in-memory Datasette instance - 2023-07-24

I've been working on a tool called dclient which is a CLI client tool for talking to Datasette instances. …

datasette Syntax highlighted code examples in Datasette - 2023-07-01

I wanted to add syntax highlighting to the new tutorial Data analysis with SQLite and Python. …

datasette Exploring Baseline with Datasette Lite - 2023-05-12

One of the announcements from Google I/O 2023 was Baseline, a new initiative to help simplify the challenge of deciding which web platform features are now widely enough supported by modern browsers to be safe to use. …

datasette Interactive row selection prototype with Datasette - 2023-03-30

I added a new llms tag to my blog, for my content about Large Language Models. …

datasette Scraping Reddit and writing data to the Datasette write API - 2023-03-13

Today I built a system for monitoring Reddit for new posts that link to various domains that I own. …

datasette Writing a CLI utility that is also a Datasette plugin - 2022-11-21

I'm working on dclient, a CLI tool for interacting with Datasette instances via the Datasette API. …

datasette Writing a Datasette CLI plugin that mostly duplicates an existing command - 2022-10-22

My new datasette-gunicorn plugin adds a new command to Datasette - datasette gunicorn - which mostly replicates the existing datasette serve command but with a few differences. …

datasette Registering new Datasette plugin hooks by defining them in other plugins - 2022-06-17

I'm experimenting with a Datasette plugin that itself adds new plugin hooks which other plugins can then interact with. …

datasette Crawling Datasette with Datasette - 2022-02-27

I wanted to add the new tutorials on https://datasette.io/tutorials to the search index that is used by the https://datasette.io/-/beta search engine. …

datasette Reusing an existing Click tool with register_commands - 2021-11-29

The register_commands plugin hook lets you add extra sub-commands to the datasette CLI tool. …

datasette Searching all columns of a table in Datasette - 2021-08-23

I came up with this trick today, when I wanted to run a LIKE search against every column in a table. …

datasette Running Datasette on Replit - 2021-05-02

I figured out how to run Datasette on https://replit.com/ …

datasette Querying for GitHub issues open for less than 60 seconds - 2021-03-12

While writing this thread about my habit of opening issues and closing them a few seconds later just so I could link to them in a commit message I decided to answer the question "How many of my issues were open for less than 60 seconds?" …

datasette Serving MBTiles with datasette-media - 2021-02-03

The MBTiles format uses SQLite to bundle map tiles for use with libraries such as Leaflet. …

datasette Redirects for Datasette - 2020-11-25

I made some changes to my https://til.simonwillison.net/ site that resulted in cleaner URL designs, so I needed to setup some redirects. I configured the redirects using a one-off Datasette plugin called redirects.py which I dropped into the plugins/ directory for the Datasette instance: …