Bookmarks (7) clear filters

How to Improve ActiveRecord Performance with Subquery Caching — It’s a bit of a process: Analyze slow queries, isolate subqueries into memoized methods, cache one or more of the subqueries. Oh, and refresh the cache when necessary.

Postgres Indexes for ActiveRecord Join Tables in Rails Apps — Don’t count on the built-in helpers (i.e. create_join_table) to create the correct indexes. If you do, there’s a non-zero chance that you have unused indexes in your database.

Rails Mistakes That Could Break Your Production Servers — Most of these are around issues with the database. I can attest to exhausting the database pool, which made for a baaaad weekend.

How to Perform Concurrent HTTP Requests in Ruby and Rails — Ah, concurrency and Ruby. Will it ever be safe and easy? We can hope, but in the meantime here’s why it’s unsafe and an easy way to enjoy concurency safely.

Using UUIDs in Rails 6 with Postgres and ActiveRecord — UUIDs (which look like long strings of hexadecimal numbers) are an alternative primary key type for databases with pros and cons over standard, ordered integer-based keys. Rails 6 can work with UUID keys pretty well and here’s a quick tour.

A Way to Validate and Fix Active Record Data Integrity — Thoughts on an approach to take if your data gets into an ‘invalid’ state (via arbitrary updates, skipping validations, broken dependencies, etc.)