Skip to main content
Avatar for Simon Willison from gravatar.com

Simon Willison

Username    simonw
Date joined   Joined on

102 projects

sqlite-utils

Last released on

CLI tool and Python utility functions for manipulating SQLite databases

dogsheep-beta

Last released on

Dogsheep search index

github-to-sqlite

Last released on

Save data from GitHub to a SQLite database

datasette

Last released on

An open source multi-tool for exploring and publishing data

datasette-ics

Last released on

Datasette plugin for outputting iCalendar files

datasette-copyable

Last released on

Datasette plugin for outputting tables in formats suitable for copy and paste

datasette-atom

Last released on

Datasette plugin that adds a .atom output format

datasette-yaml

Last released on

Export Datasette records as YAML

datasette-seaborn

Last released on

Statistical visualizations for Datasette using Seaborn

datasette-dns

Last released on

Custom SQL function for making DNS lookups

datasette-backup

Last released on

Plugin adding backup options to Datasette

sqlite-dump

Last released on

An improved version of .iterdump() for sqlite3

datasette-block-robots

Last released on

Datasette plugin that blocks all robots using robots.txt

airtable-export

Last released on

Export Airtable data to files on disk

asgi-csrf

Last released on

ASGI middleware for protecting against CSRF attacks

datasette-graphql

Last released on

Datasette plugin providing an automatic GraphQL API for your SQLite databases

datasette-render-images

Last released on

Datasette plugin that renders binary blob images using data-uris

shapefile-to-sqlite

Last released on

Load shapefiles into a SQLite (optionally SpatiaLite) database

datasette-auth-passwords

Last released on

Datasette plugin for authenticating access using passwords

datasette-leaflet-geojson

Last released on

A Datasette plugin that renders GeoJSON columns using Leaflet

datasette-schema-versions

Last released on

Datasette plugin that shows the schema version of every attached database

datasette-publish-vercel

Last released on

Datasette plugin for publishing data using Vercel

datasette-cluster-map

Last released on

Datasette plugin that shows a map for any data with latitude/longitude columns

datasette-saved-queries

Last released on

Datasette plugin that lets users save and execute queries

datasette-upload-csvs

Last released on

Datasette plugin for uploading CSV files and converting them to database tables

datasette-json-html

Last released on

Datasette plugin for rendering HTML based on JSON values

csvs-to-sqlite

Last released on

Convert CSV files into a SQLite database

datasette-insert-unsafe

Last released on

Unsafe permissions for datasette-insert - allows all actions without authentication

datasette-insert

Last released on

Datasette plugin for inserting and updating data

datasette-publish-now

Last released on

datasette-publish-now is now datasette-publish-vercel

datasette-media

Last released on

Datasette plugin for serving media based on a SQL query

db-to-sqlite

Last released on

CLI tool for exporting tables or queries from any SQL database to a SQLite file

datasette-insert-api

Last released on

datasette-insert-api is now datasette-insert

twitter-to-sqlite

Last released on

Save data from Twitter to a SQLite database

datasette-clone

Last released on

Create a local copy of database files from a Datasette instance

datasette-auth-tokens

Last released on

Datasette plugin for authenticating access using API tokens

datasette-plugin-demos

Last released on

Examples of plugins for Datasette

datasette-publish-fly

Last released on

Datasette plugin for publishing data using Fly

datasette-edit-tables

Last released on

Datasette plugin for renaming and deleting tables and columns and changing column types

datasette-configure-fts

Last released on

Datasette plugin for enabling full-text search against selected table columns

datasette-search-all

Last released on

Datasette plugin for searching all searchable tables at once

datasette-write

Last released on

Datasette plugin providing a UI for writing to a database

datasette-glitch

Last released on

Utilities to help run Datasette on Glitch

datasette-init

Last released on

Ensure specific tables and views exist on startup

datasette-allow-permissions-debug

Last released on

Always allow access to /-/permissions, for debugging

datasette-debug-asgi

Last released on

Datasette plugin for dumping out the ASGI scope

sqlite-generate

Last released on

Tool for generating demo SQLite databases

click-app-template-demo

Last released on

Demonstrating https://github.com/simonw/click-app

datasette-plugin-template-demo

Last released on

Demonstrating https://github.com/simonw/datasette-plugin

datasette-psutil

Last released on

Datasette plugin adding a /-/psutil debugging endpoint

datasette-permissions-sql

Last released on

Datasette plugin for configuring permission checks using SQL queries

asgi-auth-github

Last released on

