Skip to content

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

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

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

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.

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

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