Very simple approach to transpose columns into rows using PostgreSQL

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

This article describes several cases when the value list becomes particularly useful to either build a value table or for performance improvements

A little trick describing how ActiveRecord::Base#find_by_sql can be used to return records from complex INSERT query in PostgreSQL.

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.

Comparison of several approaches to COUNT multiple columns in PostgreSQL

Start your microserviced project with one click using ITerm2 scripting

Approach describing how FactoryBot factories can be easily used for generating CSV file fixtures on the fly