Applications

Application templates and data applets: run stateless apps with Docker Compose and host state in external PostgreSQL and MinIO.

In Pigsty , “applications” fall into two categories:

  • Software Templates: Docker Compose templates under ~/pigsty/app/<name> for stateless business components.
  • Data Applets: PostgreSQL + Grafana analytics demos, mainly for learning and showcase use.

Model

The recommended app install workflow is:

curl -fsSL https://repo.pigsty.io/get | bash; cd ~/pigsty
./configure -c <template>     # e.g. app/dify, app/odoo, app/registry, supabase
vi pigsty.yml                 # edit passwords, domains, IPs, and secrets
./deploy.yml                  # deploy infrastructure and databases
./docker.yml                  # install Docker
./app.yml                     # launch applications

app.yml copies app/<name> templates to /opt/<name>, overwrites .env with apps.<name>.conf, then runs docker compose up -d.

Maintained Configuration Templates

The following app templates are actively provided in v4.2 (conf/app/*.yml and conf/supabase.yml):

  • app/dify
  • app/odoo
  • app/teable
  • app/mattermost
  • app/electric
  • app/maybe
  • app/registry
  • supabase

These templates work out of the box and align with the ./configure -c ... + ./app.yml workflow.

Lightweight Compose Apps

For apps like gitea, postgrest, pgweb, wiki, kong, and bytebase, you can also use the per-app Compose templates directly:

cd ~/pigsty/app/<name>
make up

If you want to manage them uniformly via Pigsty IaC:

./app.yml -e app=<name>

Legacy Applets

Data applets like pglog, covid, db-engine, sf-survey, cloud, and isd are kept as reference examples for data modeling and visualization ideas.

They are no longer the primary application delivery path in v4.2. Prefer the software template workflow above.


Enterprise Self-Hosted Supabase

Self-host enterprise-grade Supabase with Pigsty, featuring monitoring, high availability, PITR, IaC, and 451 PostgreSQL extensions.

Odoo: Self-Hosted Open Source ERP

How to spin up an out-of-the-box enterprise application suite Odoo and use Pigsty to manage its backend PostgreSQL database.

Dify: AI Workflow Platform

How to self-host the AI Workflow LLMOps platform — Dify, using external PostgreSQL, PGVector, and Redis for storage with Pigsty?

Teable: AI No-Code Database

Self-host Teable on Pigsty v4.2 with external PostgreSQL and MinIO.

Gitea: Self-Hosted Git Service

Deploy Gitea with Pigsty’s Compose template and connect it to external PostgreSQL.

NocoDB: Open-Source Airtable

Use NocoDB to transform PostgreSQL databases into smart spreadsheets, a no-code database application platform.

Mattermost: Open-Source Team Collaboration

Deploy Mattermost on Pigsty v4.2 and store state in external PostgreSQL.

Wiki.js: OSS Wiki Software

How to self-hosting your own wikipedia with Wiki.js and use Pigsty managed PostgreSQL as the backend database

Maybe: Personal Finance

Self-host Maybe on Pigsty v4.2 with external PostgreSQL storage.

Kong: API Gateway

Deploy Kong with Pigsty Compose templates and PostgreSQL backend storage.

Metabase: BI Analytics Tool

Use Metabase for rapid business intelligence analysis with a user-friendly interface for team self-service data exploration.

Registry: Container Image Cache

Deploy Docker Registry pull-through cache and optional web UI with Pigsty v4.2.

ByteBase: Schema Migration

Deploy Bytebase with Pigsty’s Docker Compose template and connect it to external PostgreSQL.

PostgREST: Auto-Generated API

Deploy PostgREST with Pigsty Compose templates and auto-generate REST APIs from PostgreSQL schema.

PGAdmin4: PG Admin GUI Tool

Launch pgAdmin4 with docker, and load Pigsty server list into it

PGWeb: Browser-based PG Client

Launch pgweb to access PostgreSQL via web browser

Electric: PostgreSQL Sync Engine

Self-host Electric on Pigsty v4.2 to sync PostgreSQL data to frontend apps with partial replication and real-time delivery.

Jupyter: AI Notebook & IDE

Run Jupyter Lab in container, and access PostgreSQL database

PGLOG: PostgreSQL Log Analysis Application

A sample Applet included with Pigsty for analyzing PostgreSQL CSV log samples

NOAA ISD Global Weather Station Historical Data Query

Demonstrate how to import data into a database using the ISD dataset as an example

WHO COVID-19 Pandemic Dashboard

A sample Applet included with Pigsty for visualizing World Health Organization official pandemic data

StackOverflow Global Developer Survey

Analyze database-related data from StackOverflow’s global developer survey over the past seven years

DB-Engines Database Popularity Trend Analysis

Analyze database management systems on DB-Engines and browse their popularity evolution

AWS & Aliyun Server Pricing

Analyze compute and storage pricing on Aliyun / AWS (ECS/ESSD)