Andrew Atkinson

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

Intro Back in 2022, we covered how to log database query generation information from a web app using pg_stat_statements for Postgres. https://andyatkinson.com/blog/2022/10/07/pgsqlphriday-2-truths-lie

Ruby on Rails Ruby PostgreSQL

Back in November, I met with Claire Giordano, host of the Talking Postgres podcast, who asked a ton of great questions about my experience writing a Postgres book aimed at Ruby on Rails web developers.

Podcasts PostgreSQL Ruby on Rails

About 10 years ago I wrote a post PostgreSQL for the Busy MySQL Developer, as part of switching from MySQL to Postgres for my personal and professional projects wherever I could.

Python Django PostgreSQL

It’s time for a new Postgres release! PostgreSQL 17 shipped a few weeks ago, with lots of new features to explore.

PostgreSQL

This is Part 1 of my recap of Rails World 2024, a phrenetic two-day conference in Toronto, Canada, September 2024, with 1000+ attendees.

Ruby on Rails Ruby PostgreSQL Conferences

Solid Cache is a relatively new cache framework that’s available as a Ruby gem for Ruby on Rails. In the next major version of Rails, version 8, it’s becoming the default cache backend.

PostgreSQL Ruby on Rails