Simon Willison’s Weblog

Subscribe

February 2020

42 posts: 4 entries, 4 links, 4 quotes, 30 beats

Feb. 1, 2020

Release geojson-to-sqlite 0.1.2 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)

Feb. 2, 2020

Museum Hearst Castle — 750 Hearst Castle Road, San Simeon, CA 93452

Feb. 4, 2020

Release datasette-auth-existing-cookies 0.3 — Datasette plugin that authenticates users based on existing domain cookies
Release datasette-auth-existing-cookies 0.4 — Datasette plugin that authenticates users based on existing domain cookies

Feb. 5, 2020

Release datasette-auth-existing-cookies 0.4.1 — Datasette plugin that authenticates users based on existing domain cookies
Release datasette Datasette 0.35 — An open source multi-tool for exploring and publishing data
Release datasette-auth-existing-cookies 0.5 — Datasette plugin that authenticates users based on existing domain cookies
Release datasette-upload-csvs 0.1a — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-auth-existing-cookies 0.5.1 — Datasette plugin that authenticates users based on existing domain cookies

Weeknotes: Shaving yaks for Datasette Cloud

I’ve been shaving a lot of yaks, but I’m finally ready to for other people to start kicking the tires on the MVP of Datasette Cloud.

[... 392 words]

Feb. 6, 2020

Release datasette-auth-existing-cookies 0.6 — Datasette plugin that authenticates users based on existing domain cookies
Release datasette-auth-existing-cookies 0.6.1 — Datasette plugin that authenticates users based on existing domain cookies

Feb. 7, 2020

Release sqlite-utils 2.2 — Python CLI utility and library for manipulating SQLite databases
Release sqlite-utils 2.2.1 — Python CLI utility and library for manipulating SQLite databases
Release twitter-to-sqlite 0.16 — Save data from Twitter to a SQLite database

Deep learning isn’t hard anymore. This article does a great job of explaining how transfer learning is unlocking a new wave of innovation around deep learning. Previously if you wanted to train a model you needed vast amounts if data and thousands of dollars of compute time. Thanks to transfer learning you can now take an existing model (such as GPT2) and train something useful on top of it that’s specific to a new domain in just minutes it hours, with only a few hundred or a few thousand new labeled samples.

# 8:47 am / machine-learning, transferlearning

Feb. 8, 2020

We write a lot of JavaScript at Basecamp, but we don’t use it to create “JavaScript applications” in the contemporary sense. All our applications have server-side rendered HTML at their core, then add sprinkles of JavaScript to make them sparkle. [...] It allows us to party with productivity like days of yore. A throwback to when a single programmer could make rapacious progress without getting stuck in layers of indirection or distributed systems. A time before everyone thought the holy grail was to confine their server-side application to producing JSON for a JavaScript-based client application.

David Heinemeier Hansson

# 8:10 am / dhh, javascript

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

Feb. 11, 2020

Release sqlite-utils 2.3.1 — Python CLI utility and library for manipulating SQLite databases
Release datasette-upload-csvs 0.2a — Datasette plugin for uploading CSV files and converting them to database tables

How to cheat at unit tests with pytest and Black

I’ve been making a lot of progress on Datasette Cloud this week. As an application that provides private hosted Datasette instances (initially targeted at data journalists and newsrooms) the majority of the code I’ve written deals with permissions: allowing people to form teams, invite team members, promote and demote team administrators and suchlike.

[... 933 words]

Release geojson-to-sqlite 0.2 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
Release db-to-sqlite 1.1 — CLI tool for exporting tables or queries from any SQL database to a SQLite file
Release db-to-sqlite 1.1.1 — CLI tool for exporting tables or queries from any SQL database to a SQLite file

Feb. 13, 2020

A group of software engineers gathered around a whiteboard are a joint cognitive system. The scrawls on the board are spatial cues for building a shared model of a complex system.

Eric Dobbs

# 6:48 pm / collaboration

Feb. 14, 2020

pup. This is a great idea: a command-line tool for parsing HTML on stdin using CSS selectors. It’s like jq but for HTML. Supports a sensible collection of selectors and has a number of output options for the selected nodes, including plain text and JSON. It also works as a simple pretty-printer for HTML.

# 4:25 pm / cli, html, parsing

Feb. 17, 2020

Release shapefile-to-sqlite 0.1 — Load shapefiles into a SQLite (optionally SpatiaLite) database

Feb. 19, 2020

Release shapefile-to-sqlite 0.2 — Load shapefiles into a SQLite (optionally SpatiaLite) database

Things I learned about shapefiles building shapefile-to-sqlite

Visit Things I learned about shapefiles building shapefile-to-sqlite

The latest in my series of x-to-sqlite tools is shapefile-to-sqlite. I learned a whole bunch of things about the ESRI shapefile format while building it.

[... 1,073 words]

Feb. 21, 2020

So next time someone is giving you feedback about something you made, think to yourself that to win means getting two or three insights, ideas, or suggestions that you are excited about, and that you couldn’t think up on your own.

Juliette Cezzar

# 1:04 am / design

2020 » February

MTWTFSS
     12
3456789
10111213141516
17181920212223
242526272829