Hacker News Reader

Comment by e98cuenc | Hacker News Reader

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)

View on HN

I 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.

If you use IntelliJ, you're already using DataGrip - it's the "Database" plugin.

I was about to ask this question on whats the difference between default IntelliJ database plugin and DataGrip. Thanks for your comment on this.

It's mostly the same, DataGrap is a bit easier/more obvious to use but the features are identical from what I can tell.

Try Valentina Studio - http://valentina-db.com/en/valentina-studio-overview. A lots of people say it is best PotgreSQL GUI Manager. May be mySQL also :)

You should give DataGrip a try. It's a new database IDE by Jetbrains that supports all the major databases. https://www.jetbrains.com/datagrip/

You should give http://dbeaver.jkiss.org/ a try.

Navicat has been around for several years, and you can even build queries using drag and drop. It's pretty feature complete.

I 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)

While 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.

Agreed, 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

Try compare to Valentina Studio. It can do tons things which Sequel Pro do not have.

Just downloaded and will investigate - thanks!

You primary reason to pick a production DB server is the availability of a GUI client? Wow.

We 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.

I 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.

Try Navicat Premium. It can handle MySql, Postgres, Sqlite, MSSQL and Oracle.

TOAD for MySQL is also free for those who like it and run Windows.

Reply on news.ycombinator.com