Tag: #psql

Jul 12, 2022

#psql #performance

Building complex reports for your own DVD rental shop using PostgreSQL window functions

How to use window functions in PostgreSQL: rank, dense_rank, row_number, sum and lag

Aug 18, 2021

#psql #rails #ruby

One row, many threads: How to avoid database duplicates in Rails applications

Nov 19, 2019

#psql #rails #ruby #performance

Pulling the trigger: How to update counter caches in your Rails app without Active Record callbacks