# Composable Modules

> Flexible Lego-Blocks
---

> Swift as the wind, simplifying complexity, riding the currents of change with freedom and ease!


**Modular Design**


        Lego-like Assembly



**App Templates**


        One-Click Enterprise Deployment



**Core Modules**


        Fully-Featured Postgres RDS



**Extra Modules**


        Extending RDS Capabilities



**Kernel Modules**


        Swappable Database Engines



**OLAP Modules**


        Powerful Analytics Capabilities



**Pilot Modules**


        Exploring Cutting-Edge Frontiers



**Flavor Modules**


        Creative Postgres Flavors





--------

## Modular Design: Lego-like Assembly {#modular-design}

> Modular design, freely combine components like Lego blocks\
> Declarative configuration for customizing infrastructure and database environments

- Ready-to-use high availability clusters (PGSQL + ETCD)
- Centralized backup with unlimited storage (MINIO + PGSQL)
- Independent database monitoring (INFRA + NODE)
- Website hosting and data visualization (INFRA + PGSQL)

--------

## App Templates: One-Click Enterprise Deployment {#app-templates}

> Optional Docker module with Compose templates\
> Stateless containers that can be destroyed, with state persisted in external HA PGSQL

- Enterprise apps: GitLab, Odoo, Dify
- Higher-level databases: Supabase, Neon, EdgeDB
- Database Admin tools: PGAdmin, Bytebase, PGWEB

--------

## Core Modules: Fully-Featured Postgres RDS {#core-modules}

> 4 core modules working together to build a complete PostgreSQL RDS\
> Scalable, flexible combinations with no additional dependencies

- PGSQL: PG clusters with HA, PITR, IaC, monitoring, 437 extensions
- INFRA: Nginx, local repos, Prometheus & Grafana Stack, DNS, NTP
- NODE: Node management, repo, packages, VIP, logging, NTP
- ETCD: Distributed config storage for PG high availability

--------

## Extra Modules: Extending RDS Capabilities {#extra-modules}

> Components that work exceptionally well with PostgreSQL\
> Completely optional, install as needed

- MINIO: S3-compatible object storage, optional PG backup repo
- REDIS: High-performance dict server in various modes
- FERRET: MongoDB wire-protocol compatibility for PostgreSQL

--------

## Kernel Modules: Swappable Database Engines {#kernel-modules}

> Optional replacements for vanilla PostgreSQL kernel\
> Offering different database compatibility

- Babelfish: Microsoft SQL Server wire-compatible PG from AWS
- IvorySQL: Oracle-compatible PostgreSQL 17 kernel from HighGo
- OpenHalo: MySQL wire-compatible PG kernel by HaloTech
- OrioleDB: New storage engine without xid wraparound and table bloat

--------

## OLAP Modules: Powerful Analytics Capabilities {#olap-modules}

> DuckDB integration showcase\
> Installation and monitoring support for Greenplum derivatives

- CITUS: Native distributed HTAP extension for PostgreSQL
- DUCKDB: Embedded OLAP kernel with 5 PG extensions
- GREENPLUM: MPP data warehouse (PG 12) with EL monitoring
- CLOUDBERRY: PG 14 compatible version from original GPSQL team

--------

## Pilot Modules: Exploring Cutting-Edge Frontiers {#pilot-modules}

> Unrelated to PostgreSQL\
> Experimental capability explorations

- KUBE: Kubernetes setup with SealOS, deployment support
- KAFKA: Message queue powered by KRaft
- MYSQL: Single-node MySQL 8.0 support
- VICTORIA: Infrastructure alternative for metrics & logs

--------

## Flavor Modules: Creative Postgres Flavors {#flavor-modules}

> Diverse wrappers and features on native PostgreSQL\
> Exploring Backend-as-a-Service, serverless, and in-database web development

- SUPA: Firebase open-source alternative
- NEON: Serverless PostgreSQL with database branching
- EDGE: PostgreSQL with powerful query language
- OMNI: PostgreSQL with extensions for specific use cases