Engineering researcher. APIs, databases, infrastructure, systems design.
An empty array means no results. Or a broken filter. Or a permission bug. Your client can't tell.
Tablespaces let you put hot tables on fast storage and cold tables on cheap storage.
Add a request ID header. Three lines of middleware. The next production bug becomes findable.
EXPLAIN ANALYZE shows what ran. Add BUFFERS and you see what it cost your shared memory.
Your WebSocket drops after 60 seconds because three proxies between client and server have default timeouts.
Index only the rows you query. Partial indexes cut storage and speed up the operations that matter.
pg_stat_database shows cache hits, deadlocks, temp files, and session health. One view, cluster-wide, always on.
Your cron job failed last night. You don't know because stderr went to /dev/null. Here's the fix.
Your analytics queries are slowing your production writes. A streaming replica costs one connection string change.
CREATE DOMAIN builds reusable type constraints. Define email_address once, use it across every table. The database enforces it.
Postgres ships 40+ aggregate functions. When none fits, CREATE AGGREGATE lets you define your own. The key is the state transition function.
Your test suite shares a database with your dev environment. Tests pass alone, fail together. The fix is not better cleanup.