Published in Better Programming·2 hours agoMember-only4 Levels of How To Use MakefileA quick introduction to Makefile — I love Makefile. Today, I use Makefile for most of the projects that I am working on. You may have seen Makefile in many open source projects on GitHub (e.g. this). Probably like me, you have wondered what Makefiles are and what they do. There is a bazillion of incredible…Programming7 min read
Sep 21Member-onlyHow to Sync Dota 2 Esports Matches To Google CalendarSync individual matches from TI11, Majors, and DPC Games to your GCal — I rely on Google Calendar to manage my rather chaotic schedule in life. Like you, I want to know what and when is the next Dota 2 tournament happening, especially for Major Championships and The International. I want to know exactly when the next Esports match or game is going…Dota 24 min read
Published in Better Programming·Jul 27Member-onlyHow I Back Up My Ghost Blog to a Cloud StorageDo it 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 for myself. …Programming6 min read
Published in Better Programming·Jul 4Member-onlyExporting PostgreSQL Queries to Google SheetsHow to export PostgreSQL queries to Google Sheets for free — 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 In this article, I am writing about…Programming5 min read
Published in Better Programming·May 26Member-onlyHow to Set Up CI/CD Pipeline For Cloudflare WorkerUsing GitHub Actions with Wrangler, k6, and semantic release — 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 Worker…Programming5 min read
Published in Better Programming·Apr 25Member-onlyGoodbye Heroku Postgres. Hello, RailwayI’m leaving Heroku Postgres for now. Here’s why — A little less than a year ago, I built Burplist, a free search engine for craft beer in Singapore. With the goal to keep my infrastructure cost as low as possible, I started off with Heroku Postgres free tier. With a row limit of 10,000 and a storage capacity of…Programming5 min read
Published in Better Programming·Apr 5Member-onlyHow to Run Self-hosted Renovate BotsAutomate dependency updates with Renovate with these 12 tips — 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. …Programming5 min read
Published in Better Programming·Mar 23Member-onlyHow I Scrapped the Entire Michelin Guide Using Golang CollyI scraped the Michelin guide. Here’s how — At the beginning of the automobile era, Michelin, a tire company, created a travel guide, including a restaurant guide. Through the years, Michelin stars have become very prestigious due to their high standards and very strict anonymous testers. Michelin Stars are incredibly coveted. …Go7 min read
Feb 22How To Get Cashback From Money TransferEarning credit card cashback on fund transfers is now possible in Singapore — I’m a huge personal finance nerd. I have never been so happy to discover and share this — earning credit card cashback on money transfers is now possible! Here, I am going to share with you how you can earn 1.5% …Singapore7 min read
Published in Better Programming·Feb 11Member-onlyHow To Manage Dotfiles With ChezmoiA quick guide to managing dotfiles for the lazy — There is a bazillion of tutorials and resources on how to manage dotfiles out there. If you haven’t heard of “dotfiles”, they are config files in Unix-like systems that start with a dot, e.g. .bashrc, .zshrc, .vimrc, .gitconfig just to name a few. By default, dotfiles are hidden and they…Programming6 min read
