Elsewhere

Release datasette-edit-schema 0.3a2 — Datasette plugin for modifying table schemas

1st Oct 2020, 9:28 pm · datasette

TIL Escaping strings in Bash using !:q — TIL this trick, [via Pascal Hirsch](https://twitter.com/phphys/status/1311727268398465029) on Twitter. Enter a line of Bash starting with a `#` comment, then run `!:q` on the next line to see what that would be with proper Bash escaping applied.

1st Oct 2020, 8:32 pm

Release datasette-cluster-map 0.12.3 — Datasette plugin that shows a map for any data with latitude/longitude columns

1st Oct 2020, 12:30 am · datasette

Release datasette-cluster-map 0.12.2 — Datasette plugin that shows a map for any data with latitude/longitude columns

1st Oct 2020, 12:11 am · datasette

Release datasette-cluster-map 0.12.1 — Datasette plugin that shows a map for any data with latitude/longitude columns

30th Sep 2020, 6:30 pm · datasette

Release datasette-edit-schema 0.3a1 — Datasette plugin for modifying table schemas

30th Sep 2020, 6:12 pm · datasette

Release datasette-edit-schema 0.3a — Datasette plugin for modifying table schemas

30th Sep 2020, 5 pm · datasette

Release datasette-dateutil 0.2.1 — dateutil functions for Datasette

30th Sep 2020, 1:07 am · datasette

Release datasette-dateutil 0.2 — dateutil functions for Datasette

29th Sep 2020, 6:41 am · datasette

Release datasette-import-table 0.2 — Datasette plugin for importing tables from other Datasette instances

28th Sep 2020, 3:27 pm · datasette

Release datasette-import-table 0.1 — Datasette plugin for importing tables from other Datasette instances

28th Sep 2020, 2:32 pm · datasette

Release datasette-import-table 0.1a2 — Datasette plugin for importing tables from other Datasette instances

28th Sep 2020, 5:48 am · datasette

Release datasette-import-table 0.1a1 — Datasette plugin for importing tables from other Datasette instances

28th Sep 2020, 5:42 am · datasette

Release datasette-import-table 0.1a0 — Datasette plugin for importing tables from other Datasette instances

28th Sep 2020, 5:31 am · datasette

Release datasette-dateutil 0.1 — dateutil functions for Datasette

28th Sep 2020, 12:16 am · datasette

TIL Figuring out if a text value in SQLite is a valid integer or float — Given a table with a `TEXT` column in SQLite I want to figure out if every value in that table is actually the text representation of an integer or floating point value, so I can decide if it's a good idea to change the type of the column (using [sqlite-utils transform](https://sqlite-utils.datasette.io/en/stable/python-api.html#transforming-a-table)).

27th Sep 2020, 8:40 pm

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

24th Sep 2020, 4:45 pm · sqlite, sqlite-utils

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

23rd Sep 2020, 12:37 am · sqlite, sqlite-utils

TIL Understanding option names in Click — I hit [a bug today](https://github.com/simonw/datasette/issues/973) where I had defined a Click option called `open` but in doing so I replaced the Python bulit-in `open()` function:

22nd Sep 2020, 3:49 pm

Release dogsheep-beta 0.9a0 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette

20th Sep 2020, 11:37 pm

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

20th Sep 2020, 10:24 pm · sqlite, sqlite-utils

TIL Compiling the SQLite spellfix.c module on macOS — I wanted to browse a backup copy of my Plex database, which is a SQLite file. I tried this:

19th Sep 2020, 11:11 pm

TIL Turning on Jinja autoescaping when using Template() directly — Jinja autoescaping is turned off by default. Coming from Django this frequently catches me out.

18th Sep 2020, 11:13 pm

Release dogsheep-beta 0.8 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette

18th Sep 2020, 10:41 pm

TIL Talking to a PostgreSQL service container from inside a Docker container — I have a Django application which uses PostgreSQL. I build the Django application into its own Docker container, push that built container to the GitHub package registery and then deploy that container to production.

18th Sep 2020, 6:43 pm

Release dogsheep-beta 0.7.1 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette

17th Sep 2020, 11:13 pm

Release dogsheep-beta 0.7 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette

17th Sep 2020, 10:57 pm

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

17th Sep 2020, 3:55 am

Release datasette 0.49.1 — An open source multi-tool for exploring and publishing data

15th Sep 2020, 8:21 pm · datasette

TIL Open a debugging shell in GitHub Actions with tmate — > :warning: **17 Feb 2022: There have been reports of running tmate causing account suspensions**. See [this issue](https://github.com/mxschmitt/action-tmate/issues/104) for details. Continue with caution.

14th Sep 2020, 10:25 pm

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags