materialized-views

CrateDB Toolkit, an SDK for CrateDB and CrateDB Cloud.

Refresh PostgreSQL materialized views in the correct order (topologically sorted)

Cloud-agnostic event-driven declarative lakehouse engine built on Apache Iceberg

Metadata-driven incremental view maintenance for Iceberg tables on Trino — bucket-aware aggregating MVs, no full rescans

Basic webapp to materialize questions in Metabase

Modular geospatial ETL pipeline for Berlin bicycle routing — extracts, enriches, and maps multi-source spatial data (elevation, weather, trees, air quality, OSM graph, etc.) into PostGIS using configurable mapping strategies (KNN, nearest-k, within-distance, intersection, attribute-join, custom SQL).

Specification and methodology for building Analysis-Ready Datasets (ARDs) — pre-computed, enriched data products that eliminate repetitive preprocessing and enable immediate analysis. Domain-agnostic framework with reference implementations.

Millisecond-fresh materialized views for Postgres via logical replication. No extensions, no triggers, no second database.

Built a MySQL DB from scratch for the purpose of serving football stat api

Production-grade analytics backend with FastAPI, PostgreSQL, Redis & Celery — handles 1M+ records with sub-2s response times via materialized views, composite indexing & cache-aside pattern

Sub-second OLAP serving over a live event stream: ClickHouse incremental materialised views keep rollups fresh at insert time — no batch job. FastAPI + chDB/server.

Este repositorio centraliza las herramientas de diagnóstico necesarias para garantizar una comunicación segura y eficiente con la instancia de ClickHouse del ecosistema Tangara, un proyecto enfocado en la red de sensores de calidad del aire en Cali.

PostgreSQL analytics system for content engagement: materialized views and composite indexes behind a FastAPI layer.