Articles by tag: data-warehouse

Database Architecture for Parsing Tariffs on PostgreSQL

Study the star schema for storing internet and TV tariffs: fact tables, dimensions, historicity triggers, indexes. Full SQL code for middle/senior developers. Implement provider monitoring without data loss.

DuckDB as storage: replacing ETL Postgres

Learn how DuckDB replaces ETL + Postgres with one file for OLAP. Code examples, SLA, migration. Simplify analytics without infrastructure — read the guide for developers.