Interesting tasks from technical interviews

Oct 19, 2018

Several non-trivial tasks about SQL, logic and algorithms with short and beautiful solutions obtained during technical interviews.

Continue reading →

SQL interesting tasks algorithms interview tasks logic


Details about MSSQL FDW and query speedup ways

Oct 07, 2016

Detailed description of access to MSSQL through TDS FDW for PostgreSQL: differences between major versions, compatibility issues, approach to a query optimization and an exotic way of access to MSSQL.

Continue reading →

PostgreSQL FDW Foreign data wrapper pgsql MSSQL tds_fdw materialized view Ruby on Rails dblink-tds dbi-link freetds Microsoft SQL Server Ubuntu ActiveRecord pushdown


How to work with MS Access under Unix

Aug 28, 2016

Quite detailed description of different approach to working with MS Access within Unix with using Ruby (Rails), PostgreSQL and system utilities.

Continue reading →

MS Access PostgreSQL Ruby on Rails Foreign data wrapper pgsql RoR Ruby mdb csv FDW GDAL OGR ODBC Ubuntu