OLAP cubes in budgeting: server analysis https://sudonull.com/olap-cubes-in-budgeting-server-analysis
Learn how OLAP cubes transform financial planning: from Excel to multidimensional scenarios and rolling forecasts. For CFOs and analysts — step-by-step breakdown of benefits and implementation.
DuckDB as storage: replacing ETL Postgres https://sudonull.com/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.
PostgreSQL Tuning: AI vs Load Tests https://sudonull.com/postgresql-tuning-ai-vs-load-tests
Comparison of AI Recommendations and Real PostgreSQL Benchmarks. Learn how OLTP and OLAP configs affect performance and why tests are more important than theory.
ClickHouse: why columnar DBMS accelerate analytics by 100 times https://sudonull.com/clickhouse-why-columnar-dbms-accelerate-analytics-by-100-times
We explain using real benchmarks and a betting scheme: ClickHouse vs PostgreSQL and MySQL. Architecture, query examples, use cases. Read 5 minutes.
ClickHouse with Airflow instead of PostgreSQL for Big Data https://sudonull.com/clickhouse-with-airflow-instead-of-postgresql-for-big-data
Learn why Airflow + ClickHouse is displacing PostgreSQL in analytics. Performance comparison, examples for data engineers. Switch to columnar DB for ETL pipelines.