Module: SOFTWARE

PostgreSQL is the most popular database in the world, and countless software is built on PostgreSQL, around PostgreSQL, or serves PostgreSQL itself, such as “Application software” that uses PostgreSQL as the preferred database “Tooling software” that …

Supabase, The open-source Firebase alternative based on PostgreSQL. Pigsty allow you to self-host supabase with existing managed HA postgres cluster, and launch the stateless part of supabase with docker-compose. Notice: Supabase is GA since …

Odoo is an open-source enterprise resource planning (ERP) software that provides a full suite of business applications, including CRM, sales, purchasing, inventory, production, accounting, and other management functions. Odoo is a typical web …

Public Demo: http://wiki.pigsty.cc TL; DR cd app/wiki ; docker compose up -d Postgres Preparation # postgres://dbuser_wiki:[email protected]:5432/wiki - { name: wiki, owner: dbuser_wiki, revokeconn: true , comment: wiki the api gateway database …

Public Demo: http://git.pigsty.cc TL;DR cd ~/pigsty/app/gitea; make up Pigsty use 8889 port for gitea by default http://git.pigsty or http://10.10.10.10:8889 make up # pull up gitea with docker-compose in minimal mode make run # launch gitea with …

Use the following docker command to generate a database schema report, using CMDB as an example: docker run -v /www/schema/pg-meta/meta/pigsty:/output andrewjones/schemaspy-postgres:latest -host 10.10.10.10 -port 5432 -u dbuser_dba -p DBUser.DBA -db …

PostgREST is a binary component that automatically generates a REST API based on the PostgreSQL database schema. For example, the following command will launch postgrest with docker (local port 8884, using default admin user, and expose Pigsty CMDB …

TL;DR cd app/kong ; docker compose up -d make up # pull up kong with docker-compose make ui # run swagger ui container make log # tail -f kong logs make info # introspect kong with jq make stop # stop kong container make clean # remove kong container …

Check Gitlab Docker Deployment to finish docker deployment. export GITLAB_HOME=/data/gitlab sudo docker run --detach \ --hostname gitlab.example.com \ --publish 443:443 --publish 80:80 --publish 23:22 \ --name gitlab \ --restart always \ --volume …

To setup an open-source forum Discourse, you need to adjust the default app.yml config, focusing on the SMTP part of the configuration. Discourse Config Example templates: - "templates/web.china.template.yml" - "templates/postgres.template.yml" - …

ByteBase ByteBase is a database schema change management tool, which is a tool for database schema changes. The following command will start a ByteBase on the meta node 8887 port by default. mkdir -p /data/bytebase/data; docker run --init --name …

pgAdmin4 is a useful PostgreSQL management tool. Execute the following command to launch the pgadmin service on the admin node: cd ~/pigsty/app/pgadmin ; docker compose up -d The default port for pgadmin is 8885, and you can access it through the …

Public Demo: http://sss.pigsty.cc Compose template credential: minioadmin / minioadmin. The standalone command below uses admin / pigsty.minio. TL; DR Launch minio (s3) service on 9000 & 9001 cd ~/pigsty/app/minio ; docker compose up -d docker run -p …

PGWEB: https://github.com/sosedoff/pgweb Simple web-based and cross-platform PostgreSQL database explorer. Public Demo: http://cli.pigsty.cc TL; DR cd ~/pigsty/app/pgweb ; make up Visit http://cli.pigsty or http://10.10.10.10:8886 Try connecting with …

Run jupyter notebook with docker, you have to: change the default password in .env: JUPYTER_TOKEN create data dir with proper permission: make dir, owned by 1000:100 make up to pull up jupyter with docker compose cd ~/pigsty/app/jupyter ; make dir up …