Star-schema data mart on PostgreSQL built from Goodbooks CSVs. Demonstrates advanced SQL (window functions, JSONB, GROUPING SETS), indexes (covering/partial/GIN/pg_trgm), materialized views, incremental MERGE loads, pgTAP tests, and GitHub Actions CI. Includes Docker quickstart and SSH-tunnel instructions
docker performance sql etl analytics dml postgresql indexing data-warehouse full-text-search jsonb data-modeling pgtap data-mart materialized-views star-schema window-functions grouping-sets pgtrgm
- Updated
Oct 6, 2025 - PLpgSQL