Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette-graphql 2.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-edit-schema 0.5 — Datasette plugin for modifying table schemas
Sighting 1:55 PM — Botta's Pocket Gopher, in Monterey Bay National Marine Sanctuary, CA, US, CA
Botta's Pocket Gopher
Botta's Pocket Gopher
Release s3-ocr 0.4 — Tools for running OCR against files stored in S3
Release s3-credentials 0.12 — A tool for creating credentials for accessing S3 buckets
Release s3-ocr 0.3 — Tools for running OCR against files stored in S3
Sighting 1:48 PM — Brown Pelican, in Monterey Bay National Marine Sanctuary, CA, US, CA
Brown Pelican
Brown Pelican
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
None
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.
Sighting 8:17 PM — Eastern Gray Squirrel, in Capitol Park, CA, US
Eastern Gray Squirrel
Eastern Gray Squirrel
Sighting 1:05 PM — Red-tailed Hawk, in Pillar Point Harbor, CA, US
Red-tailed Hawk
Red-tailed Hawk
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
Sighting 10:06 AM — Cottontail Rabbits, in Pillar Point Harbor, CA, US
Cottontail Rabbits
Cottontail Rabbits
None
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:
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
None
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.
Sighting 8:10 AM – 11:16 AM — Pacific Harbor Seal, White-speckled Dorid, Ochre Sea Star, Brown Pelican, Great Blue Heron, in San Mateo County, CA, US
Pacific Harbor Seal
Pacific Harbor Seal
White-speckled Dorid
White-speckled Dorid
Ochre Sea Star
Ochre Sea Star
Brown Pelican
Brown Pelican
Great Blue Heron
Great Blue Heron
Sighting 12:06 PM – 1:15 PM — Common Raven, European Starling, California Ground Squirrel, in San Mateo County, CA, US
Common Raven
Common Raven
European Starling
European Starling
California Ground Squirrel
California Ground Squirrel
Release sqlite-utils 3.27 — Python CLI utility and library for manipulating SQLite databases
None
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`.
Sighting 3:59 PM — Black Oystercatcher, in Monterey Bay National Marine Sanctuary, CA, US, CA
Black Oystercatcher
Black Oystercatcher
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