tanin

Sign in Subscribe

Latest — Sep 14, 2026

A simple way to identify slow Postgres SQLs

I've just learned probably the simplest way to identify slow Postgres queries in your application. Postgres has the built-in extension named pg_stat_statements that tracks the executed SQLs, their execution times, and other things. First of all, you can enable the extension with: CREATE EXTENSION pg_

More issues

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.

ClickHouse with PlayFramework, Slick, and Evolutions

I wanted to show you how to add another database in PlayFramework that uses Slick and Evolutions. That database is ClickHouse, which also requires a little bit of special handling. In the end, it works out quite cleanly. I'll later integrate it into PlayFast, an opinionated production-ready