Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Release TIL Research Tool Museum

Filters: Sorted by date

Release datasette-query-links 0.1 — Turn SELECT queries returned by a query into links to execute them
9th Aug 2021, 1:23 am
Release datasette 0.59a1 — An open source multi-tool for exploring and publishing data
9th Aug 2021, 1:14 am · datasette
Release datasette-pyinstrument 0.1 — Use pyinstrument to analyze Datasette page performance
8th Aug 2021, 3:43 pm · datasette
Release datasette 0.59a0 — An open source multi-tool for exploring and publishing data
7th Aug 2021, 5:42 am · datasette
TIL Compressing an animated GIF with gifsicle or ImageMagick mogrify — ## Using gifsicle
6th Aug 2021, 5:02 am
TIL SQLite aggregate filter clauses — SQLite supports aggregate filter clauses (as of [3.30.0, released 2019-10-04](https://www.sqlite.org/changes.html#version_3_30_0)), as described in this [SQL Pivot in all databases](https://modern-sql.com/use-case/pivot) tutorial.
4th Aug 2021, 9:08 pm
TIL Set a GIF to loop using ImageMagick — I managed to accidentally create a GIF that ran once without looping. I think this is because I created it in [LICEcap](https://www.cockos.com/licecap/) but then deleted some frames and re-saved it using macOS Preview.
3rd Aug 2021, 9:54 pm
TIL Check spelling using codespell — Today I discovered [codespell](https://github.com/codespell-project/codespell/) via [this Rich commit](https://github.com/willmcgugan/rich/commit/9c12a4537499797c43725fff5276ef0da62423ef#diff-ce84a1b2c9eb4ab3ea22f610cad7111cb9a2f66365c3b24679901376a2a73ab2). `codespell` is a really simple spell checker that can be run locally or incorporated into a CI flow.
3rd Aug 2021, 4:34 pm
Release sqlite-transform 1.2.1 — Tool for running transformations on columns in a SQLite database
2nd Aug 2021, 10:07 pm
Release sqlite-utils 3.14 — Python CLI utility and library for manipulating SQLite databases
2nd Aug 2021, 9:34 pm · sqlite, sqlite-utils
TIL Search and replace with regular expressions in VS Code — I wanted to replace all instances of this:
2nd Aug 2021, 9:30 pm
Release datasette-json-html 1.0.1 — Datasette plugin for rendering HTML based on JSON values
31st Jul 2021, 7:22 pm · datasette
Release datasette-json-html 1.0 — Datasette plugin for rendering HTML based on JSON values
31st Jul 2021, 7:10 pm · datasette
Release datasette-publish-fly 1.0.2 — Datasette plugin for publishing data using Fly
30th Jul 2021, 10:11 pm · datasette
Release datasette-remote-metadata 0.1 — Periodically refresh Datasette metadata from a remote URL
29th Jul 2021, 1:43 am · datasette
Release datasette-remote-metadata 0.1a0 — Periodically refresh Datasette metadata from a remote URL
28th Jul 2021, 11:28 pm · datasette
Release datasette-haversine 0.2 — Datasette plugin that adds a custom SQL function for haversine distances
28th Jul 2021, 8:14 pm · datasette
Release datasette-publish-vercel 0.10 — Datasette plugin for publishing data using Vercel
25th Jul 2021, 6:38 pm · datasette
TIL Extracting objects recursively with jq — The Algolia-powered Hacker News API returns nested comment threads that look like this: https://hn.algolia.com/api/v1/items/27941108
25th Jul 2021, 3:58 am
Release sqlite-transform 1.2 — Tool for running transformations on columns in a SQLite database
25th Jul 2021, 1:02 am
Release sqlite-utils 3.13 — Python CLI utility and library for manipulating SQLite databases
24th Jul 2021, 10:17 pm · sqlite, sqlite-utils
Release sqlite-transform 1.1 — Tool for running transformations on columns in a SQLite database
21st Jul 2021, 7:05 pm
Release sqlite-transform 1.0 — Tool for running transformations on columns in a SQLite database
21st Jul 2021, 1:05 am
TIL Using the tesseract CLI tool — Tesseract OCR has a command-line utility which is woefully under-documented. Thanks to [Alexandru Nedelcu](https://alexn.org/blog/2020/11/11/organize-index-screenshots-ocr-macos.html) I figured out how to use it today.
18th Jul 2021, 4:56 pm
Release datasette-export-notebook 1.0 — Datasette plugin providing instructions for exporting data to Jupyter or Observable
17th Jul 2021, 4:01 am · datasette
Release datasette-graphql 1.5 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
16th Jul 2021, 8:03 pm · datasette
Release datasette 0.58.1 — An open source multi-tool for exploring and publishing data
16th Jul 2021, 7:51 pm · datasette
Release datasette 0.58 — An open source multi-tool for exploring and publishing data
15th Jul 2021, 12:37 am · datasette
TIL Importing CSV data into SQLite with .import — I usually use my `sqlite-utils insert blah.db tablename file.csv --csv` command to import CSV data into SQLite, but for large CSV files (like a 750MB one) this can take quite a long time - over half an hour in this case.
14th Jul 2021, 5:01 am
Release conditional-get 0.3 — CLI tool for fetching data using HTTP conditional get
14th Jul 2021, 3:28 am

Beats

Years

Tags