3 ms·
I used both of them, but migrated to Postgres permanently a decade ago. Early on in my career, the biggest selling point for Mysql was the excellent web admin
by samcheng 8y ago
I used both of them, but migrated to Postgres permanently a decade ago.
Early on in my career, the biggest selling point for Mysql was the excellent web admin tool "phpMyAdmin" - it really helped get applications off the ground, since the core of most modern systems is the data model. Users could modify data, without your needing to create a UI for that use case.
It conveniently used the same stack as the rest of the software, but I remember spinning up a phpMyAdmin instance even after moving away from PHP as an application language.
Postgres still doesn't really have anything like that! The closest that comes to mind is Django's Admin tool.
- rgbrenner 8y agophpPgAdmin, started ~2002: http://phppgadmin.sourceforge.net/doku.php http://phppgadmin.sourceforge.net/doku.php Basically a port of phpMyAdmin to postgres. I used it for several years around ~2003-5.. it's nearly identical.
- luhn 8y agoI’m a regular Postgres user and fan, but cut my teeth on LAMP. I can’t speak to the current state of the projects, but phpMyAdmin was vastly superior to phpPgAdmin in the 2000s. phpMyAdmin remains the best DB GUI I’ve ever used. (Although I haven’t used any GUI in quite a few years.)
- deleted 8y ago[deleted]
- gbuk2013 8y agoIt was the same for me - back when I first learned SQL I really tried to use Postgres but phpMyAdmin was so much better than pgMyAdmin that I gave up. A lesson in the importance of user-friendly UIs. Perhaps some developers can really nail a schema on first go, but for me it usually takes a lot of tweaking before I can really understand what I want and the CLI is not the best place for that, especially if my mind is deep in the code I am trying to write.
- StreamBright 8y agoThere are tons of tools like phpMyAdmin for Postgres.
- Avamander 8y agoJetBrains' IDEs have Postgres data source support, I find that GUI really rather excellent for anything I've had to do and couldn't remember the syntax for.