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

Release datasette-seaborn 0.1a0 — Statistical visualizations for Datasette using Seaborn

Weeknotes: datasette-dump, sqlite-backup, talks

I spent some time this week digging into Python’s sqlite3 internals. I also gave two talks and recorded a third, due to air at PyGotham in October.

[... 928 words]

Release datasette-dns 0.1a1 — Custom SQL function for making DNS lookups
Release datasette-dns 0.1a0 — Custom SQL function for making DNS lookups
Release datasette-backup 0.1 — Plugin adding backup options to Datasette
Release datasette-backup 0.1a — Plugin adding backup options to Datasette
Release datasette-block-robots 0.3 — Datasette plugin that blocks robots and crawlers using robots.txt
Release datasette-block-robots 0.2 — Datasette plugin that blocks robots and crawlers using robots.txt

The “await me maybe” pattern for Python asyncio

I’ve identified a pattern for handling potentially-asynchronous callback functions in Python which I’m calling the “await me maybe” pattern. It works by letting you return a value, a callable function that returns a value OR an awaitable function that returns that value.

[... 787 words]

Release datasette-yaml 0.1a — Export Datasette records as YAML
Release datasette 0.49a0 — An open source multi-tool for exploring and publishing data

Weeknotes: California Protected Areas in Datasette

Visit Weeknotes: California Protected Areas in Datasette

This week I built a geospatial search engine for protected areas in California, shipped datasette-graphql 1.0 and started working towards the next milestone for Datasette Cloud.

[... 1,099 words]

Release datasette-graphql 1.0.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.0 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.15 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-render-images 0.3.2 — Datasette plugin that renders binary blob images using data-uris
Release datasette-atom 0.7 — Datasette plugin that adds a .atom output format
Release datasette-auth-passwords 0.3.2 — Datasette plugin for authentication using passwords
Release datasette-leaflet-geojson 0.6 — Datasette plugin that replaces any GeoJSON column values with a Leaflet map.

California Protected Areas Database in Datasette (via) I built this yesterday: it’s a Datasette interface on top of the CPAD 2020 GIS database of protected areas in California maintained by GreenInfo Network. This was a useful excuse to build a GitHub Actions flow that builds a SpatiaLite database using my shapefile-to-sqlite tool, and I fixed a few bugs in my datasette-leaflet-geojson plugin as well.

# 21st August 2020, 11:15 pm / shapefiles, github-actions, datasette, projects, california, spatialite, gis

Release datasette-leaflet-geojson 0.5 — Datasette plugin that replaces any GeoJSON column values with a Leaflet map.

Weeknotes: Rocky Beaches, Datasette 0.48, a commit history of my database

Visit Weeknotes: Rocky Beaches, Datasette 0.48, a commit history of my database

This week I helped Natalie launch Rocky Beaches, shipped Datasette 0.48 and several releases of datasette-graphql, upgraded the CSRF protection for datasette-upload-csvs and figured out how to get a commit log of changes to my blog by backing up its database to a GitHub repository.

[... 1,294 words]

Release datasette-graphql 0.14 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.13 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-schema-versions 0.1 — Datasette plugin that shows the schema version of every attached database
Release datasette-graphql 0.12.3 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-publish-vercel 0.8 — Datasette plugin for publishing data using Vercel
Release datasette-cluster-map 0.12 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette 0.48 — An open source multi-tool for exploring and publishing data
Release datasette-graphql 0.12.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases