Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette 0.62a1 — An open source multi-tool for exploring and publishing data
Sighting 5:30 PM – 5:43 PM — Western Fence Lizard, in Rancho Corral de Tierra, CA, US
Western Fence Lizard
Western Fence Lizard
Western Fence Lizard
Western Fence Lizard
Release sqlite-utils 3.28 — Python CLI utility and library for manipulating SQLite databases
None
TIL Freezing requirements with pip-tools — I tried [pip-tools](https://github.com/jazzband/pip-tools) for the first time today to pin the requirements for the [natbat/pillarpointstewards](https://github.com/natbat/pillarpointstewards) Django app.
Sighting 4:42 PM — Pacific Sea Nettle, in Pillar Point Harbor, CA, US
Pacific Sea Nettle
Pacific Sea Nettle
None
TIL Testing Electron apps with Playwright and GitHub Actions — Yesterday [I figured out (issue 133)](https://github.com/simonw/datasette-app/issues/133) how to use Playwright to run tests against my Electron app, and then execute those tests in CI using GitHub Actions, for my [datasett-app](https://github.com/simonw/datasette-app) repo for my [Datasette Desktop](https://datasette.io/desktop) macOS application.
Release datasette-publish-vercel 0.14 — Datasette plugin for publishing data using Vercel
None
TIL Upgrading packages with npm — There's a new version of [Vite](https://vitejs.dev/) out (3.0) and I wanted to upgrade my [datasette-table](https://github.com/simonw/datasette-table) package to use it.
Release datasette-app 0.2.2 — The Datasette macOS application
Release datasette-app-support 0.11.6 — Part of https://github.com/simonw/datasette-app
Release sqlite-comprehend 0.2.2 — Tools for running data in a SQLite database through AWS Comprehend
Release datasette-ics 0.5.2 — Datasette plugin for outputting iCalendar files
None
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
None
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:
Sighting 5:13 PM — Brown Pelican, in Monterey Bay National Marine Sanctuary, CA, US, CA
Brown Pelican
Brown Pelican
None
TIL Passing command arguments using heredoc syntax — This trick works for both Bash and zsh.
Sighting 6:19 PM — Common Raven, in Monterey Bay National Marine Sanctuary, CA, US, CA
Common Raven
Common Raven
Common Raven
Common Raven
Sighting 3:07 PM — Common Raven, in San Mateo County, CA, US
Common Raven
Common Raven
Common Raven
Common Raven
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
Sighting 8:55 AM — Pacific Harbor Seal, in Montara State Marine Reserve, US, CA
Pacific Harbor Seal
Pacific Harbor Seal
Release datasette-packages 0.2 — Show a list of currently installed Python packages