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.

2020

Weeknotes: Working on my screenplay

I’m taking an Introduction to Screenwriting course with Adam Tobin at Stanford, and my partial screenplay is due this week. I’m pulling together some scenes that tell the story of the Russian 1917 February Revolution and the fall of the Tsar through the lens of the craftsmen working on the Tsar’s last Fabergé egg. So I’ve not been spending much time on anything else.

[... 226 words]

Release datasette-media 0.1 — Datasette plugin for serving media based on a SQL query
Release datasette 0.42 — An open source multi-tool for exploring and publishing data

Datasette table diagram, now with a DOT graph (via) Thomas Ballinger shared a huge improvement to my Observable notebook for rendering a diagram of a collection of Datasette tables. He showed how to use the DOT language to render a full schema digram with arrows joining together the different tables. I’ve applied his changes to my notebook.

# 8th May 2020, 3:23 am / observable, datasette, visualization

Release datasette-media 0.1a — Datasette plugin for serving media based on a SQL query

Weeknotes: Datasette 0.41, photos breakthroughs

Visit Weeknotes: Datasette 0.41, photos breakthroughs

Shorter weeknotes this week, because my main project for the week warrants a detailed write-up on its own (coming soon... update 21st May here it is).

[... 867 words]

Release datasette-publish-vercel 0.5.1 — Datasette plugin for publishing data using Vercel
Release datasette 0.41 — An open source multi-tool for exploring and publishing data

How to install and upgrade Datasette using pipx (via) I’ve been using pipx to run Datasette for a while now—it’s a neat Python packaging tool which installs a Python CLI command with all of its dependencies in its own isolated virtual environment. Today, thanks to Twitter, I figured out how to install and upgrade plugins in the same environment—so I added a section to the Datasette installation documentation about it.

# 4th May 2020, 7:23 pm / datasette, pip, python

github-to-sqlite 2.2 highlights thread. I released github-to-sqlite 2.2 today with a new “stargazers” command for importing users who have starred one or more specific repositories. This Twitter thread lists highlights of recent releases and links to a live Datasette demo that shows what the tool can do.

# 2nd May 2020, 10:16 pm / projects, dogsheep, datasette, github

Release datasette-render-markdown 1.1.2 — Datasette plugin for rendering Markdown
Release datasette-atom 0.5 — Datasette plugin that adds a .atom output format

Weeknotes: Archiving coronavirus.data.gov.uk, custom pages and directory configuration in Datasette, photos-to-sqlite

I mainly made progress on three projects this week: Datasette, photos-to-sqlite and a cleaner way of archiving data to a git repository.

[... 1,132 words]

Weeknotes: Datasette 0.40, various projects, Dogsheep photos

A new release of Datasette, two new projects and progress towards a Dogsheep photos solution.

[... 826 words]

Release datasette-publish-vercel 0.5 — Datasette plugin for publishing data using Vercel
Release datasette 0.40 — An open source multi-tool for exploring and publishing data
Release datasette-template-sql 1.0.1 — Datasette plugin for executing SQL queries from templates
Release datasette-template-sql 1.0 — Datasette plugin for executing SQL queries from templates

Using a self-rewriting README powered by GitHub Actions to track TILs

Visit Using a self-rewriting README powered by GitHub Actions to track TILs

I’ve started tracking TILs—Today I Learneds—inspired by this five-year-and-counting collection by Josh Branchaud on GitHub (found via Hacker News). I’m keeping mine in GitHub too, and using GitHub Actions to automatically generate an index page README in the repository and a SQLite-backed search engine.

[... 1,100 words]

Release datasette-publish-vercel 0.4.1a — Datasette plugin for publishing data using Vercel

Weeknotes: Hacking on 23 different projects

I wrote a lot of code this week: 184 commits over 23 repositories! I’ve also started falling for Zeit Now v2, having found workarounds for some of my biggest problems with it.

[... 901 words]

Release datasette-auth-existing-cookies 0.7 — Datasette plugin that authenticates users based on existing domain cookies
Release datasette-clone 0.4.1 — Create a local copy of database files from a Datasette instance
Release datasette-clone 0.4 — Create a local copy of database files from a Datasette instance
Release datasette-mask-columns 0.2 — Datasette plugin that masks specified database columns
Release datasette-mask-columns 0.1 — Datasette plugin that masks specified database columns
Release datasette-clone 0.3 — Create a local copy of database files from a Datasette instance

datasette-clone

I released a fun little Datasette utility today: datasette-clone.

[... 379 words]

Release datasette-clone 0.2 — Create a local copy of database files from a Datasette instance
Release datasette-clone 0.1 — Create a local copy of database files from a Datasette instance