> PG is great to admin
What do you use for it? Is there anything like phpmyadmin for postgres with similar simplicity?
Re:Postgres is eating the database world
by monospaced on Friday March 15, 2024 @03:40AM
(#39713005)
Coming myself from MySQL to Postgres I found PgAdmin (https://www.pgadmin.org/screenshots/#7) easy to use
I guess it's better now. Last time I tried years ago it was horrible
Re:Postgres is eating the database world
by skeletal88 on Tuesday March 19, 2024 @04:57PM
(#39760129)
Pgadmin has gotten lots of bad feedback.
I'm using dBeaver or the IntelliJ sidebar to connect to the database.
Dbeaver is more useful. But you can do everything from the command line. You use sql to write database migrations anyway, no?
Pretty much the same as mysql. https://wiki.postgresql.org/wiki/PostgreSQL_Clients#Web_Clie...
25+ years ago MySQL was fast and easy to admin but didn't have rollback and a bunch of other features. At the same time Postgres had the features but was horrible for performance and usability. Those days are LONG gone. Mysql obviously has all the features and PG is great to admin and the auto-vacuum works well out of the box.
I run a bunch of clusters of pg servers around the world and they need almost no maintenance. In place upgrades without needing to go the dump/restore route work well, 5 minutes on a TB sized database, just make very VERY sure you do a reindex afterwards or you will be in a world of pain.