https://simonwillison.net/2021/Mar/28/weeknotes/
This week I got SpatiaLite 5 working in the Datasette Docker image, improved the CDC vaccination history git scraper, figured out Datasette on Azure and we...
weeknotesdatasetteazurecdcvaccination
https://simonwillison.net/2019/Jun/23/datasette-asgi/
This evening I finally closed a Datasette issue that I opened more than 13 months ago: #272: Port Datasette to ASGI. A few notes on why this is such an …
portingdatasetteturtlesway
https://datasette.io/plugins/datasette-gzip
Add gzip compression to Datasette
datasettegzipplugin
https://simonwillison.net/2025/Jan/22/office-hours-demos/
Last Friday Alex Garcia and I hosted a new kind of Datasette Public Office Hours session, inviting members of the Datasette community to share short demos of...
short videosixdemosllmdatasette
https://datasette.io/plugins/datasette-ripgrep
Web interface for searching your code using ripgrep, built as a Datasette plugin
datasetteplugin
https://simonwillison.net/2021/Feb/4/datasette-tiles/
Working on datasette-leaflet last week re-kindled my interest in using Datasette as a GIS (Geographic Information System) platform. SQLite already has strong...
servingmaptilessqlitedatasette
https://simonwillison.net/2022/Sep/16/weeknotes/
Despite distractions from AI I managed to make progress on a bunch of different projects this week, including new releases of s3-credentials and shot-scraper,...
weeknotesdatasettelitecredentialsshot
https://simonwillison.net/2021/Jan/10/weeknotes/
What a terrible week. I’ve found it hard to concentrate on anything substantial. In a mostly futile attempt to distract myself from doomscrolling I’ve...
weeknotesdatasetteexportnotebookpackaged
https://datasette.io/plugins/datasette-search-all
Datasette plugin for searching all searchable tables at once
datasettesearchplugin
https://simonwillison.net/2023/Jan/13/semantic-search-answers/
If you’ve spent any time with GPT-3 or ChatGPT, you’ve likely thought about how useful it would be if you could point them at a specific, current...
implementqampdocumentation
https://simonwillison.net/2022/Oct/14/automating-screenshots/
I released shot-scraper back in March as a tool for keeping screenshots in documentation up-to-date. It’s very easy for feature screenshots in documentation...
automatingscreenshotsdatasettedocumentationusing
https://simonwillison.net/2025/Nov/6/upgrading-datasette-plugins/
I’m upgrading various plugins for compatibility with the new Datasette 1.0a20 alpha release and I decided to record a video of the process. This post...
videonotesupgradingdatasetteplugin
https://simonwillison.net/2020/Aug/28/weeknotes-cpad/
This week I built a geospatial search engine for protected areas in California, shipped datasette-graphql 1.0 and started working towards the next milestone...
protected areasweeknotescaliforniadatasette
https://simonwillison.net/2026/Feb/17/chartroom-and-datasette-showboat/
I introduced Showboat a week ago—my CLI tool that helps coding agents create Markdown documents that demonstrate the code that they have created. I’ve been...
twonewshowboattoolsdatasette
https://simonwillison.net/2020/Dec/19/dogsheep-beta/
This week I added a search engine to datasette.io, using the search indexing tool I’ve been building for Dogsheep. Project search for Datasette The Datasette...
search enginebuildingdatasetteio
https://simonwillison.net/2023/Dec/8/weeknotes/
I’ve mainly been working on Datasette Enrichments and continuing to explore the possibilities enabled by sqlite-chronicle. Enrichments This is the biggest...
weeknotesdatasettecommentssqlitechronicle
https://simonwillison.net/2022/May/4/datasette-lite/
Datasette Lite is a new way to run Datasette: entirely in a browser, taking advantage of the incredible Pyodide project which provides Python compiled to...
web applicationdatasetteliteserverside
https://datasette.io/plugins/datasette-vega
Datasette plugin for visualizing data using Vega
datasettevegaplugin
https://simonwillison.net/2024/May/7/datasette-secrets/
I introduced datasette-secrets two weeks ago. The core idea is to provide a way for end-users to store secrets such as API keys in Datasette, allowing other...
weeknotesdatasettesecretsplusmystery
https://datasette.io/plugins/datasette-ics
Datasette plugin for outputting iCalendar files
datasetteicsplugin
https://simonwillison.net/2021/Oct/19/datasette-059/
Datasette 0.59 is out, with a miscellaneous grab-bag of improvements. Here are the annotated release notes. Column metadata Columns can now have associated...
release notesdatasetteannotated
https://simonwillison.net/2020/Dec/13/datasette-io/
This week I launched datasette.io—the new official project website for Datasette. Datasette’s first open source release was just over three years ago, but...
project websitedatasetteioofficial
https://www.thingiverse.com/thing:5237077
Feb 7, 2022 - These are 3D models of 2 different gears for Philips D6450 datasette (automatic cassette player/recorder). I also include the 3D models of both gears
gearsetphilipsthingiverse
https://simonwillison.net/tags/datasette/
455 posts tagged ‘datasette’. Datasette is an open source tool for exploring and publishing data.
simon willisondatasette
https://simonwillison.net/2021/Aug/30/datasette-app/
This week I started experimenting with a desktop application version of Datasette—with the goal of providing people who aren’t comfortable with the...
desktop applicationbuildingdatasetteweeknotes
https://datasette.io/plugins/datasette-pyinstrument
Use pyinstrument to analyze Datasette page performance
datasetteplugin
https://simonwillison.net/2020/Nov/28/datasette-ripgrep/
This week I built datasette-ripgrep—a web application for running regular expression searches against source code, built on top of the amazing ripgrep...
regular expressionsearch enginedatasettedeploy
https://simonwillison.net/2023/Aug/16/datasette-cloud-weeknotes/
Datasette Cloud is now a significant step closer to general availability. The Datasette 1.03 alpha release is out, with a mostly finalized JSON format for 1.0....
datasettecloudllmmlc
https://simonwillison.net/2023/Oct/30/weeknotes/
I wrote a lot this week. I also did some fun research into new options for self-hosting vector maps and pushed out several new releases of plugins. On the blog...
e
https://simonwillison.net/2023/Aug/5/weeknotes-plugins/
The principle theme for the past few weeks has been plugins. Llama 2 in LLM via plugins I added the ability to support models other than the OpenAI ones to …
weeknotespluginsllmsqliteutils
https://simonwillison.net/2021/Sep/8/datasette-desktop/
I just released version 0.1.0 of the new Datasette macOS desktop application, the first version that end-users can easily install. I would very much appreciate...
desktop applicationdatasettemacos
https://simonwillison.net/2021/Nov/5/datasette-jupyterlite/
My big project this week was s3-credentials, described yesterday—but I also put together a fun expermiental Datasette plugin bundling JupyterLite and wrote...
weeknotesdatasettecredentialspythonpackaging
https://datasette.io/tutorials/learn-sql
Learn how to use Datasette to write your own custom SQL queries
learn sqldatasettetutorial
https://simonwillison.net/2024/Aug/5/datasette-1a14/
Released today: Datasette 1.0a14. This alpha includes significant contributions from Alex Garcia, including some backwards-incompatible changes in the run-up...
release notesdatasetteannotated
https://datasette.io/plugins/datasette-leaflet-freedraw
Draw polygons on maps in Datasette
datasetteleafletplugin
https://simonwillison.net/2021/Feb/7/video/
I put together a 17 minute video introduction to Datasette and sqlite-utils for FOSDEM 2021, showing how you can use Datasette to explore data, and...
videointroductiondatasettesqliteutils
https://fosstodon.org/@datasette
34 Posts, 2 Following, 897 Followers · An open source multi-tool for exploring and publishing data
datasettefosstodonorg
https://datasette.io/plugins/datasette-graphql
Datasette plugin providing an automatic GraphQL API for your SQLite databases
datasettegraphqlplugin
https://datasette.io/plugins/datasette-copyable
Datasette plugin for outputting tables in formats suitable for copy and paste
datasetteplugin
https://simonwillison.net/2023/Dec/1/datasette-enrichments/
Today I’m releasing datasette-enrichments, a new feature for Datasette which provides a framework for applying “enrichments” that can augment your data....
datasettenewpluginframework
https://simonwillison.net/2021/Jan/7/css-apis-no-javascript/
I built a new Datasette plugin called datasette-css-properties. It’s very, very weird—it adds a .css output extension to Datasette which outputs the result...
apiscsswithoutjavascriptdatasette
https://datasette.io/plugins/datasette-cluster-map
Datasette plugin that shows a map for any data with latitude/longitude columns
datasetteclustermapplugin
https://simonwillison.net/2021/Sep/13/datasette-desktop-2/
Datasette Desktop is a new macOS desktop application version of Datasette, an “open source multi-tool for exploring and publishing data” built on top of...
release notesdatasettedesktopannotated
https://datasette.io/plugins/datasette-tiles
Mapping tile server for Datasette, serving tiles from MBTiles packages
datasettetilesplugin
https://simonwillison.net/2024/Aug/22/optimizing-datasette/
I’ve been working with Alex Garcia on an experiment involving using Datasette to explore FEC contributions. We currently have a 11GB SQLite...
datasetteweeknotes
https://datasette.io/plugins/datasette-comments
A Datasette plugin for commenting on data in tables
datasettecommentsplugin
https://datasette.io/
Datasette is a tool for exploring and publishing data. It helps people take data of any shape, analyze and explore it, and publish it as an interactive website...
open sourcedatasettemultitoolexploring
https://datasette.io/plugins/datasette-json-html
Datasette plugin for rendering HTML based on JSON values
json htmldatasetteplugin
https://simonwillison.net/2025/Nov/4/datasette-10a20/
Datasette 1.0a20 is out with the biggest breaking API change on the road to 1.0, improving how Datasette’s permissions system works by migrating permission...
newsqlpoweredpermissionssystem
https://simonwillison.net/2023/Jan/30/datasette-scraper/
In addition to exploring the new MusicCaps training and evaluation data I’ve been working on the big Datasette JSON refactor, and getting excited about a...
local newsdatasettescraperbigweeknotes
https://datasette.io/tools/s3-ocr
Tools for running OCR against files stored in S3
ocrtooldatasette
https://datasette.io/plugins/datasette-plot
A Datasette plugin for making data visualizations with Observable Plot
datasetteplotplugin
https://datasette.io/plugins/datasette-dashboards
Datasette plugin to create interactive dashboards
datasettedashboardsplugin
https://simonwillison.net/2023/Feb/9/weeknotes/
The Datasette table view refactor, JSON redesign and ?_extra= continues this week, mainly in this ongoing pull request and this tracking issue. I’ve also...
weeknotesbunchthingslearnedplus
https://datasette.io/plugins/datasette-jupyterlite
JupyterLite as a Datasette plugin
datasetteplugin
https://simonwillison.net/2022/Jun/20/datasette-lite-csvs/
I added a new feature to Datasette Lite—my version of Datasette that runs entirely in your browser using WebAssembly (previously): you can now use it to load...
csv filesjoiningbrowserusingdatasette
https://simonwillison.net/2023/Mar/24/datasette-chatgpt-plugin/
Yesterday OpenAI announced support for ChatGPT plugins. It’s now possible to teach ChatGPT how to make calls out to external APIs and use the responses to...
chatgpt pluginanswer questionsbuiltdata