Update DB workflow (marcelscruz/public-apis)

The Update DB workflow from marcelscruz/public-apis, explained and optimized by Latchkey.

What it does

This is the Update DB workflow from the marcelscruz/public-apis repository, a real project running GitHub Actions. It is shown here with attribution under its MIT license.

Below, Latchkey shows a faster, safer version produced by its optimization engine.

The workflow

name: Update DB

on:
    push: { branches: main }
    # schedule:
    #     # Every day at 00:00AM
    #     - cron: '0 0 * * *'
    workflow_dispatch:

jobs:
    update-db:
        runs-on: ubuntu-latest
        steps:
            - uses: actions/checkout@v3
            - uses: actions/setup-node@v3
            - run: npm install
            - run: npm run update-db
            - run: |
                  git config user.name "GitHub Actions Bot"
                  git config user.email "<>"
            - run: git add .
            - run: git commit -m "Auto updating db" || echo "Nothing to commit"
            - run: git push origin HEAD:main

The same workflow, on Latchkey

Estimated ~20% faster on cache hits, plus fewer wasted runs and a safer supply chain. Added and changed lines are highlighted.

name: Update DB
 
on:
    push: { branches: main }
    # schedule:
    #     # Every day at 00:00AM
    #     - cron: '0 0 * * *'
    workflow_dispatch:
 
concurrency:
    group: ${{ github.workflow }}-${{ github.ref }}
    cancel-in-progress: true
 
jobs:
    update-db:
        timeout-minutes: 30
        runs-on: latchkey-small
        steps:
            - uses: actions/checkout@v3
            - uses: actions/setup-node@v3
              with:
                  cache: 'npm'
            - run: npm install
            - run: npm run update-db
            - run: |
                  git config user.name "GitHub Actions Bot"
                  git config user.email "<>"
            - run: git add .
            - run: git commit -m "Auto updating db" || echo "Nothing to commit"
            - run: git push origin HEAD:main
 

What changed

• Run on Latchkey managed runners with one line (runs-on), which apply the fixes below automatically and self-heal transient failures. This example uses latchkey-small; pick the runner size that fits the job.
• Cancel superseded runs when a branch or PR gets a newer push.
• Cache dependency installs on the setup step so they are served from cache.
• Add a job timeout so a hung step cannot burn hours of runner time.

What Latchkey heals here

This workflow has steps that commonly fail on transient issues (network, registries, flaky browsers). On Latchkey managed runners they are detected, retried, and self-healed instead of failing your build:

• Dependency installs

This workflow runs 1 job per trigger. On Latchkey the same minutes cost up to 58% less than GitHub-hosted, with zero queue time.

Actions used in this workflow