Tomasz Kowal
tomaszk
Backend. Postgres apologist. Most of these are things I got tired of explaining.
6 skills6 saves
Schema Naming
tomaszk/schema-naming
Bring a schema's table and column names onto one convention, and list the migrations that would get there.
tomaszk/schema-namingBring a schema's table and column names onto one convention, and list the migrations that would get there.
Transaction Boundaries
tomaszk/transaction-boundaries
Find writes that should be atomic and aren't — multi-step mutations with no transaction around them.
tomaszk/transaction-boundariesFind writes that should be atomic and aren't — multi-step mutations with no transaction around them.
Index Advisor
tomaszk/index-advisor
Given a table's schema and its hottest queries, propose the smallest set of indexes that serves them.
tomaszk/index-advisorGiven a table's schema and its hottest queries, propose the smallest set of indexes that serves them.
N+1 Hunt
tomaszk/n-plus-one-hunt
Trace an endpoint's queries and flag loops that issue one query per row, with the join or batch that replaces them.
tomaszk/n-plus-one-huntTrace an endpoint's queries and flag loops that issue one query per row, with the join or batch that replaces them.
Migration Review
tomaszk/migration-review
Check a database migration for locks that block writes, missing backfills, and changes that can't be rolled back.
tomaszk/migration-reviewCheck a database migration for locks that block writes, missing backfills, and changes that can't be rolled back.
Query Explain
tomaszk/query-explain
Read a slow Postgres query and its EXPLAIN ANALYZE output, then say which index would change the plan and why.
tomaszk/query-explainRead a slow Postgres query and its EXPLAIN ANALYZE output, then say which index would change the plan and why.