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-ripgrep 0.3 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-ripgrep 0.2.1 — Web interface for searching your code using ripgrep, built as a Datasette plugin

datasette-ripgrep: deploy a regular expression search engine for your source code

Visit datasette-ripgrep: deploy a regular expression search engine for your source code

This week I built datasette-ripgrep—a web application for running regular expression searches against source code, built on top of the amazing ripgrep command-line tool.

[... 1,362 words]

Release datasette-ripgrep 0.2 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-ripgrep 0.1 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-atom 0.8.1 — Datasette plugin that adds a .atom output format
Release datasette-ripgrep 0.1a1 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-ripgrep 0.1a0 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-graphql 1.2.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

Datasette Client for Observable (via) Really elegant piece of code design from Alex Garcia: DatasetteClient is a client library he built designed to work in Observable notebooks, which uses JavaScript tagged template literals to allow SQL query results to be executed against a Datasette instance and displayed as inline tables in a notebook, or used to return JSON data for further processing. His example notebook includes a neat d3 stacked area chart example built against a Datasette of congresspeople, plus examples using interactive widgets to update the Notebook.

# 24th November 2020, 6:53 pm / observable, datasette, javascript, alex-garcia

Weeknotes: datasette-indieauth, datasette-graphql, PyCon Argentina

Visit Weeknotes: datasette-indieauth, datasette-graphql, PyCon Argentina

Last week’s weeknotes took the form of my Personal Data Warehouses: Reclaiming Your Data talk write-up, which represented most of what I got done that week. This week I mainly worked on datasette-indieauth, but I also gave a keynote at PyCon Argentina and released a version of datasette-graphql with a small security fix.

[... 724 words]

datasette-graphql 1.2 (via) A new release of the datasette-graphql plugin, fixing a minor security flaw: previous versions of the plugin could expose the schema (but not the actual data) of tables in databases that were otherwise protected by Datasette’s permission system.

# 21st November 2020, 10:21 pm / projects, datasette, security, graphql

Release datasette-graphql 1.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-indieauth 1.2 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-indieauth 1.1 — Datasette authentication using IndieAuth and RelMeAuth

Implementing IndieAuth for Datasette

Visit Implementing IndieAuth for Datasette

IndieAuth is a spiritual successor to OpenID, developed and maintained by the IndieWeb community and based on OAuth 2. This weekend I attended IndieWebCamp East Coast and was inspired to try my hand at an implementation. datasette-indieauth is the result, a new plugin which enables IndieAuth logins to a Datasette instance.

[... 1,225 words]

Release datasette-indieauth 1.0 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-indieauth 0.3.2 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-indieauth 0.3.1 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-indieauth 0.3 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-indieauth 0.3a0 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-indieauth 0.2a0 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-indieauth 0.1a0 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-copyable 0.3.1 — Datasette plugin for outputting tables in formats suitable for copy and paste

Personal Data Warehouses: Reclaiming Your Data

Visit Personal Data Warehouses: Reclaiming Your Data

I gave a talk yesterday about personal data warehouses for GitHub’s OCTO Speaker Series, focusing on my Datasette and Dogsheep projects. The video of the talk is now available, and I’m presenting that here along with an annotated summary of the talk, including links to demos and further information.

[... 5,166 words]

Release datasette-search-all 1.0 — Datasette plugin for searching all searchable tables at once

Intent to Remove: HTTP/2 and gQUIC server push (via) The Chrome / Blink team announce their intent to remove HTTP/2 server push support, where servers can start pushing an asset to a client before it has been requested. It’s been in browsers for over five years now and adoption is terrible. “Over the past 28 days [...] 99.97% of connections never received a pushed stream that got matched with a request [...] These numbers are exactly the same as in June 2019”. Datasette serves redirects with Link: preload headers that cause smart proxies (like Cloudflare) to push the redirected page to the client along with the redirect, but I don’t exepect to miss that optimization if it quietly stops working.

# 12th November 2020, 1:44 am / http2, chrome, datasette

Datasette 0.51 (plus weeknotes)

Visit Datasette 0.51 (plus weeknotes)

I shipped Datasette 0.51 today, with a new visual design, plugin hooks for adding navigation options, better handling of binary data, URL building utility methods and better support for running Datasette behind a proxy. It’s a lot of stuff! Here are the annotated release notes.

[... 2,020 words]

Release datasette 0.51.1 — An open source multi-tool for exploring and publishing data
Release datasette-configure-fts 1.1 — Datasette plugin for enabling full-text search against selected table columns