Elsewhere

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:

21st Apr 2020, 4:43 pm

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.

20th Apr 2020, 4:41 pm

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.

20th Apr 2020, 2:39 pm

TIL Lag window function in SQLite — Here's [how to use a lag window…

19th Apr 2020, 11:23 pm

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.

19th Apr 2020, 10:28 pm

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:

19th Apr 2020, 5:27 pm

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.

19th Apr 2020, 4:02 pm

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:

19th Apr 2020, 2:55 pm

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)).

19th Apr 2020, 2:50 pm

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):

19th Apr 2020, 2:46 pm

Release datasette-publish-vercel 0.4.1a — Datasette plugin for publishing data using Vercel

19th Apr 2020, 12:04 pm · datasette

Release github-to-sqlite 1.1 — Save data from GitHub to a SQLite database

18th Apr 2020, 3:09 pm

Release twitter-to-sqlite 0.21 — Save data from Twitter to a SQLite database

17th Apr 2020, 11:46 pm

Release github-to-sqlite 1.0.1 — Save data from GitHub to a SQLite database

16th Apr 2020, 6:09 pm

Release sqlite-utils 2.6 — Python CLI utility and library for manipulating SQLite databases

16th Apr 2020, 3:14 am · sqlite, sqlite-utils

Release datasette-auth-existing-cookies 0.7 — Datasette plugin that authenticates users based on existing domain cookies

15th Apr 2020, 3:23 pm · datasette

Release paginate-json 0.3 — Command-line tool for fetching JSON from paginated APIs

14th Apr 2020, 7:35 pm

Release datasette-clone 0.4.1 — Create a local copy of database files from a Datasette instance

14th Apr 2020, 5:25 pm · datasette

Release datasette-clone 0.4 — Create a local copy of database files from a Datasette instance

14th Apr 2020, 5:20 pm · datasette

Release datasette-mask-columns 0.2 — Datasette plugin that masks specified database columns

14th Apr 2020, 4:51 pm · datasette

Release datasette-mask-columns 0.1 — Datasette plugin that masks specified database columns

14th Apr 2020, 4:49 pm · datasette

Release datasette-clone 0.3 — Create a local copy of database files from a Datasette instance

14th Apr 2020, 1:29 am · datasette

Release datasette-clone 0.2 — Create a local copy of database files from a Datasette instance

13th Apr 2020, 11:16 pm · datasette

Release datasette-clone 0.1 — Create a local copy of database files from a Datasette instance

13th Apr 2020, 11:09 pm · datasette

Release sqlite-utils 2.5 — Python CLI utility and library for manipulating SQLite databases

13th Apr 2020, 3:54 am · sqlite, sqlite-utils

Release datasette-auth-github 0.12 — Datasette plugin that authenticates users against GitHub

10th Apr 2020, 4:41 am · datasette

Release datasette-jq 0.2.1 — Datasette plugin that adds a custom SQL function for executing jq expressions against JSON values

9th Apr 2020, 5:43 am · datasette

Release datasette-publish-vercel 0.4a — Datasette plugin for publishing data using Vercel

9th Apr 2020, 5:13 am · datasette

Release datasette-publish-vercel 0.3a — Datasette plugin for publishing data using Vercel

8th Apr 2020, 4:56 am · datasette

Release datasette-cluster-map 0.9.1 — Datasette plugin that shows a map for any data with latitude/longitude columns

8th Apr 2020, 2:35 am · datasette

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags