ActiveRecord Internals: You are still not readyThis is part 2 of a series of articles I have begun recently. I try to understand better Rails ActiveRecord and how this is designed internally. In the last article, we discussed reflection but did not dive into it. Now we still have some black spell...Aug 29, 2023·4 min read
Postgres Concurrency: What could go wrong (part 2)One month and everything is fine... unless? After your last misadventure with Bob, you learn to be careful with Isolation in your transaction. Times flies, and you have been in charge of several small reports. And now you are in order of a much more ...May 22, 2023·3 min read
Postgres concurrency what could go wrong (part 1)A brand new job Imagine you are a brand new Data Analyst at The Coffee Company. Like every Data Analyst, you know SQL well and are in charge of writing new queries to understand the business better. You want to discover the database and decides to wr...May 18, 2023·5 min read
Pivot Table in PostgreSQLIntroduction Today we are going to see a really important concept when working with data and how you represent data. We are going to talk about Pivot Table indeed representing data in columns instead of rows is often more readable. Example Let's say ...May 15, 2023·4 min read
SQL indexes Basics: HowTo with railsIntroduction Indexes are something that you have most probably heard of and use in your app if you use a relational database in it. In this article, I will dive into the basic of indexes in SQL, and how we can create one index on data on our database...Apr 3, 2023·5 min read
Reversing DidYouMean GemIntroduction Let's dive into ruby! There is a really useful gem that we do not notice but is kind of the savior for us developers. There is no suspense by the title it is obvious I talk about the DidYouMean gem which is now shipped into ruby directly...Mar 29, 2023·5 min read
Python and Polars an IntroductionIntroduction Sometimes you reach a point where you connect dots between different things. Indeed I am currently digging into SQL, and for each new concept that I learned I tried to illustrate it with a ruby project. Here is the thing, I love ruby it ...Mar 20, 2023·4 min read