Understanding Tricky Joins and Multi-Table Updates in PostgreSQL (Using Boolean Algebra!)

Writing a proper SQL UPDATE query involving multiple tables in Postgres can be tricky and counterintuitive. This stems from the fact that when performing an UPDATE, other tables…

How we used Postgres extended statistics to achieve a 3000x speedup

Persisting sessions with React Native

A few weeks ago, we ran into a particularly tricky bug: some users told us that our mobile app was logging them out every time they closed the app. This blog post explains the underlying issue as well as how we resolved it. If you’re running into issues managing…

Early Experiences with Kubernetes: Debugging Unresponsive Nodes

Sharing code between web & React Native: Why & how to configure Metro for code sharing

Building a highly responsive sheet view with React Native

Migrating Large PostgreSQL Columns to DynamoDB

UPDATE (over a ~year later): Looking back at this project it was worthwhile for…

Designing Engineer Onboarding at Affinity

This summer, our team added four new engineers, growing our existing engineering team…

Learn Fast and Read Things: why (and how) we started a technical reading group