Backing Up Ghost Blog in 5 Steps

I’ve been writing on my self-hosted Ghost blog for some time now. In case you’re wondering, this site is hosted on a Digital Ocean Droplet. For the most part, I felt like I was doing something inconsequential that only meant much to me. Today, the site has grown

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

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

Saying Goodbye to Heroku Postgres for Now

A little less than a year ago, I built Burplist, a free search engine for craft beer in Singapore. Intending to keep my infrastructure cost as low as possible, I started with Heroku Postgres free tier. With a row limit of 10,000 and a storage capacity of 1 GB,

12 Tips to Self-host Renovate Bot

Updating dependencies is boring. Despite its importance, we always find excuses to avoid updating them in the phrase of “if it ain't broke, don't fix it” or “there are more important features to work on”. Over time, the maintainability of the projects deteriorates. The team ends