PostgreSQL - transpose columns into rows
Very simple approach to transpose columns into rows using PostgreSQL
Node.js stream to read data from API
In the worlds of APIs and big data. Solutions that can handle huge data with a minimum of resources are valuable. This article demonstrates Node.js readable stream to read data from an API
Arel::Nodes::ValuesList to build a value table
This article describes several cases when the value list becomes particularly useful to either build a value table or for performance improvements
ActiveRecord::Base#find_by_sql to wrap results of composite INSERT query
A little trick describing how ActiveRecord::Base#find_by_sql can be used to return records from complex INSERT query in PostgreSQL.
Google Sheets to find the closest location
This article describes how to find the closest walking, driving or traveling by public transport location using a few sheets and a little bit of code.
Count multiple columns in PostgreSQL
Comparison of several approaches to COUNT multiple columns in PostgreSQL
ITerm2 script to start processes
Start your microserviced project with one click using ITerm2 scripting
FactoryBot for CSV file fixtures
Approach describing how FactoryBot factories can be easily used for generating CSV file fixtures on the fly