Hi everyone,
Is there a way to browse the database with something like PHPMyAdmin?
I can download backups but my MySQL Workbench crashes every time I try to run the script to restore the database.
-Clement
I’ve used pgAdmin for this purpose.
But first consider the Data Explorer Plugin.
3 Likes
Thanks @merefield will take a look.
2 Likes
The Data Explorer plugin is fine but I’m more of a visual person and it would take me a while to figure out what SQL to write. Can PGAdmin connect to the database the same way as Data Explorer or will I need to set up a local copy on my machine to query things?
What I’m trying to do is generate a report or report of users along with the custom user fields I added.
I use pgAdmin client locally to browse a remote non-docker dev instance via an ssh tunnel.
There might be some additional hoops if you want to connect to a prod instance inside the docker container.
2 Likes
That makes sense.
I think it’ll be easier to write or get help with the SQL than it will be to get pgadmin set up, and I think that even if you do get pgadmin set up, you still won’t have an easy way to get the report you want (unless you’re going to pull a couple tables into excel or something?)
2 Likes