https://andyatkinson.com

Home | Software Engineer, Author, High Performance PostgreSQL for RailsSoftware Engineer, Author, ConsultantHome | Software Engineer, Author, High Performance PostgreSQL for Rails Andrew Atkinson Software Engineer, Author, Consultant Main Menu Home About Consulting Book Speaking Writing Ruby on Rails PostgreSQL Extra Archive Contact Me Latest Articles September 25, 2025 What are SLRUs and MultiXacts in Postgres? What can go wrong? In this post we’ll cover two types of Postgres internals. PostgreSQL Databases July 2, 2025 Avoid UUID Version 4 Primary Keys (for Postgres) 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 June 9, 2025 CORE Database Schema Design: Constraint-driven, Optimized, Responsive, and Efficient Introduction In this post, we’ll cover some database design principles and package them up into a catchy mnemonic acronym. PostgreSQL Databases May 29, 2025 Tip: Put your Rails app on a SQL query diet 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 May 23, 2025 Big Problems From Big IN lists with Ruby on Rails and 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 May 20, 2025 Short alphanumeric pseudo random identifiers in Postgres Introduction In this post, we’ll cover a way to generate short, alphanumeric, pseudo random identifiers using native Postgres tactics. PostgreSQL April 29, 2025 Source code locations for database queries in Rails with Marginalia and Query Logs 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 April 7, 2025 🎙️ Talking Postgres Podcast: Helping Rails developers learn Postgres with Andrew Atkinson 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 December 10, 2024 Django and Postgres for the Busy Rails Developer 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 October 17, 2024 PostgreSQL 17: JSON_TABLE(), MERGE with RETURNING, and Updatable Views It’s time for a new Postgres release! PostgreSQL 17 shipped a few weeks ago, with lots of new features to explore. PostgreSQL Page 1 of 16 Older Posts Andrew Atkinson © 2006-2026. Back to topenen1774434601https://andyatkinson.com

Hlela isayithi yakho?

Wentani?