Elsewhere

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

Release sqlite-utils 2.13 — Python CLI utility and library for manipulating SQLite databases

30th Jul 2020, 1:15 am · sqlite-utils, sqlite

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

29th Jul 2020, 10:05 pm · datasette

TIL SQLite BLOB literals — I wanted to construct a string of SQL that would return a blob value:

29th Jul 2020, 9:49 pm

Release db-to-sqlite 1.3 — CLI tool for exporting tables or queries from any SQL database to a SQLite file

27th Jul 2020, 11:39 pm

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

27th Jul 2020, 8:22 pm · datasette

Release sqlite-utils 2.12 — Python CLI utility and library for manipulating SQLite databases

27th Jul 2020, 7:24 am · sqlite-utils, sqlite

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

TIL PostgreSQL full-text search in the Django Admin — Django 3.1 introduces PostgreSQL `search_type="websearch"` - which gives you search with advanced operators like `"phrase search" -excluding`. James Turk [wrote about this here](https://jamesturk.net/posts/websearch-in-django-31/), and it's also in [my weeknotes](https://simonwillison.net/2020/Jul/23/datasette-copyable-datasette-insert-api/).

25th Jul 2020, 10:36 pm

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

25th Jul 2020, 8:31 pm · datasette

TIL Implementing a "copy to clipboard" button — I had to figure this out while building [datasette-copyable](https://github.com/simonw/datasette-copyable/) - demo [here](https://covid-19.datasettes.com/covid/ny_times_us_counties.copyable?state=Texas&county=Harris).

23rd Jul 2020, 9:21 pm

Release twitter-to-sqlite 0.21.3 — Save data from Twitter to a SQLite database

23rd Jul 2020, 2:57 pm

TIL Updating a Markdown table of contents with a GitHub Action — [markdown-toc](https://github.com/jonschlinkert/markdown-toc) is a Node script that parses a Markdown file and generates a table of contents for it, based on the headings.

22nd Jul 2020, 7:42 pm

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

TIL Registering temporary pluggy plugins inside tests — While implementing more finely-grained permissions for `datasette-insert-api` ([issue 8](https://github.com/simonw/datasette-insert-api/issues/8)) I decided I wanted to register a Datasette pluggy plugin for the duration of a single test.

21st Jul 2020, 4:21 pm

TIL Upgrading a Heroku PostgreSQL database with pg:copy — Figured this out in https://github.com/simonw/simonwillisonblog/issues/132 - I was running PostgreSQL 9.x and I wanted 11.x in order to use the new `search_type="websearch"` option in Django 3.1.

20th Jul 2020, 6:58 pm