Skip to content
#

materialized-views

Star

Here are 3 public repositories matching this topic...

Language: PLpgSQL
Filter by language
All 29 Python 6 PLpgSQL 3 Rust 3 C# 2 HTML 2 Java 2 JavaScript 2 Ruby 2 Go 1 PHP 1

KonNik88 / sql-analytics-books

Star 1

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

FirdevsTorlak / kb-qa-analytics

Star 0

Dies ist ein kleines, aber leistungsfähiges Demo-Projekt für Knowledge Management (KM) und Analytics mit PostgreSQL. Es beinhaltet komplexe SQL-Abfragen, Performance-Optimierung (Indizes und EXPLAIN ANALYZE) und Docker-Unterstützung für eine schnelle Bereitstellung. Ideal für Interview-Demos oder CI/CD-Tests.

docker performance sql analytics docker-compose postgresql ci-cd database-management full-text-search pgadmin knowledge-management pg-stat-statements materialized-views
  • Updated Nov 4, 2025
  • PLpgSQL

Improve this page

Add a description, image, and links to the materialized-views topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the materialized-views topic, visit your repo's landing page and select "manage topics."

Learn more