Igor Dobryn
about IT

PostgreSQL - transpose columns into rows

Published over 1 year ago 3 minutes read
Very simple approach to transpose columns into rows using PostgreSQL
PostgreSQL SQL

Node.js stream to read data from API

Published over 1 year ago 3 minutes read
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
Node.js streams API

Arel::Nodes::ValuesList to build a value table

Published over 1 year ago 3 minutes read
This article describes several cases when the value list becomes particularly useful to either build a value table or for performance improvements
Rails ActiveRecord Arel value table SQL

ActiveRecord::Base#find_by_sql to wrap results of composite INSERT query

Published over 1 year ago 2 minutes read
A little trick describing how ActiveRecord::Base#find_by_sql can be used to return records from complex INSERT query in PostgreSQL.
find_by_sql Rails ActiveRecord PostgreSQL

Google Sheets to find the closest location

Published over 1 year ago 8 minutes read
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.
Google Sheets Google Maps API Javascript Location Search

Count multiple columns in PostgreSQL

Published over 1 year ago 6 minutes read
Comparison of several approaches to COUNT multiple columns in PostgreSQL
Performance optimization COUNT Query analysis PostgreSQL

ITerm2 script to start processes

Published over 1 year ago 2 minutes read
Start your microserviced project with one click using ITerm2 scripting
ITerm2 Python Scripting

FactoryBot for CSV file fixtures

Published over 1 year ago 2 minutes read
Approach describing how FactoryBot factories can be easily used for generating CSV file fixtures on the fly
FactoryBot CSV file fixture