Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release s3-ocr 0.2a0 — Tools for running OCR against files stored in S3
Release s3-ocr 0.1a0 — Tools for running OCR against files stored in S3
TIL Running OCR against a PDF file with AWS Textract — [Textract](https://aws.amazon.com/textract/) is the AWS OCR API. It's very good - I've fed it hand-written notes from the 1890s and it read them better than I could.
None
TIL Ignoring errors in a section of a Bash script — For [simonw/museums#32](https://github.com/simonw/museums/issues/32) I wanted to have certain lines in my Bash script ignore any errors: lines that used `sqlite-utils` to add columns and configure FTS, but that might fail with an error if the column already existed or FTS had already been configured.
None
Release datasette-scale-to-zero 0.1.2 — Quit Datasette if it has not received traffic for a specified time period
Release datasette-scale-to-zero 0.1.1 — Quit Datasette if it has not received traffic for a specified time period
Release datasette-scale-to-zero 0.1 — Quit Datasette if it has not received traffic for a specified time period
TIL One-liner for running queries against CSV files with SQLite — I figured out how to run a SQL query directly against a CSV file using the `sqlite3` command-line utility:
None
Release datasette-socrata 0.3 — Import data from Socrata into Datasette
Release datasette-low-disk-space-hook 0.1 — Datasette plugin providing the low_disk_space hook for other plugins to check for low disk space
TIL Registering new Datasette plugin hooks by defining them in other plugins — I'm experimenting with a Datasette plugin that itself adds new plugin hooks which other plugins can then interact with.
None
Release sqlite-utils 3.27 — Python CLI utility and library for manipulating SQLite databases
TIL Using iconv to convert the text encoding of a file — In [sqlite-utils issue 439](https://github.com/simonw/sqlite-utils/issues/439) I was testing against a CSV file that used UTF16 little endian encoding, also known as `utf-16-le`.
None
Release datasette-low-disk-space-hook 0.1a0 — Datasette plugin providing the low_disk_space hook for other plugins to check for low disk space
Release datasette-socrata 0.2 — Import data from Socrata into Datasette
Release datasette-ics 0.5.1 — Datasette plugin for outputting iCalendar files
Release datasette-socrata 0.1.1 — Import data from Socrata into Datasette
Release datasette-socrata 0.1 — Import data from Socrata into Datasette
Release datasette-upload-csvs 0.7.1 — Datasette plugin for uploading CSV files and converting them to database tables
TIL Formatting thousands in Jinja — Here's how to format a number in Jinja with commas for thousands, without needing any custom filters or template functions:
None
TIL Making HTTP calls using IPv6 — Tiny TIL today: I learned how to make an HTTP call to an IPv6 address. The trick is to enclose the address in the URL in square braces:
None
TIL Using just with Django — Jeff Triplett [convinced me](https://twitter.com/webology/status/1532860591307726851) to take a look at [just](https://github.com/casey/just) as a command automation tool - sort of an alternative to Make, except with a focus on commands rather than managing build dependencies.
None
Release datasette-upload-csvs 0.7 — Datasette plugin for uploading CSV files and converting them to database tables
Release mbox-to-sqlite 0.1a0 — Load email from .mbox files into SQLite
Release datasette-graphql 2.0.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-auth-existing-cookies 1.0a1 — Datasette plugin that authenticates users based on existing domain cookies
Release datasette-auth-existing-cookies 1.0a0 — Datasette plugin that authenticates users based on existing domain cookies
TIL Wildcard DNS and SSL on Fly — [Fly](https://fly.io/) makes it surprisingly easy to configure wildcard DNS, such that `anything.your-new-domain.dev` is served by a single Fly application (which can include multiple instances in multiple regions with global load-balancing).
None
TIL Writing Fly logs to S3 — [Fly](https://fly.io/) offers [fly-log-shipper](https://github.com/superfly/fly-log-shipper) as a container you can run in a Fly application to send all of the logs from your other applications to a logging provider.
None
Release datasette-unsafe-expose-env 0.1 — Datasette plugin to expose some environment variables at /-/env for debugging