Andrew Atkinson

Let's see how switching to PostgreSQL 18’s native UUIDv7 time-ordered UUIDs affected locality and performance compared with v1 and v4 primary key values.

PostgreSQL Databases

How Aura Frames refactored Active Record code in Ruby on Rails, splitting from one primary database to eight, handling 41 million requests per hour and reaching #1 in the App Store.

Ruby on Rails Ruby PostgreSQL Performance

How Aura Frames scaled Postgres from one primary database to eight, sustaining more than 100K TPS through Christmas Day and reaching #1 in the App Store.

PostgreSQL Databases SQL Performance

The Postgres community releases Beta versions, and with Docker it’s been easier than ever to configure pre-release versions to use and test.

PostgreSQL Databases

In this post we’ll cover two types of Postgres internals.

PostgreSQL Databases

Introduction Over the last decade, when working on databases with UUID Version 41 as the primary key data type, these databases have usually had bad performance and excessive IO. https://datatracker.ietf.org/doc/html/rfc4122#section-4.4 ↩

PostgreSQL Databases Ruby on Rails

Introduction In this post, we’ll cover some database design principles and package them up into a catchy mnemonic acronym.

PostgreSQL Databases

Introduction Much of the time taken processing HTTP requests in web apps is SQL queries. To minimize that, we want to avoid unnecessary and duplicate queries, and generally perform as few queries as possible.

Ruby on Rails PostgreSQL

Introduction If you’ve created web apps with relational databases and ORMs like Active Record (part of Ruby on Rails), you’ve probably experienced database performance problems after a certain size of data and query volume.

PostgreSQL Ruby on Rails

Introduction In this post, we’ll cover a way to generate short, alphanumeric, pseudo random identifiers using native Postgres tactics.

PostgreSQL