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

Simon Willison

Username    simonw
Date joined   Joined

139 projects

datasette-notebook

Last released

A markdown wiki and dashboarding system for Datasette

datasette-render-markdown

Last released

Datasette plugin for rendering Markdown

sqlite-utils

Last released

CLI tool and Python utility functions for manipulating SQLite databases

twitter-to-sqlite

Last released

Save data from Twitter to a SQLite database

datasette-statistics

Last released

SQL statistics functions for Datasette

json-flatten

Last released

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

datasette-app-support

Last released

Part of https://github.com/simonw/datasette-app

datasette-write

Last released

Datasette plugin providing a UI for writing to a database

datasette-schema-versions

Last released

Datasette plugin that shows the schema version of every attached database

datasette-import-table

Last released

Datasette plugin for importing tables from other Datasette instances

pids

Last released

A tiny Python library for generating public IDs from integers

datasette-verify

Last released

Verify that SQLite files can be opened using Datasette

datasette

Last released

An open source multi-tool for exploring and publishing data

evernote-to-sqlite

Last released

Tools for converting Evernote content to SQLite

healthkit-to-sqlite

Last released

Convert an Apple Healthkit export zip to a SQLite database

datasette-block-robots

Last released

Datasette plugin that blocks all robots using robots.txt

sqlite-explain

Last released

Derive information about a SQLite query using EXPLAIN

datasette-debug-asgi

Last released

Datasette plugin for dumping out the ASGI scope

datasette-x-forwarded-host

Last released

Treat the X-Forwarded-Host header as the Host header

datasette-query-links

Last released

Turn SELECT queries returned by a query into links to execute them

datasette-pyinstrument

Last released

Use pyinstrument to analyze Datasette page performance

sqlite-transform

Last released

Tool for running transformations on columns in a SQLite database.

datasette-json-html

Last released

Datasette plugin for rendering HTML based on JSON values

datasette-publish-fly

Last released

Datasette plugin for publishing data using Fly

datasette-remote-metadata

Last released

Periodically refresh Datasette metadata from a remote URL

datasette-haversine

Last released

Datasette plugin that adds a custom SQL function for haversine distances

datasette-publish-vercel

Last released

Datasette plugin for publishing data using Vercel

datasette-export-notebook

Last released

Datasette plugin providing instructions for exporting data to Jupyter or Observable

datasette-graphql

Last released

Datasette plugin providing an automatic GraphQL API for your SQLite databases

conditional-get

Last released

CLI tool for fetching data using HTTP conditional get

django-sql-dashboard

Last released

Django app for building dashboards using raw SQL queries

asgi-csrf

Last released

ASGI middleware for protecting against CSRF attacks

dogsheep-beta

Last released

Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette

yaml-to-sqlite

Last released

Utility for converting YAML files to SQLite

markdown-to-sqlite

Last released

CLI tool for loading markdown files into a SQLite database

db-to-sqlite

Last released

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

datasette-mask-columns

Last released

Datasette plugin that masks specified database columns

datasette-placekey

Last released

SQL functions for working with placekeys

xml-analyser

Last released

Analyse the structure of an arbitrary XML file

datasette-upload-csvs

Last released

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

datasette-auth-passwords

Last released

Datasette plugin for authenticating access using passwords

geojson-to-sqlite

Last released

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

json-post

Last released

Tool for posting JSON to an API, broken into pages

airtable-export

Last released

Export Airtable data to files on disk

datasette-publish-azure

Last released

Publish Datasette instances to Azure Functions

iam-to-sqlite

Last released

Load Amazon IAM data into a SQLite database

tableau-to-sqlite

Last released

Fetch data from Tableau into a SQLite database

c64

Last released

Experimental package of ASGI utilities extracted from Datasette

hacker-news-to-sqlite

Last released

Create a SQLite database containing data pulled from Hacker News

datasette-ripgrep

Last released

Web interface for searching your code using ripgrep, built as a Datasette plugin

flatten-single-item-arrays

Last released

Given a JSON list of objects, flatten any keys which always contain single item arrays to just a single value

datasette-auth-github

Last released

Datasette plugin and ASGI middleware that authenticates users against GitHub

datasette-block

Last released

Block all access to specific path prefixes

github-contents

Last released

Python class for reading and writing data to a GitHub repository

csv-diff

Last released

Python CLI tool and library for diffing CSV and JSON files

datasette-json-preview

Last released

Preview of new JSON default format for Datasette, see issue #782

higher-lower

Last released

Functions for finding numbers using higher/lower

download-tiles

Last released

Download map tiles and store them in an MBTiles database

datasette-tiles

Last released

Mapping tile server for Datasette, serving tiles from MBTiles packages

datasette-jellyfish

Last released

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

datasette-basemap

Last released

A basemap for Datasette and datasette-leaflet

datasette-cluster-map

Last released

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

datasette-leaflet

Last released

A plugin that bundles Leaflet.js for Datasette

datasette-template-sql

Last released

Datasette plugin for executing SQL queries from templates

datasette-leaflet-geojson

Last released

A Datasette plugin that renders GeoJSON columns using Leaflet

datasette-leaflet-freedraw

Last released

Draw polygons on maps in Datasette

swarm-to-sqlite

Last released

