Software design

• Deep modules, simple interfaces

Git

• Kanban
• Monorepo

Growth

• North star metric
• Retention curves

HTTP

• DNS to CDN to origin
• Thin HTTP clients

Open source projects

• Blog
• Laptop
• Webstack

Postgres

• concat_ws
• Create indexes concurrently
• Debug slow queries
• Download prod, restore dev
• Restricted Postgres access between Render and Crunchy Bridge

Ruby

• Fly.io multi-region Postgres read replicas
• Heroku dataclips clone with Sinatra
• Heroku Postgres read replicas with Rails
• Ruby script file guard
• Postgres-backed job queues with Ruby

Scripts

• Block with /etc/hosts
• Find and replace
• Kill PID on port, or by name
• SSH keys with Ed25519

Tests

• Four-phase test
• Mystery guests
• Stubs and spies

Vim

• Format SQL on file save
• Run SQL
• Run tests
• Search projects