Data Engineering with dbt – first steps using PostgreSQL and Oracle
dbt is a Data Engineering tool supporting version control with CI/CD for transformations and...
Read More
Category: PostgreSQL
PostgreSQL application_name
PostgreSQL application_name can be set in the connection string. The view pg_stat_activity will...
Read More
PostgreSQL columnar extension cstore_fdw
PostgreSQL columnar extension cstore_fdw is a storage extension which is suited for...
Read More
PostgreSQL partitioning guide
PostgreSQL partitioning is a powerful feature when dealing with huge tables. Partitioning allows...
Read More
Log-based Change Data Capture - lessons learnt
My article on medium summarizes experiences from various projects with log-based change data...
Read MoreDataBeat week 06/2015
Reference to blogs, tweets, discussions, etc that caught my attention during the last week. Data Modeling “Data Modeler Of 2020” YouTube video by Steve Hoberman addresses topics like modeling for NoSQL or BigData,...
Read More