Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release dogsheep-beta 0.3 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
None
TIL Using the gcloud run services list command — The `gcloud run services list` command lists your services running on Google Cloud Run:
None
TIL Looping over comma-separated values in Bash — Given a file (or a process) that produces comma separated values, here's how to split those into separate variables and use them in a bash script.
Release dogsheep-beta 0.2 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.1 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.1a2 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.1a — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
None
TIL Start a server in a subprocess during a pytest session — I wanted to start an actual server process, run it for the duration of my pytest session and shut it down at the end.
None
TIL Minifying JavaScript with npx uglify-js — While [upgrading CodeMirror](https://github.com/simonw/datasette/issues/948) in Datasette I figured out how to minify JavaScript using `uglify-js` on the command line without first installing any teels, using [npx](https://www.npmjs.com/package/npx) (which downloads and executes a CLI tool while skipping the install step):
Release airtable-export 0.4 — Export Airtable data to YAML, JSON or SQLite files on disk
Release datasette-yaml 0.1a — Export Datasette records as YAML
Release airtable-export 0.3.1 — Export Airtable data to YAML, JSON or SQLite files on disk
Release airtable-export 0.3 — Export Airtable data to YAML, JSON or SQLite files on disk
Release airtable-export 0.2 — Export Airtable data to YAML, JSON or SQLite files on disk
Release airtable-export 0.1.1 — Export Airtable data to YAML, JSON or SQLite files on disk
Release airtable-export 0.1 — Export Airtable data to YAML, JSON or SQLite files on disk
None
TIL Converting Airtable JSON for use with sqlite-utils using jq — The Airtable API outputs JSON that looks like this:
Release datasette 0.49a0 — An open source multi-tool for exploring and publishing data
Release sqlite-utils 2.16.1 — Python CLI utility and library for manipulating SQLite databases
None
TIL Browsing your local git checkout of homebrew-core — The [homebrew-core](https://github.com/Homebrew/homebrew-core) repository contains all of the default formulas for Homebrew.
Release asgi-csrf 0.7.1 — ASGI middleware for protecting against CSRF attacks
None
TIL Piping echo to a file owned by root using sudo and tee — I wanted to create a file with a shell one-liner where the file lived somewhere owned by root.
Release datasette-graphql 1.0.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.0 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.15 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-render-images 0.3.2 — Datasette plugin that renders binary blob images using data-uris
Release datasette-atom 0.7 — Datasette plugin that adds a .atom output format
Release shapefile-to-sqlite 0.4.1 — Load shapefiles into a SQLite (optionally SpatiaLite) database
None
TIL Rendering Markdown with the GitHub Markdown API — I wanted to convert the Markdown used in my TILs to HTML, using the exact same configuration as GitHub does. GitHub has a whole load of custom extensions for things like tables and syntax highlighting (see [issue 17](https://github.com/simonw/til/issues/17)).
Release shapefile-to-sqlite 0.4 — Load shapefiles into a SQLite (optionally SpatiaLite) database