GitHub - Jerry Ng

Sign in Subscribe

GitHub

Where the world builds software.

How I Saved Scraped Data in an SQLite Database on GitHub

Some time back, I stumbled upon this amazing idea of Git scraping made popular by Simon Willison. It involves using GitHub Actions to scrape data and save it directly into a Git repository. Essentially, for each new set of data scraped, a new commit is created in your repository. The

Shipping containers at shipping port

I Export PostgreSQL Queries to Google Sheets For Free. Here’s How

A couple of years ago, I wouldn’t have known that connecting a PostgreSQL database to Google Sheets could be this expensive. Despite being a trivial problem, existing market solutions such as Zapier, KPIBees, etc. require us to pay a premium for it. TL;DR: How to export PostgreSQL queries

Semantic git commits

How I Set Up CI/CD Pipeline for Cloudflare Worker

Today, most of my projects on GitHub are kept up to date with Renovate. With auto-merging enabled, I want to have enough confidence that the automated dependencies update would not cause any regressions. Testing Cloudflare Worker is a bit out of whack. Don’t get me wrong, I love Cloudflare

Written by human. Hosted on Digital Ocean.