tanin

Sign in Subscribe

Latest — Sep 30, 2026

My experience using JOOQ with Scala and Postgres

I've recently picked up JOOQ for building complex queries in Book of Revenue. I previously constructed raw SQLs using Slick. Slick is nice enough to support binding values and concatenating portions of SQL safely. Still, writing raw SQLs is friable. Reusing a subquery of SQLs in multiple queries

More issues

Postgres AT TIME ZONE 'UTC' does NOT do what you think it does

And why you may need to repeat AT TIME ZONE 'UTC' twice. SUMMARY * AT TIME ZONE 'UTC' converts the data type from timestamptz to timestamp (example). * Now you are inadvertently using the timestamp without time zone (aka timestamp) data type, which is markedly discouraged. * There are

Set up a Claude DOCX sub-agent and reduce cost by 50%

Or how to set up a subagent in Claude Code and Cowork.

Ruby vs. Java vs. TypeScript: my experience on building a Cowork DOCX plugin

Ruby is used for the first prototype. Java is the easiest to write and has the most mature libraries with zero issues. TypeScript has been chosen due to its ecosystem where Claude Desktop may potentially provide MCPB support which reduces the binary size by 99%.

Support per-field update with Scala Slick

I want to show you how I support per-field update with Slick + Postgres. Note This blog serves as a documentation for PlayFast, an opinionated production-ready PlayFramework template that makes you productive. It bothered me for a long while that I had to make an update function for each

Integrating a log management platform with Dokploy

I spent too much time figuring out how to integrate a log management platform with Dokploy. I was looking at 3 different platforms: NewRelic, OpenObserve, and Papertrail. Eventually, I've chosen NewRelic due to the combination of UX (haha) and ease of integration. OpenObserve seems good but doesn'

Teach your child how to think

I've just finished "Teach Your Child How to Think" by Edward de Bono. It was published in 1994. I found this book while going through things at my childhood home back in Bangkok. Since my daughter was a bit over 3 years old right now, I

How to test in-app purchases on a Kotlin Multiplatform Mac app

There are 2 ways of testing an in-app purchase: (1) using a local storekit config and (2) using a sandbox testing account. Using a local StoreKit config requires an xcode project. Since a Kotlin Multiplatform Mac app doesn't generate one, we cannot use this approach. A KMP

Publishing a Java-based database tool on Mac App Store (MAS)

In the past month, I was working on publishing a Java app to Mac App Store (MAS). It's quite a journey. While Java has come so far in terms of packaging a desktop app, it also lacks in some other critical parts. Sometimes I wonder how others publish

How to debug why a Mac app crashes

The first thing I'd do is to run the app in Terminal: $ cd /Application $ ./YourApp.app/Contents/MacOS/YourApp Then, we might see some useful outputs. If we don't see anything useful, then we should utilize Console.app that comes with MacOS.