Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release sqlite-utils 3.1 — Python CLI utility and library for manipulating SQLite databases
Release datasette-publish-fly 1.0.1 — Datasette plugin for publishing data using Fly
TIL Skipping CSV rows with odd numbers of quotes using ripgrep — I'm working with several huge CSV files - over 5 million rows total - and I ran into a problem: it turned out there were a few lines in those files that imported incorrectly because they were not correctly escaped.
Release datasette-auth-passwords 0.3.3 — Datasette plugin for authentication using passwords
Release datasette 0.53 — An open source multi-tool for exploring and publishing data
Release datasette-column-inspect 0.2a — Experimental plugin that adds a column inspector
Release datasette-pretty-json 0.2.1 — Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays
Release datasette 0.52.5 — An open source multi-tool for exploring and publishing data
TIL Escaping a SQL query to use with curl and Datasette — I used this pattern to pass a SQL query to Datasette's CSV export via curl and output the results, stripping off the first row (the header row) using `tail -n +2`.
Release yaml-to-sqlite 0.3.1 — Utility for converting YAML files to SQLite
TIL Controlling the style of dumped YAML using PyYAML — I had a list of Python dictionaries I wanted to output as YAML, but I wanted to control the style of the output.
TIL Using custom Sphinx templates on Read the Docs — I wanted to make a small customization to one of my documentation templates on Read the Docs.
Release datasette-seaborn 0.2a0 — Statistical visualizations for Datasette using Seaborn
TIL Running Python code in a subprocess with a time limit — I figured out how to run a subprocess with a time limit for [datasette-ripgrep](https://github.com/simonw/datasette-ripgrep), using the `asyncio.create_subprocess_exec()` method. The pattern looks like this:
Release datasette 0.52.4 — An open source multi-tool for exploring and publishing data
Release datasette-search-all 1.0.1 — Datasette plugin for searching all searchable tables at once
Release datasette 0.52.3 — An open source multi-tool for exploring and publishing data
Release datasette 0.52.2 — An open source multi-tool for exploring and publishing data
Release datasette-yaml 0.1.1 — Export Datasette records as YAML
Release datasette-graphql 1.3.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.3 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release github-to-sqlite 2.8.1 — Save data from GitHub to a SQLite database
Release github-to-sqlite 2.8 — Save data from GitHub to a SQLite database
Release datasette 0.52.1 — An open source multi-tool for exploring and publishing data
Release datasette 0.52 — An open source multi-tool for exploring and publishing data
Release datasette-ripgrep 0.6.1 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-ripgrep 0.6 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-ripgrep 0.5 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-ripgrep 0.4 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-ripgrep 0.3 — Web interface for searching your code using ripgrep, built as a Datasette plugin

Beats

Years

Tags