Blogs

Articles and notes on full-stack development, database architecture, and applied AI.

Architecting a High-Performance PSGC REST API & Next.js Explorer for 42,000+ Barangays
Next.jsTypeScriptREST API+2

Architecting a High-Performance PSGC REST API & Next.js Explorer for 42,000+ Barangays

How I designed a verified, staged quarterly data pipeline and interactive explorer for the Philippine Standard Geographic Code (PSA PSGC).

Schema Atlas: Building a Local-First Database Architecture Studio
DatabasePrismaPostgreSQL+2

Schema Atlas: Building a Local-First Database Architecture Studio

Deep dive into designing an interactive ERD canvas with Dagre auto-layout, bi-directional Prisma schema parsing, and SQL DDL synchronization.

CourtScribe AI: Engineering Resilient Live Transcription for Court Hearings
Applied AIPWAWeb Speech API+2

CourtScribe AI: Engineering Resilient Live Transcription for Court Hearings

Developing a crash-resilient audio ingestion pipeline with 5-second IndexedDB checkpoints, bilingual recognition, and judicial role tagging.