Oct 19, 2018
Several non-trivial tasks about SQL, logic and algorithms with short and beautiful solutions obtained during technical interviews.
SQL interesting tasks algorithms interview tasks logic
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.
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
Aug 28, 2016
Quite detailed description of different approach to working with MS Access within Unix with using Ruby (Rails), PostgreSQL and system utilities.
MS Access PostgreSQL Ruby on Rails Foreign data wrapper pgsql RoR Ruby mdb csv FDW GDAL OGR ODBC Ubuntu