Bookmarks (10) clear filters

How to Fix Postgres Performance Issues with PG Extras — An introduction to a tool you can use to spot Postgres related issues in Ruby (and Rails), Elixir and Node.js contexts.

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.

Getting Started with AWS S3 IAM Policies Security Config for Rails Apps — The joy of getting S3 bucket access and permissions often leads to incorrect and insecure configurations. Is yours configured properly?

How to Store Secure Encrypted Data in Rails Without Gems — It doesn’t take much code to add encryption to your models and data, allowing you to avoid LOC-heavy gems.

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.)