freddie@bkk ~/layaungphyo.dev~ $ whoami
La Yaung Phyo · backend & systems engineer · Bangkok, TH
freddie@bkk ~/layaungphyo.dev~ $ cat about.txt
I build backend systems that stay calm under load: no double bookings, no missed alerts, no guessed indexes. Computer science student at KMUTT. Mostly Go and Postgres, on Linux, from a terminal.
freddie@bkk ~/layaungphyo.dev~ $
freddie@bkk ~/layaungphyo.dev~ $ ls projects/ --long
## selected work
5 items · 2026
01 floodwatch/
River and rain alerts for Bangkok, on Telegram. go · postgres · telegram live
A Telegram bot that watches Bangkok’s river and rain gauges near you, in Thai and English. It fits tidal gauges to the harbour tide and forecasts the next six hours.
tags: go postgres sqlc telegram gh-actions
→ github.com/FreddieTheObserver/floodwatch
↵ toggle ↑↓ next esc close
02 cinebook/
Cinema booking where a seat can only sell once. go · postgres in progress
A cinema booking service where two people can never get the same seat. Postgres is the arbiter: an advisory lock per showtime, a hold with a TTL, then confirm.
tags: go postgres testcontainers
↵ toggle ↑↓ next esc close
03 indexproof/
An index advisor that doesn’t trust its own LLM. python · postgres · llm in progress
An index advisor that doesn’t trust its own LLM. Each proposed index is built and measured in an isolated Postgres, and the rejections are the headline.
tags: python postgres llm
↵ toggle ↑↓ next esc close
04 sakha/
An offline-first POS for multi-branch shops in Thailand. offline-first · th/en design
An offline-first POS for multi-branch shops in Thailand. Runs on devices they already own and keeps trading through a full day offline.
tags: offline-first th/en multi-tenant
↵ toggle ↑↓ next esc close
05 sgoauth/
Sign in with Google, hardened. next.js · nestjs · postgres study
Sign in with Google, hardened.
Opaque database sessions in __Host- cookies, explicit ID-token checks, RBAC and an audit log.
tags: next.js nestjs postgres
→ github.com/FreddieTheObserver/sgoauth
↵ toggle ↑↓ next esc close
freddie@bkk ~/layaungphyo.dev~ $ neofetch
## about
bangkok, th
freddie@bkk
- name
- La Yaung Phyo (Freddie)
- role
- backend & systems engineer
- study
- computer science, KMUTT
- based
- bangkok, th
- os
- ubuntu on wsl2
- term
- wezterm + tmux
- editor
- neovim
- langs
- go · postgres · python · typescript
- tools
- docker · gh-actions · nestjs · next.js
freddie@bkk ~/layaungphyo.dev~ $ cat principles.md
I’m drawn to systems with a rule that must never break, and I like proving those rules hold.
-
[1] principle
measure, don’t guess
A confident suggestion is not a result. IndexProof builds every index an LLM proposes and keeps only the ones that measurably win.
-
[2] principle
let the database hold the line
Locks and constraints beat careful application code. In CineBook, a partial unique index is the last defense against double booking.
-
[3] principle
fail loudly, recover quietly
Watchdogs, health checks and honest messages. When floodwatch goes down, a heartbeat alarm fires and subscribers hear about the gap.
freddie@bkk ~/layaungphyo.dev~ $ git log --graph --oneline -4
## now
updated 2026-10-08
-
design the domain model for Sakha
oct 2026 -
curate practice sets for CSC102 juniors as a CS mentor
sep 2026 -
send my first open-source PR: setup docs for unishare
sep 2026 -
keep floodwatch running through the Bangkok floods
sep 2026
freddie@bkk ~/layaungphyo.dev~ $ ./contact.sh
let’s build something
dependable.
- linkedin.com/in/…
- resume
- freddie-resume.pdf