Simon Willison on datasette

1,455 posts tagged “datasette”

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

2020

Release datasette-graphql 0.1a — Datasette plugin providing an automatic GraphQL API for your SQLite databases

2nd Aug 2020, 3:33 am · datasette

Release datasette-insert-unsafe 0.1 — Unsafe permissions for datasette-insert - allows all actions without authentication

31st Jul 2020, 9:46 pm · datasette

Release datasette-insert 0.6 — Datasette plugin for inserting and updating data

31st Jul 2020, 9:43 pm · datasette

Release datasette-publish-vercel 0.7 — Datasette plugin for publishing data using Vercel

31st Jul 2020, 4:53 pm · datasette

Fun with binary data and SQLite

This week I’ve been mainly experimenting with binary data storage in SQLite. sqlite-utils can now insert data from binary files, and datasette-media can serve content over HTTP that originated as binary BLOBs in a database file.

[... 957 words]

11:22 pm / 30th July 2020 / projects, sqlite, paul-ford, plugins, datasette, weeknotes, sqlite-utils

Release datasette-media 0.5 — Datasette plugin for serving media based on a SQL query

29th Jul 2020, 10:05 pm · datasette

datasette-media 0.4. datasette-media is my Datasette plugin for serving media (e.g. images) directly from Datasette. The first version used file paths saved in a column and served the data from disk—this new version adds the ability to serve content from BLOB columns, such as those created by the new “sqlite-utils insert-files” command. It also adds configurable support for resizing images based on querystring parameters like ?w=100.

# 28th July 2020, 2:22 am / projects, datasette, plugins, images

Release datasette-media 0.4 — Datasette plugin for serving media based on a SQL query

27th Jul 2020, 8:22 pm · datasette

Release datasette-render-images 0.3.1 — Datasette plugin that renders binary blob images using data-uris

27th Jul 2020, 5:11 am · datasette

Release datasette-render-images 0.3 — Datasette plugin that renders binary blob images using data-uris

27th Jul 2020, 4:57 am · datasette

Release datasette-auth-passwords 0.3.1 — Datasette plugin for authentication using passwords

26th Jul 2020, 12:27 am · datasette

Release datasette-insert 0.5 — Datasette plugin for inserting and updating data

25th Jul 2020, 8:31 pm · datasette

Weeknotes: datasette-copyable, datasette-insert-api

Two new Datasette plugins this week: datasette-copyable, helping users copy-and-paste data from Datasette into other places, and datasette-insert-api, providing a JSON API for inserting and updating data and creating tables.

[... 953 words]

11:37 pm / 23rd July 2020 / my-talks, weeknotes, datasette, plugins, projects, sqlite-utils

Release datasette-clone 0.5 — Create a local copy of database files from a Datasette instance

22nd Jul 2020, 5:13 pm · datasette

Release datasette-copyable 0.2 — Datasette plugin for outputting tables in formats suitable for copy and paste

21st Jul 2020, 9:52 pm · datasette

Release datasette-copyable 0.1 — Datasette plugin for outputting tables in formats suitable for copy and paste

21st Jul 2020, 7:06 pm · datasette

Release datasette-insert 0.4 — Datasette plugin for inserting and updating data

21st Jul 2020, 4:25 pm · datasette

Release datasette-auth-tokens 0.2.2 — Datasette plugin for authenticating access using API tokens

20th Jul 2020, 12:33 am · datasette

Release datasette-insert 0.3 — Datasette plugin for inserting and updating data

20th Jul 2020, 12:09 am · datasette

Release datasette-insert 0.2a — Datasette plugin for inserting and updating data

19th Jul 2020, 7:09 pm · datasette

Release datasette-insert 0.1a — Datasette plugin for inserting and updating data

17th Jul 2020, 11:23 pm · datasette

Weeknotes: datasette-auth-passwords, a Datasette logo and a whole lot more

All sorts of project updates this week.

[... 913 words]

3:41 am / 17th July 2020 / passwords, datasette, design, projects, covid19, git-scraping, weeknotes

Release datasette-plugin-demos 0.4 — Some examples plugins for Datasette

14th Jul 2020, 4:12 am · datasette

datasette-auth-passwords. My latest plugin: datasette-auth-passwords provides a mechanism for signing into Datasette using a username and password (which is verified in order to set a ds_actor authentication cookie). So far it only supports passwords that are hard-coded into Datasette’s configuration via environment variables, but I plan to add database-backed user accounts in the future.

# 13th July 2020, 11:39 pm / passwords, datasette, plugins, projects, authentication