4 ms·
For me, a key advantage of MySQL is Sequel Pro. I've never found a GUI for postgresql that can touch it. If there was one, I will switch in a heartbeat as I wi
by e98cuenc 10y ago
For me, a key advantage of MySQL is Sequel Pro. I've never found a GUI for postgresql that can touch it.
If there was one, I will switch in a heartbeat as I will love to have access to some more advanced SQL than what's available in MySQL (like window functions)
- jonathanfoster 10y agoYou should give DataGrip a try. It's a new database IDE by Jetbrains that supports all the major databases. https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/
- deleted 10y ago[deleted]
- DEinspanjer 10y agoI haven't used Sequel Pro, so please forgive me if there are some very advanced features beyond solid DBMS DML and DDL. I started using Jetbean's DataGrip product last year when they released it. It is built on the IntelliJ IDEA tech stack and provides a fantastic multi-DBMS platform that has everything I need not only for Postgres but MSSQL and others.
- lima 10y agoIf you use IntelliJ, you're already using DataGrip - it's the "Database" plugin.
- antoaravinth 10y agoI was about to ask this question on whats the difference between default IntelliJ database plugin and DataGrip. Thanks for your comment on this.
- lima 10y agoIt's mostly the same, DataGrap is a bit easier/more obvious to use but the features are identical from what I can tell.
- juandazapata 10y agoNavicat has been around for several years, and you can even build queries using drag and drop. It's pretty feature complete.
- reitanqild 10y agoTOAD for MySQL is also free for those who like it and run Windows.
- dgelks 10y agoAgreed, Sequel Pro is far above anything I've seen in Postgres and is the primary reason we are still using MySQL in production - business team just love Sequel Pro too much
- peter_pen 10y agoTry compare to Valentina Studio. It can do tons things which Sequel Pro do not have.
- dgelks 10y agoJust downloaded and will investigate - thanks!
- juandazapata 10y agoYou primary reason to pick a production DB server is the availability of a GUI client? Wow.
- dgelks 10y agoWe didn't select MySQL on the basis of having SequelPro obviously, that would be insane. However if you are still using MySQL and want to switch over to PostgreSQL (like us) a major reason not to be not having SequelPro. Most other factors about PostgreSQL are better but just not enough for the effort to migrate to be worthwhile.
- reactor 10y agoYou should give http://dbeaver.jkiss.org/ http://dbeaver.jkiss.org/ a try.
- alleycat 10y agoI really wish there was a GUI that could handle both Mysql and Postgresql, was cross-platform and worked as well as Sequel Pro with a similar polished UI.
- juandazapata 10y agoTry Navicat Premium. It can handle MySql, Postgres, Sqlite, MSSQL and Oracle.
- deleted 10y ago[deleted]
- peter_pen 10y agoTry Valentina Studio - http://valentina-db.com/en/valentina-studio-overview http://valentina-db.com/en/valentina-studio-overview. A lots of people say it is best PotgreSQL GUI Manager. May be mySQL also :)
- Exuma 10y agoI used to like Sequel Pro, but I've come to LOVE Postico (for Postgres) and I absolutely hate sequel pro now when I have to use it... and this is coming from someone who was in the same boat (I loved sequal pro and nothing even came close)
- brandoncordell 10y agoWhile not as clean and simple as Sequel Pro, I've found that Navicat Premium is pretty good. Especially since I use both MySQL and PostgreSQL. It can also manage SQLite and a few others.