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.
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
🎙️ 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.
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.
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.
Rails World 2024 Conference Recap
This is Part 1 of my recap of Rails World 2024, a phrenetic two-day conference in Toronto, Canada, September 2024, with 1000+ attendees.
Solid Cache for Rails and PostgreSQL
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.
Trying out Solid Queue and Mission Control with PostgreSQL
Why Solid Queue? Background jobs are commonly used in Ruby on Rails apps to perform any work possible outside of an HTTP request. A classic example is sending an email notification. Sending email from a background job places the latency...
Shrinking Big PostgreSQL tables: Copy-Swap-Drop
In this post, you’ll learn a recipe that you can use to “shrink” a large table. This is a good fit when only a portion of the data is accessed, the big table has become unwieldy, and you don’t want...
Madison+ Ruby 2024 Conference Recap
Welcome to Madison Madison+ Ruby 2024 was held August 1st & 2nd in Madison, WI, following a 5 year hiatus. Despite being in the Midwest and being a smaller regional conference, attendees came in from all over the US and...