Gerald Png

about me

based in singapore
software engineer in govtech singapore, experimental systems and technology lab, ministry of education
co-founder / lead developer of greatescape.co and covidcontrols.co

what i do

software engineering / full stack development
try to create useful or interesting apps

things i've made

Escape

Don't know where to go? Explore the cheapest trips from your city to every tourist destination in the world on any given travel dates. Compare all the trips on a fun and interactive map with respect to the weather forecast, popularity, safety levels, visa requirements and so on.

Covid Controls

Covid Controls tracks and visualizes how governments around the world are responding to the Covid-19 outbreak. It collects data on lockdown measures, quarantine policies, tourists bans along with numbers on how the disease is spreading in every country and state around the world.

FINeDER

Find fine dining restaurants in Singapore. I made this because I realized that there is no single source of information of fine dining restaurants, especially their set menu prices. With this site, you can filter by price, Michelin stars, google ratings, lunch/dinner days, cuisine, and even dress code.

Geodle

A geography-based variant of Wordle, inspired by Worldle. You have 6 attempts to guess the daily location. Initiatlly released with 2 puzzles, Singapore MRTs & LRTs, and Singapore MRTs only.

TeleSheets Expense Bot

This telegram bot allows you to easily track your expenses on a Google Sheet by sending messages in private and group chats. Initially a private bot as I wanted an easy way to keep track of expenses, and a combination of Google Sheets + a messenging app that I'm used to. Extended it so anyone can connect their Google Sheets and use it too.

MeetGoWhere

Enter postal codes, and see where the are the best places to meetup in Singapore based on travel times. Made in response to colleagues lamenting about organizing team lunches when everyone stays all over Singapore.

Broker Fees SG

Compare fees for trading US,HK and SG stocks across popular brokers in SG, such as IBKR, Saxo, Tiger Brokers, FSMOne and MooMoo

RSwagGen

Generate RSwag schema from JSON input. Writing RSwag schema for JSON input/output was a super tedious process, so wrote this simple utility to generate a skeleton schema from a JSON object.

Go Log Utils

VS Code Extension. Easily insert and remove log.Println statements.

Text To XML Safe String

VS Code Extension. Formats text to XML safe string, replace linebreaks (\n), tabs (\t), and special characters (&, ', ", <, >). Made this as we needed a way to convert multi-line Go code into strings in xml.

Wheel Tracker

Track your option wheel status and performance.

GE2020 Lineups

View all candidates that contested in Singapore's General Elections 2020, with final and historical results. Made in 1 day, in response to a lack of coordinated news by the various political parties. The goal was to visualise the confirmed/unconfirmed lineups that each party had announced before nomination day.

SG Delivery Slots Telegram Bot

During the Covid-19 period, delivery slots from the major supermarkets were a rare commodity that were being snapped up immediately. SG Delivery Slots Bot was created to notify users based on their postcode, when a delivery slot opens up near to them. Decommissioned due to increased security by the major supermarkets on their API endpoints.