Archive for January 2021

January 2021

69 posts: 7 entries, 9 links, 4 quotes, 49 beats

Jan. 18, 2021

TIL Fixing broken text encodings with sqlite-transform and ftfy — I was working with a database table that included values that were clearly in the wrong character encoding - values like this:

18th Jan 2021, 8:44 pm

Release sqlite-transform 0.3.1 — Tool for running transformations on columns in a SQLite database

18th Jan 2021, 9:01 pm

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

18th Jan 2021, 9:49 pm · datasette

TIL Syntax highlighting Python console examples with GFM — It turns out [GitHub Flavored Markdown](https://github.github.com/gfm/) can apply syntax highlighting to Python console examples, like this one:

19th Jan 2021, 1:21 am

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

19th Jan 2021, 8:51 pm · datasette

Jan. 20, 2021

Release datasette-leaflet-freedraw 0.1 — Draw polygons on maps in Datasette

20th Jan 2021, 12:59 am · datasette

Release datasette-leaflet-freedraw 0.1.1 — Draw polygons on maps in Datasette

20th Jan 2021, 1:20 am · datasette

Release datasette-leaflet-freedraw 0.1.2 — Draw polygons on maps in Datasette

20th Jan 2021, 1:26 am · datasette

Release datasette-leaflet-freedraw 0.1.3 — Draw polygons on maps in Datasette

20th Jan 2021, 9:29 am · datasette

Release datasette-leaflet-geojson 0.7 — Datasette plugin that replaces any GeoJSON column values with a Leaflet map.

20th Jan 2021, 8:21 pm · datasette

Jan. 22, 2021

Tuesday’s chaos arose after China Railway Shenyang failed to deactivate Flash in time, leading to a complete shutdown of its railroads in Dalian, Liaoning province. Staffers were reportedly unable to view train operation diagrams, formulate train sequencing schedules and arrange shunting plans.

Authorities fixed the issue by installing a pirated version of Flash at 4:30 a.m. the following day.

— Apple Daily

# 12:30 am / flash

TIL Embedding JavaScript in a Jupyter notebook — I recently found out modern browsers include a JavaScript API for creating public/private keys for cryptography.

22nd Jan 2021, 9:52 pm

Release datasette-auth-github 0.13a0 — Datasette plugin that authenticates users against GitHub

22nd Jan 2021, 10:36 pm · datasette

Release datasette-auth-github 0.13a1 — Datasette plugin that authenticates users against GitHub

22nd Jan 2021, 11:22 pm · datasette

Jan. 23, 2021

Release datasette-auth-github 0.13a2 — Datasette plugin that authenticates users against GitHub

23rd Jan 2021, 12:50 am · datasette

Release asgi-csrf 0.7.2 — ASGI middleware for protecting against CSRF attacks

23rd Jan 2021, 9:30 pm

Release asgi-csrf 0.8 — ASGI middleware for protecting against CSRF attacks

23rd Jan 2021, 10:33 pm

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

23rd Jan 2021, 10:50 pm · datasette

Jan. 24, 2021

Release datasette-auth-github 0.13 — Datasette plugin that authenticates users against GitHub

24th Jan 2021, 5:53 am · datasette

Release datasette-leaflet-freedraw 0.1.4 — Draw polygons on maps in Datasette

24th Jan 2021, 6:46 am · datasette

Drawing shapes on a map to query a SpatiaLite database (and other weeknotes)

This week I built a Datasette plugin that lets you query a database by drawing shapes on a map!

[... 950 words]

6:50 am / gis, projects, spatialite, sqlite, datasette, weeknotes

Release datasette-leaflet 0.1 — Datasette plugin adding the Leaflet JavaScript library

24th Jan 2021, 6:19 pm · datasette

Jan. 25, 2021

Datasette 0.54: The annotated release notes

Datasette 0.54 is out today, with a number of foundational new features. As I’ve done for previous releases, here are the annotated release notes with some additional commentary.

[... 1,276 words]

5:31 pm / releasenotes, datasette, annotated-release-notes, small-data

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

25th Jan 2021, 5:36 pm · datasette

Release datasette-leaflet 0.2 — Datasette plugin adding the Leaflet JavaScript library

25th Jan 2021, 7:03 pm · datasette

Release datasette-leaflet-freedraw 0.2 — Draw polygons on maps in Datasette

25th Jan 2021, 7:05 pm · datasette

Release datasette-leaflet-freedraw 0.2.1 — Draw polygons on maps in Datasette

25th Jan 2021, 7:23 pm · datasette

Jan. 26, 2021

Release datasette-leaflet-geojson 0.8 — Datasette plugin that replaces any GeoJSON column values with a Leaflet map.

26th Jan 2021, 2:41 am · datasette

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

26th Jan 2021, 6:33 am · datasette

Jan. 27, 2021

TIL Testing cookiecutter templates with pytest — I added some unit tests to my [datasette-plugin](https://github.com/simonw/datasette-plugin) cookiecutter template today, since the latest features involved adding a `hooks/post_gen_project.py` script.

27th Jan 2021, 11:50 pm

«« first « previous page 2 / 3 next » last »»

Simon Willison’s Weblog