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

Artikel ini merupakan rangkuman dari pertanyaan-jawaban yang sering muncul di grup Facebook Upworker Indonesia (sebelumnya Odesk Indonesia). Seiring dengan bertambahnya pertanyaan di grup tersebut, artikel ini juga akan terus saya perbaharui. Semoga membantu 🍻 Q: Profil saya ditolak. Bagaimana caranya supaya bisa diterima?A: Jika Upwork belum menerima profil Anda, kemungkinannya adalah antara profil Anda belum…