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: SBA Covid-19 PPP loans, Datasette talks, Datasette plugin upgrades

Visit Weeknotes: SBA Covid-19 PPP loans, Datasette talks, Datasette plugin upgrades

This week I’ve mainly been exploring Small Business Administration Covid-19 loans data, pitching some talks and upgrading some plugins for compatibility with Datasette 0.44+.

[... 524 words]

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

sba-loans-covid-19-datasette (via) The treasury department released a bunch of data on the Covid-19 SBA Paycheck Protection Program Loan recipients today—I’ve loaded the most interesting data (the $150,000+ loans) into a Datasette instance.

# 7th July 2020, 2:42 am / projects, covid19, data-journalism, datasette

Release datasette-edit-schema 0.2a — Datasette plugin for modifying table schemas
Release datasette-configure-fts 1.0 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-search-all 0.3 — Datasette plugin for searching all searchable tables at once
Release datasette-write 0.1 — Datasette plugin providing a UI for executing SQL writes against the database
Release datasette-saved-queries 0.2 — Datasette plugin that lets users save and execute queries
Release datasette-glitch 0.1 — Utilities to help run Datasette on Glitch

Datasette 0.45: The annotated release notes

Datasette 0.45, out today, features magic parameters for canned queries, a log out feature, improved plugin documentation and four new plugin hooks.

[... 863 words]

Release datasette 0.45 — An open source multi-tool for exploring and publishing data
Release datasette-auth-tokens 0.2.1 — Datasette plugin for authenticating access using API tokens
Release datasette-auth-tokens 0.2 — Datasette plugin for authenticating access using API tokens
Release datasette 0.45a5 — An open source multi-tool for exploring and publishing data
Release datasette-allow-permissions-debug 0.1 — Always allow access to /-/permissions, for debugging
Release datasette-init 0.1a3 — Ensure specific tables and views exist on startup
Release datasette-debug-asgi 0.1.1 — Datasette plugin for dumping out the ASGI scope
Release datasette-write 0.1a — Datasette plugin providing a UI for executing SQL writes against the database
Release datasette 0.45a4 — An open source multi-tool for exploring and publishing data
Release datasette-init 0.1a2 — Ensure specific tables and views exist on startup
Release datasette-init 0.1a — Ensure specific tables and views exist on startup
Release datasette-glitch 0.1a — Utilities to help run Datasette on Glitch
Release datasette 0.45a3 — An open source multi-tool for exploring and publishing data

Weeknotes: cookiecutter templates, better plugin documentation, sqlite-generate

I spent this week spreading myself between a bunch of smaller projects, and finally getting familiar with cookiecutter. I wrote about my datasette-plugin cookiecutter template earlier in the week; here’s what else I’ve been working on.

[... 703 words]

Release datasette 0.45a2 — An open source multi-tool for exploring and publishing data
Release datasette-block-robots 0.1.1 — Datasette plugin that blocks robots and crawlers using robots.txt

datasette-block-robots. Another little Datasette plugin: this one adds a /robots.txt page with Disallow: / to block all indexing of a Datasette instance from respectable search engine crawlers. I built this in less than ten minutes from idea to deploy to PyPI thanks to the datasette-plugin cookiecutter template.

# 23rd June 2020, 3:28 am / projects, robots-txt, plugins, seo, datasette, crawling

Release datasette-block-robots 0.1 — Datasette plugin that blocks robots and crawlers using robots.txt

A cookiecutter template for writing Datasette plugins

Datasette’s plugin system is one of the most interesting parts of the entire project. As I explained to Matt Asay in this interview, the great thing about plugins is that Datasette can gain new functionality overnight without me even having to review a pull request. I just need to get more people to write them!

[... 914 words]

Release datasette-saved-queries 0.1 — Datasette plugin that lets users save and execute queries