Elsewhere

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

Release datasette-ics 0.5 — Datasette plugin for outputting iCalendar files

14th Sep 2020, 10:19 pm · datasette

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

14th Sep 2020, 10:17 pm · datasette

Release datasette-atom 0.8 — Datasette plugin that adds a .atom output format

14th Sep 2020, 10:15 pm · datasette

Release datasette-yaml 0.1 — Export Datasette records as YAML

14th Sep 2020, 10:13 pm · datasette

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

14th Sep 2020, 9:40 pm · datasette

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

14th Sep 2020, 2:48 am · datasette

Release datasette-seaborn 0.1a1 — Statistical visualizations for Datasette using Seaborn

11th Sep 2020, 5:01 pm · datasette

Release datasette-seaborn 0.1a0 — Statistical visualizations for Datasette using Seaborn

11th Sep 2020, 3:03 pm · datasette

Release datasette-dns 0.1a1 — Custom SQL function for making DNS lookups

10th Sep 2020, 3:58 pm · datasette

Release datasette-dns 0.1a0 — Custom SQL function for making DNS lookups

10th Sep 2020, 4:45 am · datasette

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

9th Sep 2020, 12:46 am

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

8th Sep 2020, 11:39 pm · sqlite, sqlite-utils

TIL Basic strace to see what a process is doing — I had a long-running process and I wanted to check that it was at least doing _something_.

7th Sep 2020, 11:14 pm

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

7th Sep 2020, 10:08 pm · sqlite, sqlite-utils

TIL Display EC2 instance costs per month — The [EC2 pricing page](https://aws.amazon.com/ec2/pricing/on-demand/) shows cost per hour, which is pretty much useless. I want cost per month. The following JavaScript, pasted into the browser developer console, modifies the page to show cost-per-month instead.

7th Sep 2020, 2:43 am

Release datasette-backup 0.1 — Plugin adding backup options to Datasette

7th Sep 2020, 2:27 am · datasette

Release sqlite-dump 0.1.1 — An improved version of .iterdump() for sqlite3

7th Sep 2020, 1:07 am

Release sqlite-dump 0.1 — An improved version of .iterdump() for sqlite3

7th Sep 2020, 12:50 am

TIL Very basic tsc usage — I guess I [have to learn TypeScript](https://twitter.com/simonw/status/1302517496767938561) now.

6th Sep 2020, 4:36 pm

Release sqlite-dump 0.1a — An improved version of .iterdump() for sqlite3

6th Sep 2020, 3:23 pm

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags