4 pages tagged across the site.
In the TTS Study Assistant notes table, queries filter by user_id always and domain often, so the index is declared in that order: CREATE INDEX idx_uid_did ON notes(user_id, domain); A composite index is only fully useful as a left-prefix: this index serves WHERE user_id = ? and WHERE user_id = ? AND domain = ?, but not WHERE domain = ? alone. The rule of thumb is to order columns by how the queries actually filter — most selective / most-always-present first — not by declaration order in the table, and not alphabetically.
A self-hosted URL shortener with a React admin panel, built with Go, Redis, and PostgreSQL.
A Chrome extension for saving, organizing, and listening to notes from any webpage, backed by a Go/Fiber API and a React admin panel.
Led backend architecture for a multi-tenant B2B carbon-accounting SaaS — schema, APIs, and a Scope 1/2/3 emissions engine.