Technical write-ups on some of the harder problems I came across.
| Paper | Topic | Stack |
|---|---|---|
| RLS silently disabled my GIN index | Why a public text search 500'd for anonymous users only: @@ is not leakproof, so row security refused the index and every search became a 10s seq scan | PostgreSQL 17, RLS, GIN, tsvector, Supabase |
| Scaling streaming toolsets on Cloudflare | Designing a per-user multi-overlay platform so cost-per-user stays roughly flat as you grow — edge push, Hibernatable WebSockets, EventSub | Cloudflare Workers, KV, Durable Objects, Hibernatable WebSockets, EventSub |
| Chat bot memory | Persistent memory for a Twitch chat bot without storing raw chat logs | C#, Streamer.bot, Gemini Flash |
| Collab detection | Confidence-ranked collab detection for Twitch from several imperfect signals | Twitch Helix API, Prisma, PostgreSQL |
| How I built P.A.T.H.O.S. | Building a job-search system around deterministic scoring, constrained AI, and pipeline intelligence | React 19, Supabase, Gemini |
| Glass Box transparency | Glass Box transparency for persona state, optimizer stages, and inbound job intelligence | React 19, Supabase, Gemini |
| Email sync | Deterministic-first inbound email sync for job-search pipelines with review and undo | Supabase Edge Functions, TypeScript, LLM Fallback |
| ML prediction | Adding a learned prediction layer without replacing the deterministic scoring engine | JavaScript, Supabase, PostgreSQL |