Simon Willison’s Weblog

Subscribe
Atom feed for datasette Random

1,521 posts tagged “datasette”

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

2021

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
Release datasette-jupyterlite 0.1a0 — JupyterLite as a Datasette plugin

Weeknotes: Learning Kubernetes, learning Web Components

I’ve been mainly climbing the learning curve for Kubernetes and Web Components this week. I also released Datasette 0.59.1 with Python 3.10 compatibility and an updated Docker image.

[... 1,101 words]

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

Datasette 0.59: The annotated release notes

Visit Datasette 0.59: The annotated release notes

Datasette 0.59 is out, with a miscellaneous grab-bag of improvements. Here are the annotated release notes.

[... 2,103 words]

Where does all the effort go? Looking at Python core developer activity (via) Łukasz Langa used Datasette to explore 28,780 pull requests made to the CPython GitHub repository, using some custom Python scripts (and sqlite-utils) to load in the data.

# 18th October 2021, 8:21 pm / python, datasette, sqlite-utils, lukasz-langa

Release datasette-publish-vercel 0.11 — Datasette plugin for publishing data using Vercel
Release datasette-statistics 0.2 — SQL statistics functions for Datasette
Release datasette-auth-tokens 0.3 — Datasette plugin for authenticating access using API tokens
Release datasette 0.59 — An open source multi-tool for exploring and publishing data
Release datasette-template-request 0.1 — Expose the Datasette request object to custom templates
Release datasette-notebook 0.1a1 — A markdown wiki and dashboarding system for Datasette
Release datasette-notebook 0.1a0 — A markdown wiki and dashboarding system for Datasette
Release datasette-render-markdown 2.0 — Datasette plugin for rendering Markdown

Weeknotes number 100

This entry marks my 100th weeknotes, which I’ve managed to post once a week (plus or minus a few days) consistently since 13th September 2019.

[... 593 words]

Release datasette-statistics 0.1.1 — SQL statistics functions for Datasette
Release datasette-statistics 0.1 — SQL statistics functions for Datasette

Datasette Desktop 0.2.0: The annotated release notes

Visit Datasette Desktop 0.2.0: The annotated release notes

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 SQLite. I released the first version last week—I’ve just released version 0.2.0 (and a 0.2.1 bug fix) with a whole bunch of critical improvements.

[... 2,208 words]

Release datasette-app 0.2.1 — The Datasette macOS application
Release datasette-app-support 0.11.5 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.11.4 — Part of https://github.com/simonw/datasette-app
Release datasette-app 0.2.0 — The Datasette macOS application
Release datasette-app-support 0.11.3 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.11.2 — Part of https://github.com/simonw/datasette-app