Blog
Browse through our blog page filled with updated information and the latest tips to help you achieve your goals.
Rails 7.1: How Ruby on Rails Developers Can Use the .with Query Method for CTEs
For Ruby on Rails developers looking to level up their database query skills, Rails 7.1 introduced a...
Turbocharge Your Rails Apps with Smart Database Indexing
Is your Rails application running slow? Are search queries taking forever to complete? The solution...
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...
Linking Data in PostgreSQL Without Explicit Keys: A Practical Guide
Databases often evolve in unpredictable ways. Tables that were initially designed to operate...
Upgrading PostgreSQL on Heroku: A Step-by-Step Guide
Are you looking to upgrade your PostgreSQL database on Heroku? Whether it's for performance...
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. After...
Data migrations with Rails
Data migration is a common part of working with databases, and Ruby on Rails developers have many...
What is the difference between joins and includes in Rails ActiveRecord?
The main difference is that when using includes the eager loading is used. Eager loading allows you...