Rails 7.1: How Ruby on Rails Developers Can Use the .with Query Method for CTEs
Rails 7.1 added the .with query method, bringing Common Table Expressions into Active Record. How CTEs work, and when they make a query clearer.
Blog
Database
9 posts tagged database — the same founder-tested patterns, filtered.
Turbocharge Your Rails Apps with Smart Database Indexing
Is your Rails application running slow? Are search queries taking forever to complete? The solution might be simpler than you think.
Efficient Percentile Ranking in PostgreSQL
When analyzing data, percentiles help us understand the relative ranking of records within a dataset.
Understanding Optimistic and Pessimistic Locking in Ruby on Rails
When several people touch a database simultaneously, software conflicts can occur when more than one user tries to update the same record.
Linking Data in PostgreSQL Without Explicit Keys: A Practical Guide
Databases often evolve in unpredictable ways. Tables that were initially designed to operate independently might later need to be connected.
Upgrading PostgreSQL on Heroku: A Step-by-Step Guide
Are you looking to upgrade your PostgreSQL database on Heroku?
How a large transaction can be a source of DB deadlocks and how this can be fixed.
Recently in a project, we encountered the fact that sometimes we had a DB Deadlocks error.
Data migrations with Rails
Data migration is a common part of working with databases, and Ruby on Rails developers have many tools at their disposal.
What is the difference between joins and includes in Rails ActiveRecord?
The main difference is that when using includes the eager loading is used.
Reading this because something is going wrong?
A free code audit gives you a written assessment of your codebase in plain English.
Get a Free Code AuditRated 4.8/5 on Clutch · you keep the write-up either way