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.