Younes SERRAJ

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.

How to write a recursive SQL query

SQL PostgreSQL CTE ActiveRecord

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

ActiveRecord: finally understand joins and left_outer_joins

Rails ActiveRecord SQL Cheatsheet

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.