Google OIDC token generation/validation

One of the authentication protocol that is supported by most of Google Cloud services is OpenID Connect (OIDC). For instance, you can secure communication between a Cloud Task and HTTP-triggred Cloud Function using it quite easily. You just need to pass service account email when submitting Cloud Task job and make sure you keep the…

Fast geolocation query with PostGIS

If you need to to add a spatial information querying in your application, PostGIS is one of the most popular solution. Simply because it is well-proven, open source, and running on top of everyone’s favorite open source SQL database — PostgreSQL. PostGIS is a spatial database extender for PostgreSQL object-relational database. postgis.net In this post,…

Auto speech-to-text (Indonesian) with AWS Transcribe and Python

Amazon Web Service Transcribe provides API to automatically convert an audio speech file (mp3/wav) into a text (transcript). It supports not only English language but also Indonesian and several other languages. It even gives free 60 minutes/month for first 12 months transcription for first user. If you are using Python, then the good news is…

Splitting video with ffmpeg and Python

I had a project to build a simple website that split uploaded video into parts that have same duration (except the last one if the division has remainder). Almost everyone in the internet suggest ffmpeg which is so far considered the best open-source swiss-army knife for video manipulation. After hours of browsing and trial-and-errors, I…

Upwork Indonesia FAQ

I keep seeing people asking the same thing in Upwork Indonesia group (formerly Odesk Indonesia). So I decided to write this FAQ so that I don’t have to rewrite the same thing every time (while hopefully also increase my website popularity 😁). This post will be bilingual as I expect the primary reader will be…