System Design
PostgreSQL User Creation and Permission Setup
Jason Yang · 16 Dec, 2025
Secure PostgreSQL by separating admin and app roles: SQL scripts for schema hardening and automated permissions, for Cloud SQL, AWS RDS, or self-hosted.
Blog posts — page 16
Cloud & DevOps
Stop Using key.json: How to Configure GCP Service Account Impersonation
Jason Yang · 07 Dec, 2025
GCP Service Account Impersonation lets your MFA-authenticated account borrow a service account's permissions with short-lived tokens instead of risky key.json files. Here's the 3-step setup.
AI & LLM
Stop Claude Code from Killing Your Ubuntu Session — The Swap Setup I Wish I Had Sooner
Jason Yang · 06 Dec, 2025
Ubuntu desktop crashing under heavy dev workloads? You're likely hitting the OOM killer. The exact swap and swappiness setup that stops the crashes.
Linux
ripgrep (rg): The Fastest Way to Search Your Code
Jason Yang · 05 Dec, 2025
Still using grep? Meet ripgrep (rg), the ultra-fast Rust search tool that respects .gitignore by default and searches your codebase in seconds.
Linux
Ubuntu Clamshell Mode: Use a Closed Laptop With an External Monitor
Jason Yang · 05 Dec, 2025
Run an Ubuntu laptop in clamshell mode — lid closed on an external monitor — while it still sleeps normally in your bag. The conditional HandleLidSwitchDocked fix, plus the display and input setup.