Blog
Browse through our blog page filled with updated information and the latest tips to help you achieve your goals.

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