Simon Willison’s Weblog

Subscribe
Atom feed for datasette Random

1,455 posts tagged “datasette”

Datasette is an open source tool for exploring and publishing data.

2022

Datasette 0.60: The annotated release notes

I released Datasette 0.60 today. It’s a big release, incorporating 61 commits and 18 issues. Here are the annotated release notes.

[... 1,119 words]

Release datasette-leaflet-freedraw 0.3 — Draw polygons on maps in Datasette
Release datasette 0.60 — An open source multi-tool for exploring and publishing data
Release datasette-graphql 2.0.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

2021

Weeknotes: datasette-tiddlywiki, filters_from_request

Visit Weeknotes: datasette-tiddlywiki, filters_from_request

I made some good progress on the big refactor this week, including extracting some core logic out into a new Datasette plugin hook. I also got distracted by TiddlyWiki and released a new Datasette plugin that lets you run TiddlyWiki inside Datasette.

[... 1,197 words]

Release datasette-tiddlywiki 0.1 — Run TiddlyWiki in Datasette and save Tiddlers to a SQLite database
Release datasette 0.60a1 — An open source multi-tool for exploring and publishing data
Release datasette 0.60a0 — An open source multi-tool for exploring and publishing data

Weeknotes: Trapped in an eternal refactor

Visit Weeknotes: Trapped in an eternal refactor

I’m still working on refactoring Datasette’s table view. In doing so I spun out a new plugin, datasette-pretty-traces, which improves Datasette’s tooling for seeing the SQL that was executed to build a specific page.

[... 544 words]

Weeknotes: git-history, bug magnets and s3-credentials --public

I’ve stopped considering my projects “shipped” until I’ve written a proper blog entry about them, so yesterday I finally shipped git-history, coinciding with the release of version 0.6—a full 27 days after the first 0.1.

[... 1,013 words]

git-history: a tool for analyzing scraped data collected using Git and SQLite

Visit git-history: a tool for analyzing scraped data collected using Git and SQLite

I described Git scraping last year: a technique for writing scrapers where you periodically snapshot a source of data to a Git repository in order to record changes to that source over time.

[... 2,002 words]

Release datasette-cluster-map 0.17.2 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette-hovercards 0.1a0 — Add preview hovercards to links in Datasette

Weeknotes: Shaving some beautiful yaks

Visit Weeknotes: Shaving some beautiful yaks

I’ve been mostly shaving yaks this week—two in particular: the Datasette table refactor and the next release of git-history. I also built and released my first Web Component!

[... 1,307 words]

Release datasette 0.59.4 — An open source multi-tool for exploring and publishing data
Release datasette-table 0.1.0 — A Web Component for embedding a Datasette table on a page

Weeknotes: Apache proxies in Docker containers, refactoring Datasette

Updates to six major projects this week, plus finally some concrete progress towards Datasette 1.0.

[... 1,630 words]

Release datasette-publish-vercel 0.12 — Datasette plugin for publishing data using Vercel
Release datasette 0.59.3 — An open source multi-tool for exploring and publishing data
Release datasette-redirect-to-https 0.1 — Datasette plugin that redirects all non-https requests to https
Release datasette-graphql 2.0 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

Weeknotes: git-history, created for a Git scraping workshop

Visit Weeknotes: git-history, created for a Git scraping workshop

My main project this week was a 90 minute workshop I delivered about Git scraping at Coda.Br 2021, a Brazilian data journalism conference, on Friday. This inspired the creation of a brand new tool, git-history, plus smaller improvements to a range of other projects.

[... 1,239 words]

Release datasette 0.59.2 — An open source multi-tool for exploring and publishing data
Release datasette-hello-world 0.1.1 — The hello world of Datasette plugins

Datasette is four years old today. I marked the occasion with a short Twitter thread about the project so far.

# 13th November 2021, 6:14 pm / datasette

AWS IAM definitions in Datasette (via) As part of my ongoing quest to conquer IAM permissions, I built myself a Datasette instance that lets me run queries against all 10,441 permissions across 280 AWS services. It’s deployed by a build script running in GitHub Actions which downloads a 8.9MB JSON file from the Salesforce policy_sentry repository—policy_sentry itself creates that JSON file by running an HTML scraper against the official AWS documentation!

# 6th November 2021, 3:47 am / aws, datasette

Release datasette-jupyterlite 0.1a1 — JupyterLite as a Datasette plugin

Weeknotes: datasette-jupyterlite, s3-credentials and a Python packaging talk

Visit Weeknotes: datasette-jupyterlite, s3-credentials and a Python packaging talk

My big project this week was s3-credentials, described yesterday—but I also put together a fun expermiental Datasette plugin bundling JupyterLite and wrote up my PyGotham talk on Python packaging.

[... 476 words]

Release datasette-notebook 0.2a0 — A markdown wiki and dashboarding system for Datasette
Release datasette-notebook 0.1a2 — A markdown wiki and dashboarding system for Datasette