Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

TIL Conditionally running a second job in a GitHub Actions workflow — My [simonwillisonblog-backup workflow](https://github.com/simonw/simonwillisonblog-backup/blob/main/.github/workflows/backup.yml) periodically creates a JSON backup of my blog's PostgreSQL database, using [db-to-sqlite](https://datasette.io/tools/db-to-sqlite) and [sqlite-diffable](https://datasette.io/tools/sqlite-diffable). It then commits any changes back to the repo using this pattern:
Release sqlite-comprehend 0.2.1 — Tools for running data in a SQLite database through AWS Comprehend
Release sqlite-comprehend 0.2 — Tools for running data in a SQLite database through AWS Comprehend
Release sqlite-diffable 0.4 — Tools for dumping/loading a SQLite database to diffable directory structure
Release sqlite-diffable 0.3 — Tools for dumping/loading a SQLite database to diffable directory structure
Release sqlite-comprehend 0.1 — Tools for running data in a SQLite database through AWS Comprehend
Release sqlite-comprehend 0.1a0 — Tools for running data in a SQLite database through AWS Comprehend
TIL Reporting bugs in GitHub to GitHub — I found out today (via [this post](https://github.com/github-community/community/discussions/19988)) about a dedicated interface for reporting bugs in GitHub to GitHub:
TIL Passing command arguments using heredoc syntax — This trick works for both Bash and zsh.
Release datasette-redirect-to-https 0.2 — Datasette plugin that redirects all non-https requests to https
Release datasette-unsafe-expose-env 0.1.1 — Datasette plugin to expose some environment variables at /-/env for debugging
Release datasette-expose-env 0.1 — Datasette plugin to expose selected environment variables at /-/env for debugging
Release datasette-upload-csvs 0.7.2 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-packages 0.2 — Show a list of currently installed Python packages
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
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
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.
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.
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:
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.

Beats

Years

Tags