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
dockerperformancesqletlanalyticsdmlpostgresqlindexingdata-warehousefull-text-searchjsonbdata-modelingpgtapdata-martmaterialized-viewsstar-schemawindow-functionsgrouping-setspgtrgm
-
Updated
Oct 6, 2025 - PLpgSQL