Andrew Atkinson

What are SLRUs and Multixacts in Postgres? What can go wrong?

Avoid UUID Version 4 Primary Keys

CORE Database Schema Design: Constraint-driven, Optimized, Responsive, and Efficient

Tip: Put your Rails app on a SQL query diet

Big Problems From Big IN lists with Ruby on Rails and PostgreSQL

Short alphanumeric pseudo random identifiers in Postgres

Source code locations for database queries in Rails with Marginalia and Query Logs

🎙️ Talking Postgres Podcast: Helping Rails developers learn Postgres with Andrew Atkinson

Django and Postgres for the Busy Rails Developer

PostgreSQL 17: JSON_TABLE(), MERGE with RETURNING, and Updatable Views