Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Release TIL Research Tool Museum

Filters: Sorted by date

Release datasette 0.50.1 — An open source multi-tool for exploring and publishing data
10th Oct 2020, 12:44 am · datasette
Release datasette 0.50 — An open source multi-tool for exploring and publishing data
9th Oct 2020, 5:58 pm · datasette
TIL Running Datasette on DigitalOcean App Platform — [App Platform](https://www.digitalocean.com/docs/app-platform/) is the new PaaS from DigitalOcean. I figured out how to run Datasette on it.
7th Oct 2020, 2:45 am
Release datasette 0.50a1 — An open source multi-tool for exploring and publishing data
6th Oct 2020, 8:52 pm · datasette
TIL Manipulating query strings with URLSearchParams — The `URLSearchParams` class, in [every modern browser](https://caniuse.com/?search=URLSearchParams) since IE 11, provides a sensible API for manipulating query string parameters in JavaScript. I first used it to build Datasette's column action menu, see [table.js](https://github.com/simonw/datasette/blob/0.50a0/datasette/static/table.js) and [issue 981](https://github.com/simonw/datasette/issues/981).
4th Oct 2020, 6:35 pm
TIL Using async/await in JavaScript in Selenium — Thanks [Stuart Langridge](https://twitter.com/sil/status/1312137808111304704) for showing me how to do this:
2nd Oct 2020, 9:19 pm
TIL Installing Selenium for Python on macOS with ChromeDriver — I needed to run Selenium on macOS for the first time today. Here's how I got it working.
2nd Oct 2020, 8:06 pm
Release datasette 0.50a0 — An open source multi-tool for exploring and publishing data
1st Oct 2020, 11:35 pm · datasette
Release datasette-cluster-map 0.12.4 — Datasette plugin that shows a map for any data with latitude/longitude columns
1st Oct 2020, 11:24 pm · datasette
Release datasette-edit-schema 0.3 — Datasette plugin for modifying table schemas
1st Oct 2020, 10:41 pm · datasette
Release datasette-edit-schema 0.3a2 — Datasette plugin for modifying table schemas
1st Oct 2020, 9:28 pm · datasette
TIL Escaping strings in Bash using !:q — TIL this trick, [via Pascal Hirsch](https://twitter.com/phphys/status/1311727268398465029) on Twitter. Enter a line of Bash starting with a `#` comment, then run `!:q` on the next line to see what that would be with proper Bash escaping applied.
1st Oct 2020, 8:32 pm
Release datasette-cluster-map 0.12.3 — Datasette plugin that shows a map for any data with latitude/longitude columns
1st Oct 2020, 12:30 am · datasette
Release datasette-cluster-map 0.12.2 — Datasette plugin that shows a map for any data with latitude/longitude columns
1st Oct 2020, 12:11 am · datasette
Release datasette-cluster-map 0.12.1 — Datasette plugin that shows a map for any data with latitude/longitude columns
30th Sep 2020, 6:30 pm · datasette
Release datasette-edit-schema 0.3a1 — Datasette plugin for modifying table schemas
30th Sep 2020, 6:12 pm · datasette
Release datasette-edit-schema 0.3a — Datasette plugin for modifying table schemas
30th Sep 2020, 5 pm · datasette
Release datasette-dateutil 0.2.1 — dateutil functions for Datasette
30th Sep 2020, 1:07 am · datasette
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

Beats

Years

Tags