Applications
Pigsty applications have 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>. It replaces .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 are ready to use with the ./configure -c ... and ./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 fork/mongo configuration template with docker.yml and app.yml.
To manage these apps with Pigsty IaC, run:
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.
Deploy Odoo Community 19 with Pigsty-managed PostgreSQL.
Self-host Dify with Pigsty, external PostgreSQL, pgvector, and Redis storage.
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.
Self-host Wiki.js with Pigsty-managed PostgreSQL as its 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)