Original: Simon Willison · 24/05/2026
Summary
The article introduces the datasette-fixtures 0.1a0 plugin, which utilizes a new helper for creating fixture database tables in Datasette’s tests.Key Insights
“New documented datasette.fixtures.populate_fixture_database(conn) helper for creating the fixture database tables” — Describing the new feature in Datasette 1.0a30.
“This new plugin takes advantage of that API.” — Explaining the purpose of the datasette-fixtures plugin.
“You can try it out using uvx without even installing Datasette.” — Instructions on how to test the new plugin.
Topics
Full Article
One of the smaller features in Datasette 1.0a30 is this: New documented datasette.fixtures.populate_fixture_database(conn) helper for creating the fixture database tables used by Datasette’s own tests, intended for plugin test suites. This new plugin takes advantage of that API. You can try it out using uvx without even installing Datasette like this: uvx —prerelease=allow \ —with datasette-fixtures datasette \ —get /fixtures/roadside_attractions.json Which outputs: { “ok”: true, “next”: null, “rows”: [ {“pk”: 1, “name”: “The Mystery Spot”, “address”: “465 Mystery Spot Road, Santa Cruz, CA 95065”, “url”: “https://www.mysteryspot.com/”, “latitude”: 37.0167, “longitude”: -122.0024}, {“pk”: 2, “name”: “Winchester Mystery House”, “address”: “525 South Winchester Boulevard, San Jose, CA 95128”, “url”: “https://winchestermysteryhouse.com/”, “latitude”: 37.3184, “longitude”: -121.9511}, {“pk”: 3, “name”: “Burlingame Museum of PEZ Memorabilia”, “address”: “214 California Drive, Burlingame, CA 94010”, “url”: null, “latitude”: 37.5793, “longitude”: -122.3442}, {“pk”: 4, “name”: “Bigfoot Discovery Museum”, “address”: “5497 Highway 9, Felton, CA 95018”, “url”: “https://www.bigfootdiscoveryproject.com/”, “latitude”: 37.0414, “longitude”: -122.0725} ], “truncated”: false }Related Articles
Release: datasette 1.0a29
Simon Willison · reference · 63% similar
Release: datasette 1.0a27
Simon Willison · reference · 61% similar
Release: datasette 1.0a28
Simon Willison · reference · 61% similar
Originally published at https://simonwillison.net/2026/May/24/datasette-fixtures/#atom-everything.