Andrew Atkinson

I’m happy to share that I was a guest on the Rails Business podcast and the episode is now live.

📌 Overview We recently switched to version 7 (v7) uuid primary keys and saw significantly faster inserts for some tables.

In this post we’ll look at a recipe for adding and removing big indexes on big tables.

📌 Overview On Christmas Day 2024, Postgres infrastructure powering the Aura Frames API had problems under peak load, being unavailable for three hours and disrupting the experience for new customers.

📌 Overview Ruby on Rails has helped make it possible to scale out the database layer, meeting the demands of millions of Aura Frames customers enjoying their digital photo frames.

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

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

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.

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

Introduction Much of the time taken processing HTTP requests in web apps is SQL queries.

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.