Application

Lots of software using PostgreSQL. Pigsty has some docker compose template for some popular software.

You can launch stateless software with docker easily and using external HA PostgreSQL for higher availability & durability.

Docker is not installed by default, You can install docker with docker.yml playbook, e.g.: ./docker.yml -l infra

Available software and their docker-compose template can be found in pigsty/app

PostgreSQL Administration

Use more advanced tools to manage PostgreSQL instances / clusters.

• PgAdmin4: A GUI tool for managing PostgreSQL instances.
• ByteBase: A GUI IaC tool for PostgreSQL schema migration.
• PGWeb: A tool automatically generates back-end API services based on PG database schema.
• SchemaSPY: Generates detailed visual reports of database schemas.
• Pgbadger: Generate PostgreSQL summary report from log samples.

Application Development

Scaffold your application with PostgreSQL and its ecosystem.

• Supabase: Supabase is an open source Firebase alternative based on PostgreSQL
• FerretDB: FerretDB, a truly open source MongoDB alternative in PostgreSQL.
• EdgeDB: EdgeDB, open source graph-like database based on PostgreSQL
• PostgREST: PostgREST, serve a RESTful API from any Postgres database automatically.
• Kong: Kong, a scalable, open source API Gateway with Redis/PostgreSQL/OpenResty
• DuckDB: DuckDB, in-process SQL olap DBMS that works well with PostgreSQL

Business Software

Launch open-source software with PostgreSQL at ease.

• Wiki.js: Wiki.js, the most powerful and extensible open source wiki software
• Gitea: Gitea, a painless self-hosted git service
• NocoDB: NocoDB, Open source AirTable alternative.
• Gitlab: open-source code hosting platform.
• Harbour: open-source mirror repo
• Jira: open-source project management platform.
• Confluence: open-source knowledge hosting platform.
• Odoo: open-source ERP
• Mastodon: PG-based social network
• Discourse: open-source forum based on PG and Redis
• Jupyter Lab: A battery-included Python lab environment for data analysis and processing.
• Grafana: use postgres as backend storage
• Promscale: use postgres/timescaledb as prometheus metrics storage

Visualization

Perform data visualization with PostgreSQL, Grafana & Echarts.

• isd: noaa weather data visualization: github.com/Vonng/isd, Demo
• pglog: PostgreSQL CSVLOG sample analyzer. Demo
• covid: Covid-19 data visualization
• dbeng: Database popularity visualization
• price: RDS, ECS price comparison