PIGSTY

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

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

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

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, 420+ 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

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

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

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

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

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