February 11, 2023

ActiveRecord: finally understand transactions

Database transactions are an essential tool to master. Because ActiveRecord's transactions behavior is not intuitive (especially when it comes to nested transactions), this article explains how to use them and what pitfalls you should pay attention to.

Read more
June 14, 2022

How to write a recursive SQL query

Let's see how to write a recursive SQL query with PostgreSQL's CTE (Common Table Expressions) and ActiveRecord

Read more
November 19, 2021

ActiveRecord: finally understand joins and left_outer_joins

If you never really understood how joins work, or if you're somewhat familiar with .joins but hardly grasp what .left_outer_joins does, this is the blog post you need.

Read more