Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release dogsheep-photos 0.1a — Upload your photos to S3 and import metadata about them into a SQLite database
TIL Restricting SSH connections to devices within a Tailscale network — I'm running an AWS Lightsail instance and I want to only be able to SSH to it from devices connected to my [Tailscale](https://tailscale.com/) network.
None
Release datasette-publish-vercel 0.5 — Datasette plugin for publishing data using Vercel
Release datasette 0.40 — An open source multi-tool for exploring and publishing data
Release datasette-template-sql 1.0.1 — Datasette plugin for executing SQL queries from templates
TIL Close terminal window on Ctrl+D for macOS — I always forget how to set this up. It's hidden in Preferences -> Profiles -> Basic -> Shell:
None
TIL Get Skitch working on Catalina — I really like Skitch for taking screeshots, mainly because I like to snap a quick shot and then drag the icon onto a Google Doc or similar without saving the file anywhere.
None
Release github-to-sqlite 2.0 — Save data from GitHub to a SQLite database
TIL Use labels on Cloud Run services for a billing breakdown — Thanks to [@glasnt](https://github.com/glasnt) for the tip on this one. If you want a per-service breakdown of pricing on your Google Cloud Run services within a project (each service is a different deployed application) the easiest way to do it is to apply labels to those services, then request a by-label pricing breakdown.
None
Release datasette-template-sql 1.0 — Datasette plugin for executing SQL queries from templates
TIL Running pip install -e .[test] in zsh on macOS Catalina — macOS Catalina uses `zsh` rather than `bash` as the default shell (apparently because Apple don't like GPL 3).
None
TIL macOS Catalina sort-of includes Python 3 — Once you have installed the "command line tools" for Catalina using the following terminal command:
None
TIL Null case comparisons in SQLite — I wanted to say "output this transformed value if it's not null, otherwise nothing". The recipe I figured out was:
None
TIL Using macOS stickies to display a workshop link on the screen — When giving a workshop it's often useful to have a URL to the workshop materials visible on screen at all times. I use a bit.ly link for these.
None
TIL Running different steps on a schedule — Say you have a workflow that runs hourly, but once a day you want the workflow to run slightly differently - without duplicating the entire workflow.
None
TIL Lag window function in SQLite — Here's [how to use a lag window…
None
TIL Running a Python ASGI app on Vercel — Vercel really wants you to deploy static assets with [serverless functions](https://vercel.com/docs/serverless-functions/introduction) tucked away in a separate folder. They suggest creating modules like `api/index.py` which will be served up automatically as API backends to your client-side JavaScript.
None
TIL Commit a file if it changed — This recipe runs a Python script to update a README, then commits it back to the parent repo but only if it has changed:
None
TIL Convert a datetime object to UTC without using pytz — I wanted to convert a datetime object (from GitPython) to UTC without adding the `pytz` dependency.
None
TIL Set environment variables for all steps in a GitHub Action — From [this example](https://github.com/GoogleCloudPlatform/github-actions/blob/20c294aabd5331f9f7b8a26e6075d41c31ce5e0d/example-workflows/cloud-run/.github/workflows/cloud-run.yml) I learned that you can set environment variables such that they will be available in ALL jobs once at the top of a workflow:
None
TIL Dump out all GitHub Actions context — Useful for seeing what's available for `if: ` conditions (see [context and expression syntax](https://help.github.com/en/actions/reference/context-and-expression-syntax-for-github-actions)).
None
TIL Only run GitHub Action on push to master / main — Spotted in [this Cloud Run example](https://github.com/GoogleCloudPlatform/github-actions/blob/20c294aabd5331f9f7b8a26e6075d41c31ce5e0d/example-workflows/cloud-run/.github/workflows/cloud-run.yml):
None
Release datasette-publish-vercel 0.4.1a — Datasette plugin for publishing data using Vercel
Release github-to-sqlite 1.1 — Save data from GitHub to a SQLite database
Release twitter-to-sqlite 0.21 — Save data from Twitter to a SQLite database
Release github-to-sqlite 1.0.1 — Save data from GitHub to a SQLite database
Release sqlite-utils 2.6 — Python CLI utility and library for manipulating SQLite databases
Release datasette-auth-existing-cookies 0.7 — Datasette plugin that authenticates users based on existing domain cookies
Release paginate-json 0.3 — Command-line tool for fetching JSON from paginated APIs
Release datasette-clone 0.4.1 — Create a local copy of database files from a Datasette instance