Simon Willison’s Weblog

Subscribe

March 2020

72 posts: 5 entries, 10 links, 2 quotes, 55 beats

March 2, 2020

Release asgi-csrf 0.1a — ASGI middleware for protecting against CSRF attacks
Release asgi-csrf 0.2a — ASGI middleware for protecting against CSRF attacks
Release asgi-csrf 0.2.1a — ASGI middleware for protecting against CSRF attacks
Release datasette-configure-fts 0.1a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.1.1a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.2a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.3a — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.3.1a — Datasette plugin for enabling full-text search against selected table columns

March 3, 2020

Release datasette Datasette 0.37.1 — An open source multi-tool for exploring and publishing data
Release datasette-upload-csvs 0.4 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-ics 0.3a — Datasette plugin for outputting iCalendar files
Release asgi-csrf 0.2.2a — ASGI middleware for protecting against CSRF attacks

March 4, 2020

Weeknotes: datasette-ics, datasette-upload-csvs, datasette-configure-fts, asgi-csrf

I’ve been preparing for the NICAR 2020 Data Journalism conference this week which has lead me into a flurry of activity across a plethora of different projects and plugins.

[... 834 words]

Release datasette-configure-fts 0.4 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.4.1 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-configure-fts 0.4.2 — Datasette plugin for enabling full-text search against selected table columns

March 5, 2020

Millions of tiny databases. Fascinating, detailed review of a paper that describes Amazon’s Physalia, a distributed configuration store designed to provide extremely high availability coordination for Elastic Block Store replication. My eyebrows raised at “Physalia is designed to offer consistency and high-availability, even under network partitions.” since that’s such a blatant violation of CAP theorem, but it later justifies it like so: “One desirable property therefore, is that in the event of a partition, a client’s Physalia database will be on the same side of the partition as the client. Clever placement of cells across nodes can maximise the chances of this.”

# 4:37 am / aws, scaling

March 7, 2020

Release fec-to-sqlite 0.1 — Save FEC campaign finance data to a SQLite database
Release fec-to-sqlite 0.2 — Save FEC campaign finance data to a SQLite database

I called it normalization because then President Nixon was talking a lot about normalizing relations with China. I figured that if he could normalize relations, so could I.

Edgar F. Codd

# 11:12 pm / databases, sql

March 8, 2020

Release datasette 0.38 — An open source multi-tool for exploring and publishing data
Release datasette-search-all 0.1 — Datasette plugin for searching all searchable tables at once
Release datasette-search-all 0.1.1 — Datasette plugin for searching all searchable tables at once

March 9, 2020

Release datasette-search-all 0.2 — Datasette plugin for searching all searchable tables at once

datasette-search-all: a new plugin for searching multiple Datasette tables at once

I just released a new plugin for Datasette, and it’s pretty fun. datasette-search-all is a plugin written mostly in JavaScript that executes the same search query against every searchable table in every database connected to your Datasette instance.

[... 819 words]

Release datasette-column-inspect 0.1a — Experimental plugin that adds a column inspector

The unexpected Google wide domain check bypass (via) Fantastic story of discovering a devious security vulnerability in a bunch of Google products stemming from a single exploitable regular expression in the Google closure JavaScript library.

# 11:27 pm / regular-expressions, security

March 11, 2020

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

Weeknotes: COVID-19 numbers in Datasette

Visit Weeknotes: COVID-19 numbers in Datasette

COVID-19, the disease caused by the novel coronavirus, gets more terrifying every day. Johns Hopkins Center for Systems Science and Engineering (CSSE) have been collating data about the spread of the disease and publishing it as CSV files on GitHub.

[... 644 words]

March 12, 2020

Announcing Daylight Map Distribution. Mike Migurski announces a new distribution of OpenStreetMap: a 42GB dump of the version of the data used by Facebook, carefully moderated to minimize the chance of incorrect or maliciously offensive edits. Lots of constructive conversation in the comments about the best way for Facebook to make their moderation decisions more available to the OSM community.

# 11:44 am / facebook, michal-migurski, openstreetmap

2020 » March

MTWTFSS
      1
2345678
9101112131415
16171819202122
23242526272829
3031