Elsewhere

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

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 twitter-to-sqlite 0.21.2 — Save data from Twitter to a SQLite database

18th Jul 2020, 10:43 pm

Release github-to-sqlite 2.4 — Save data from GitHub to a SQLite database

18th Jul 2020, 10:35 pm

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

17th Jul 2020, 11:23 pm · datasette

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

14th Jul 2020, 4:12 am · datasette

TIL Password hashing in Python with pbkdf2 — I was researching password hashing for [datasette-auth-passwords](https://github.com/simonw/datasette-auth-passwords). I wanted very secure defaults that would work using the Python standard library without any extra dependencies.

14th Jul 2020, 3:53 am

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

13th Jul 2020, 10:11 pm · datasette

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

13th Jul 2020, 9:04 pm · datasette

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

13th Jul 2020, 8:50 pm · datasette

Release datasette-auth-passwords 0.2a — Datasette plugin for authentication using passwords

13th Jul 2020, 8:25 pm · datasette

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

13th Jul 2020, 7:22 pm · datasette

Release datasette-publish-fly 1.0 — Datasette plugin for publishing data using Fly

11th Jul 2020, 1:03 am · datasette

TIL Using heroku pg:pull to restore a backup to a macOS laptop — Today I worked out how to use the Heroku `pg:pull` command and [Postgres.app](https://postgresapp.com/) to pull a Heroku backup to my laptop.

11th Jul 2020, 12:16 am

TIL Paginating through the GitHub GraphQL API with Python — (See also [Building a self-updating profile README for GitHub](https://simonwillison.net/2020/Jul/10/self-updating-profile-readme/) on my blog)

10th Jul 2020, 4 am

Release github-to-sqlite 2.3 — Save data from GitHub to a SQLite database

9th Jul 2020, 11:28 pm

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

8th Jul 2020, 5:36 pm · sqlite, sqlite-utils

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

8th Jul 2020, 12:35 am · datasette

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags