cli icon indicating copy to clipboard operation
cli copied to clipboard

Expose pgadmin

Open kiwicopple opened this issue 4 years ago • 1 comments

Feature request

Is your feature request related to a problem? Please describe.

I'd love to view the running database cluster with pgadmin. As I was jumping between branches I found that I wanted to look at all the database in the cluster.

Describe the solution you'd like

We're already using pgadmin for diff'ing - https://github.com/supabase/cli/blob/fb935d1e4e6f25004e8cae2825ec317494474fcb/internal/utils/utils.go#L50

Does this fork include the UI? If so, can we please expose it on a new port?

Additional context

It would be awesome if it was pre-populated with the connection data so that they can login and see the cluster. Also I think pgadmin requires an admin username / password - could also be postgres/postgres

kiwicopple avatar Oct 22 '21 13:10 kiwicopple

Does this fork include the UI? If so, can we please expose it on a new port?

For the CLI Dockerfile, I removed the frontend JS files to speed up installation, it also uses a different ENTRYPOINT.

Might be possible to tweak the Dockerfile to support both CLI and UI but it seems easier to use the official pgadmin image for this. We're also not updating the UI in our docker image.

steve-chavez avatar Oct 22 '21 19:10 steve-chavez

I'm inclined to follow unix philosophy of making one tool do one thing well. So not really in favour of exposing pgadmin even if we can.

If there's demand for a more advanced admin interface, we should also consider lightweight alternatives like adminer. Currently it seems that studio's UI and sql editor satisfy most common use cases.

Feel free to open a new discussion for alternate admin ui.

sweatybridge avatar Aug 24 '22 08:08 sweatybridge