Elsewhere

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

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, atom

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

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags