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.

2020

Release datasette-edit-schema 0.1a — Datasette plugin for modifying table schemas
Release datasette-search-all 0.2.1 — Datasette plugin for searching all searchable tables at once

Weeknotes: COVID-19 numbers in Datasette

Visit Weeknotes: COVID-19 numbers in Datasette

COVID-19, the disease caused by the novel coronavirus, gets more terrifying every day. Johns Hopkins Center for Systems Science and Engineering (CSSE) have been collating data about the spread of the disease and publishing it as CSV files on GitHub.

[... 644 words]

Release datasette-column-inspect 0.1a — Experimental plugin that adds a column inspector

datasette-search-all: a new plugin for searching multiple Datasette tables at once

I just released a new plugin for Datasette, and it’s pretty fun. datasette-search-all is a plugin written mostly in JavaScript that executes the same search query against every searchable table in every database connected to your Datasette instance.

[... 819 words]

Release datasette-search-all 0.2 — Datasette plugin for searching all searchable tables at once
Release datasette-search-all 0.1.1 — Datasette plugin for searching all searchable tables at once
Release datasette-search-all 0.1 — Datasette plugin for searching all searchable tables at once
Release datasette 0.38 — An open source multi-tool for exploring and publishing data
Release datasette-configure-fts 0.4.2 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.4.1 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.4 — Datasette plugin for enabling full-text search against selected table columns

Weeknotes: datasette-ics, datasette-upload-csvs, datasette-configure-fts, asgi-csrf

I’ve been preparing for the NICAR 2020 Data Journalism conference this week which has lead me into a flurry of activity across a plethora of different projects and plugins.

[... 834 words]

Release datasette-ics 0.3a — Datasette plugin for outputting iCalendar files
Release datasette-upload-csvs 0.4 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette Datasette 0.37.1 — An open source multi-tool for exploring and publishing data
Release datasette-configure-fts 0.3.1a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.3a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.2a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.1.1a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.1a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-atom 0.4.1 — Datasette plugin that adds a .atom output format
Release datasette-upload-csvs 0.3 — Datasette plugin for uploading CSV files and converting them to database tables

Weeknotes: Datasette Writes

As discussed previously, the biggest hole in Datasette’s feature set at the moment involves writing to the database.

[... 604 words]

Release datasette Datasette 0.37 — An open source multi-tool for exploring and publishing data
Release datasette Datasette 0.36 — An open source multi-tool for exploring and publishing data
Release datasette-cluster-map 0.9 — Datasette plugin that shows a map for any data with latitude/longitude columns

How to cheat at unit tests with pytest and Black

I’ve been making a lot of progress on Datasette Cloud this week. As an application that provides private hosted Datasette instances (initially targeted at data journalists and newsrooms) the majority of the code I’ve written deals with permissions: allowing people to form teams, invite team members, promote and demote team administrators and suchlike.

[... 933 words]

Release datasette-upload-csvs 0.2a — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-auth-existing-cookies 0.6.1 — Datasette plugin that authenticates users based on existing domain cookies