Monday, 11th July 2022
Release
sqlite-diffable 0.4
— Tools for dumping/loading a SQLite database to diffable directory structure
Release
sqlite-comprehend 0.2.1
— Tools for running data in a SQLite database through AWS Comprehend
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:
sqlite-comprehend: run AWS entity extraction against content in a SQLite database
I built a new tool this week: sqlite-comprehend, which passes text from a SQLite database through the AWS Comprehend entity extraction service and stores the returned entities.
[... 1,146 words]