Applications
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.
Application Model
The recommended application deployment workflow is:
app.yml copies app/<name> templates to /opt/<name>, overwrites .env with apps.<name>.conf, then runs docker compose up -d.
Maintained Config Templates
The following app config templates are actively maintained (conf/app/*.yml, conf/supabase.yml, and the conf/app/supa.yml symlink):
app/difyapp/odooapp/teableapp/mattermostapp/electricapp/maybeapp/immichapp/jumpserverapp/registryapp/insforgeapp/hindsightsupabase
These templates work out of the box and align with the ./configure -c ... + ./app.yml workflow.
Lightweight Compose Apps
For apps like bytebase, gitea, jupyter, kong, metabase, minio, nocodb, pgadmin, pgweb, postgrest, pg_exporter, and wiki, you can also use the per-app Compose templates directly.
FerretDB is provided as the Docker APP layer of PostgreSQL Mongo mode. Deploy it from the mongo configuration template with docker.yml and app.yml.
If you want to manage them uniformly via Pigsty IaC:
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. Prefer the software template workflow above.
Self-host enterprise-grade Supabase with Pigsty, featuring monitoring, high availability, PITR, IaC, and 575 PostgreSQL extensions.
How to spin up an out-of-the-box enterprise application suite Odoo and use Pigsty to manage its backend PostgreSQL database.
How to self-host the AI Workflow LLMOps platform — Dify, using external PostgreSQL, PGVector, and Redis for storage with Pigsty?
Self-host InsForge OSS with Pigsty and let Pigsty manage PostgreSQL, backups, monitoring, and ingress.
Self-host Hindsight with Pigsty and store long-term memory in external PostgreSQL.
Deploy a stateless FerretDB proxy on PostgreSQL and DocumentDB managed by Pigsty.
Self-host Teable with Pigsty, external PostgreSQL, and Silo.
Deploy Gitea with Pigsty’s Compose template and connect it to external PostgreSQL.
Use NocoDB to transform PostgreSQL databases into smart spreadsheets, a no-code database application platform.
Deploy Mattermost with Pigsty and store state in external PostgreSQL.
How to self-hosting your own wikipedia with Wiki.js and use Pigsty managed PostgreSQL as the backend database
Self-host the Maybe personal finance application with Pigsty and let Pigsty manage PostgreSQL, backups, monitoring, and ingress.
Self-host Immich, the open-source Google Photos alternative, with Pigsty managing its metadata, vector search, backups, and ingress.
Deploy Kong with Pigsty Compose templates and PostgreSQL backend storage.
Use Metabase for rapid business intelligence analysis with a user-friendly interface for team self-service data exploration.
Deploy a Docker Registry pull-through cache and optional web UI with Pigsty.
Self-host JumpServer Community Edition with Pigsty managing its PostgreSQL backend, backups, ingress, and operations.
Deploy Bytebase with Pigsty’s Docker Compose template and connect it to external PostgreSQL.
Deploy pgAdmin4 with Pigsty’s Docker Compose template and safely load the PostgreSQL server inventory.
Run the bundled pgweb Docker application for small, interactive PostgreSQL queries from a browser.
Deploy PostgREST with Pigsty Compose templates and auto-generate REST APIs from PostgreSQL schema.
Self-host Electric with Pigsty to sync PostgreSQL data to frontend apps with partial replication and real-time delivery.
Run JupyterLab with Pigsty’s standalone Docker Compose template and access PostgreSQL safely.
A sample Applet included with Pigsty for analyzing PostgreSQL CSV log samples
Demonstrate how to import data into a database using the ISD dataset as an example
A sample Applet included with Pigsty for visualizing World Health Organization official pandemic data
Analyze database-related data from StackOverflow’s global developer survey over the past seven years
Analyze database management systems on DB-Engines and browse their popularity evolution
Analyze compute and storage pricing on Aliyun / AWS (ECS/ESSD)
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)