Create a SQLite database containing your checkin history from Foursquare Swarm

datasette-css-properties

Last released

Experimental Datasette output plugin using CSS properties

github-to-sqlite

Last released

Save data from GitHub to a SQLite database

datasette-column-inspect

Last released

Experimental Datasette plugin for inspecting columns

datasette-pretty-json

Last released

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

datasette-seaborn

Last released

Statistical visualizations for Datasette using Seaborn

datasette-search-all

Last released

Datasette plugin for searching all searchable tables at once

datasette-yaml

Last released

Export Datasette records as YAML

datasette-atom

Last released

Datasette plugin that adds a .atom output format

datasette-indieauth

Last released

Datasette authentication using IndieAuth and RelMeAuth

datasette-copyable

Last released

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

sqlite-fts4

Last released

Python functions for working with SQLite FTS4 search

csvs-to-sqlite

Last released

Convert CSV files into a SQLite database

datasette-configure-fts

Last released

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

datasette-edit-schema

Last released

Datasette plugin for modifying table schemas

sphinx-to-sqlite

Last released

Create a SQLite database from Sphinx documentation

inaturalist-to-sqlite

Last released

Create a SQLite database containing your observation history from iNaturalist

pocket-to-sqlite

Last released

Create a SQLite database containing data from your Pocket account

xml-analyzer

Last released

xml-analyzer is now xml-analyser

datasette-edit-tables

Last released

datasette-edit-tables is now datasette-edit-schema

datasette-dateutil

Last released

dateutil functions for Datasette

datasette-ics

Last released

Datasette plugin for outputting iCalendar files

datasette-dns

Last released

Custom SQL function for making DNS lookups

datasette-backup

Last released

Plugin adding backup options to Datasette

sqlite-dump

Last released

An improved version of .iterdump() for sqlite3

datasette-render-images

Last released

Datasette plugin that renders binary blob images using data-uris

shapefile-to-sqlite

Last released

Load shapefiles into a SQLite (optionally SpatiaLite) database

datasette-saved-queries

Last released

Datasette plugin that lets users save and execute queries

datasette-insert-unsafe

Last released

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

datasette-insert

Last released

Datasette plugin for inserting and updating data

datasette-publish-now

Last released

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

datasette-media

Last released

Datasette plugin for serving media based on a SQL query

datasette-insert-api

Last released

datasette-insert-api is now datasette-insert

datasette-clone

Last released

Create a local copy of database files from a Datasette instance

datasette-auth-tokens

Last released

Datasette plugin for authenticating access using API tokens

datasette-plugin-demos

Last released

Examples of plugins for Datasette

datasette-glitch

Last released

Utilities to help run Datasette on Glitch

datasette-init

Last released

Ensure specific tables and views exist on startup

datasette-allow-permissions-debug

Last released

Always allow access to /-/permissions, for debugging

sqlite-generate

Last released

Tool for generating demo SQLite databases

click-app-template-demo

Last released

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

datasette-plugin-template-demo

Last released

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

datasette-psutil

Last released

Datasette plugin adding a /-/psutil debugging endpoint

datasette-permissions-sql

Last released

Datasette plugin for configuring permission checks using SQL queries

asgi-auth-github

Last released

ASGI middleware that authenticates users against GitHub

dogsheep-photos

Last released

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

photos-to-sqlite

Last released

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

datasette-auth-existing-cookies

Last released

Datasette plugin that authenticates users based on existing domain cookies

paginate-json

Last released

CLI tool for fetching paginated JSON from a URL

datasette-jq

Last released

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

datasette-render-html

Last released

Datasette plugin that renders specified cells as HTML

datasette-render-timestamps

Last released

Datasette plugin for rendering timestamps

datasette-show-errors

Last released

Datasette plugin for displaying error tracebacks

fec-to-sqlite

Last released

Save FEC campaign finance data to a SQLite database

asgi-log-to-sqlite

Last released

ASGI middleware for logging traffic to a SQLite database

datasette-sentry

Last released

Datasette plugin for configuring Sentry

datasette-auth-cookie-api

Last released

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

datasette-configure-asgi

Last released

Datasette plugin for configuring arbitrary ASGI middleware

genome-to-sqlite

Last released

Import your genome into a SQLite database

datasette-rure

Last released

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

google-takeout-to-sqlite

Last released

Save data from Google Takeout to a SQLite database

datasette-cors

Last released

Datasette plugin for configuring CORS headers

asgi-debug

Last released

ASGI middleware for debugging ASGI applications

sqlite-diffable

Last released

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

datasette-render-binary

Last released

Datasette plugin for rendering binary data

delta-scraper

Last released

Python library for scraping data sources and creating readable deltas

datasette-bplist

Last released

Datasette plugin for working with Apple's binary plist format

asgi-cors

Last released

ASGI middleware for applying CORS headers to an ASGI application

validate-utf8

Last released

Python library and CLI for validating UTF-8 text

dbf-to-sqlite

Last released

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

datasette-sqlite-fts4

Last released

Datasette plugin exposing SQL functions from sqlite-fts4

datasette-vega

Last released

A Datasette plugin that provides tools for generating charts using Vega

datasette-sql-scraper

Last released

Experimental plugin for Datasette

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page