Simon Willison’s Weblog

Subscribe
Atom feed for datasette Random

1,469 posts tagged “datasette”

Datasette is an open source tool for exploring and publishing data.

2024

Release datasette-embeddings 0.1a2 — Store and query embedding vectors in Datasette tables
Release datasette-paste 0.1a4 — Paste data to create tables in Datasette
Release datasette-embeddings 0.1a0 — Store and query embedding vectors in Datasette tables
Release datasette-paste 0.1a3 — Paste data to create tables in Datasette
Release datasette-paste 0.1a2 — Paste data to create tables in Datasette
Release datasette-paste 0.1a1 — Paste data to create tables in Datasette
Release datasette-enrichments 0.3.1 — Tools for running enrichments against data stored in Datasette
Release datasette-studio 0.1a2 — Datasette pre-configured with useful plugins. Experimental alpha.
Release datasette-write 0.3.2 — Datasette plugin providing a UI for executing SQL writes against the database
Release datasette-enrichments 0.3 — Tools for running enrichments against data stored in Datasette

Add ETag header for static responses. I’ve been procrastinating on adding better caching headers for static assets (JavaScript and CSS) served by Datasette for several years, because I’ve been wanting to implement the perfect solution that sets far-future cache headers on every asset and ensures the URLs change when they are updated.

Agustin Bacigalup just submitted the best kind of pull request: he observed that adding ETag support for static assets would side-step the complexity while adding much of the benefit, and implemented it along with tests.

It’s a substantial performance improvement for any Datasette instance with a number of JavaScript plugins... like the ones we are building on Datasette Cloud. I’m just annoyed we didn’t ship something like this sooner!

# 17th March 2024, 7:25 pm / datasette-cloud, datasette, web-performance, etags

Weeknotes: the aftermath of NICAR

Visit Weeknotes: the aftermath of NICAR

NICAR was fantastic this year. Alex and I ran a successful workshop on Datasette and Datasette Cloud, and I gave a lightning talk demonstrating two new GPT-4 powered Datasette plugins—datasette-enrichments-gpt and datasette-extract. I need to write more about the latter one: it enables populating tables from unstructured content (using a variant of this technique) and it’s really effective. I got it working just in time for the conference.

[... 1,430 words]

Release datasette-export-database 0.2.1 — Export a copy of a mutable SQLite database on demand
Release datasette-export-database 0.2 — Export a copy of a mutable SQLite database on demand
Release datasette-export-database 0.1.1 — Export a copy of a mutable SQLite database on demand
Release datasette-export-database 0.1 — Export a copy of a mutable SQLite database on demand
Release datasette-configure-fts 1.1.3 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-upload-csvs 0.9.1 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-write 0.3.1 — Datasette plugin providing a UI for executing SQL writes against the database
Release datasette-edit-schema 0.8a1 — Datasette plugin for modifying table schemas
Release datasette 1.0a13 — An open source multi-tool for exploring and publishing data

datasette/studio. I’m trying a new way to make Datasette available for small personal data manipulation projects, using GitHub Codespaces.

This repository is designed to be opened directly in Codespaces—detailed instructions in the README.

When the container starts it installs the datasette-studio family of plugins—including CSV upload, some enrichments and a few other useful feature—then starts the server running and provides a big green button to click to access the server via GitHub’s port forwarding mechanism.

# 10th March 2024, 3:03 am / github-codespaces, projects, datasette

Release datasette-enrichments-quickjs 0.1a1 — Enrich data with a custom JavaScript function
Release datasette-saved-queries 0.2.2 — Datasette plugin that lets users save and execute queries
Release datasette-create-view 0.1 — Create a SQL view from a query
Release datasette-uptime 0.1.1 — Datasette plugin showing uptime at /-/uptime
Release datasette-uptime 0.1 — Datasette plugin showing uptime at /-/uptime
Release datasette-sqlite-authorizer 0.2 — Configure Datasette to block operations using the SQLIte set_authorizer mechanism
Release datasette-expose-env 0.2 — Datasette plugin to expose selected environment variables at /-/env for debugging
Release datasette-column-sum 0.1a0 — Sum the values in numeric Datasette columns