ASGI middleware that authenticates users against GitHub

dogsheep-photos

Last released on

Save details of your photos to a SQLite database and upload them to S3

photos-to-sqlite

Last released on

Save details of your photos to a SQLite database and upload them to S3

datasette-render-markdown

Last released on

Datasette plugin for rendering Markdown

conditional-get

Last released on

CLI tool for fetching data using HTTP conditional get

datasette-template-sql

Last released on

Datasette plugin for executing SQL queries from templates

datasette-auth-existing-cookies

Last released on

Datasette plugin that authenticates users based on existing domain cookies

paginate-json

Last released on

CLI tool for fetching paginated JSON from a URL

datasette-mask-columns

Last released on

Datasette plugin that masks specified database columns

datasette-auth-github

Last released on

Datasette plugin and ASGI middleware that authenticates users against GitHub

datasette-jq

Last released on

Datasette plugin that adds custom SQL functions for executing jq expressions against JSON values

swarm-to-sqlite

Last released on

Create a SQLite database containing your checkin history from Foursquare Swarm

healthkit-to-sqlite

Last released on

Convert an Apple Healthkit export zip to a SQLite database

pocket-to-sqlite

Last released on

Create a SQLite database containing data from your Pocket account

inaturalist-to-sqlite

Last released on

Create a SQLite database containing your observation history from iNaturalist

hacker-news-to-sqlite

Last released on

Create a SQLite database containing data pulled from Hacker News

datasette-render-html

Last released on

Datasette plugin that renders specified cells as HTML

datasette-render-timestamps

Last released on

Datasette plugin for rendering timestamps

datasette-show-errors

Last released on

Datasette plugin for displaying error tracebacks

datasette-column-inspect

Last released on

Experimental Datasette plugin for inspecting columns

fec-to-sqlite

Last released on

Save FEC campaign finance data to a SQLite database

csv-diff

Last released on

Python CLI tool and library for diffing CSV files

asgi-log-to-sqlite

Last released on

ASGI middleware for logging traffic to a SQLite database

geojson-to-sqlite

Last released on

CLI tool for converting GeoJSON to SQLite (optionally with SpatiaLite)

datasette-sentry

Last released on

Datasette plugin for configuring Sentry

datasette-auth-cookie-api

Last released on

Datasette plugin that authenticates users by passing their cookies to an API

datasette-configure-asgi

Last released on

Datasette plugin for configuring arbitrary ASGI middleware

yaml-to-sqlite

Last released on

Utility for converting YAML files to SQLite

sqlite-transform

Last released on

Tool for running transformations on columns in a SQLite database.

datasette-haversine

Last released on

Datasette plugin that adds a custom SQL function for haversine distances

genome-to-sqlite

Last released on

Import your genome into a SQLite database

datasette-rure

Last released on

Datasette plugin that adds a custom SQL function for executing matches using the Rust regular expression engine

google-takeout-to-sqlite

Last released on

Save data from Google Takeout to a SQLite database

datasette-cors

Last released on

Datasette plugin for configuring CORS headers

asgi-debug

Last released on

ASGI middleware for debugging ASGI applications

sqlite-diffable

Last released on

Tools for dumping/loading a SQLite database to diffable directory structure

json-flatten

Last released on

Python functions for flattening a JSON object to a single dictionary of pairs, and unflattening that dictionary back to a JSON object

datasette-render-binary

Last released on

Datasette plugin for rendering binary data

delta-scraper

Last released on

Python library for scraping data sources and creating readable deltas

github-contents

Last released on

Python class for reading and writing data to a GitHub repository

datasette-bplist

Last released on

Datasette plugin for working with Apple's binary plist format

asgi-cors

Last released on

ASGI middleware for applying CORS headers to an ASGI application

validate-utf8

Last released on

Python library and CLI for validating UTF-8 text

datasette-jellyfish

Last released on

Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish

dbf-to-sqlite

Last released on

CLCLI tool for converting DBF files (dBase, FoxPro etc) to SQLite

markdown-to-sqlite

Last released on

CLI tool for loading markdown files into a SQLite database

datasette-pretty-json

Last released on

Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays

sqlite-fts4

Last released on

Python functions for working with SQLite FTS4 search

datasette-sqlite-fts4

Last released on

Datasette plugin exposing SQL functions from sqlite-fts4

datasette-vega

Last released on

A Datasette plugin that provides tools for generating charts using Vega

datasette-sql-scraper

Last released on

Experimental plugin for Datasette

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page