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.

2024

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
Release datasette-schema-versions 0.3 — Datasette plugin that shows the schema version of every attached database

Datasette 1.0a12. Another alpha release, this time with a new query_actions() plugin hook, a new design for the table, database and query actions menus, a “does not contain” table filter and a fix for a minor bug with the JavaScript makeColumnActions() plugin mechanism.

# 29th February 2024, 11:56 pm / projects, datasette

Release datasette-studio 0.1a1 — Datasette pre-configured with useful plugins. Experimental alpha.
Release datasette 1.0a12 — An open source multi-tool for exploring and publishing data
Release datasette-scale-to-zero 0.3.1 — Quit Datasette if it has not received traffic for a specified time period
Release datasette-scale-to-zero 0.3 — Quit Datasette if it has not received traffic for a specified time period
Release datasette-explain 0.2.1 — Explain and validate SQL queries as you type them into Datasette
Release datasette-explain 0.2 — Explain and validate SQL queries as you type them into Datasette
Release datasette-write 0.3 — Datasette plugin providing a UI for executing SQL writes against the database

Weeknotes: Getting ready for NICAR

Next week is NICAR 2024 in Baltimore—the annual data journalism conference hosted by Investigative Reporters and Editors. I’m running a workshop on Datasette, and I plan to spend most of my time in the hallway track talking to people about Datasette, Datasette Cloud and how the Datasette ecosystem can best help support their work.

[... 1,390 words]

dclient 0.3. dclient is my CLI utility for working with remote Datasette instances—in particular for authenticating with them and then running both read-only SQL queries and inserting data using the new Datasette write JSON API. I just picked up work on the project again after a six month gap—the insert command can now be used to constantly stream data directly to hosted Datasette instances such as Datasette Cloud.

# 25th February 2024, 8:06 pm / projects, datasette-cloud, datasette, cli

Release datasette-events-forward 0.1a1 — Forward Datasette analytical events on to another Datasette instance
Release datasette-events-forward 0.1a0 — Forward Datasette analytical events on to another Datasette instance
Release datasette-auth-tokens 0.4a9 — Datasette plugin for authenticating access using API tokens