This page contains a quickstart to help you get pgweb]() up and running with Container Apps on Crunchy Bridge. We recommend you start with the quickstart to get an understanding of container apps.
From the original project:
Pgweb is a web-based database browser for PostgreSQL, written in Go and works on OSX, Linux and Windows machines. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.
Pgweb with Container Apps Quickstart
First ensure you have Container Apps enabled with
CREATE EXTENSION pgpodman;. Once enabled you’ll need your DATABASE_URL from Crunchy Bridge to include in the command. To start your Pgweb you can run:
SELECT run_container('-dt -p 5433:8081/tcp -e DATABASE_URL="<DATABASE_URL>" docker.io/sosedoff/pgweb');
Now you can visit your running Pgweb at your hostname:5433.