News for hackers. Stuff that matters.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by e98cuenc on Sunday April 09, 2017 @08:00AM (#14071857)
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)

Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by DEinspanjer on Sunday April 09, 2017 @08:11AM (#14071889)
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.

Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by lima on Sunday April 09, 2017 @09:32AM (#14072185)
If you use IntelliJ, you're already using DataGrip - it's the "Database" plugin.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by antoaravinth on Monday April 10, 2017 @01:58AM (#14076395)
I was about to ask this question on whats the difference between default IntelliJ database plugin and DataGrip. Thanks for your comment on this.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by lima on Monday April 10, 2017 @10:43AM (#14078861)
It's mostly the same, DataGrap is a bit easier/more obvious to use but the features are identical from what I can tell.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by peter_pen on Sunday April 09, 2017 @11:14AM (#14072658)
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 :)
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by jonathanfoster on Sunday April 09, 2017 @08:10AM (#14071881)
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/
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by reactor on Sunday April 09, 2017 @10:33AM (#14072481)
You should give http://dbeaver.jkiss.org/ a try.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by juandazapata on Sunday April 09, 2017 @08:13AM (#14071893)
Navicat has been around for several years, and you can even build queries using drag and drop. It's pretty feature complete.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by Exuma on Sunday April 09, 2017 @12:32PM (#14073052)
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)
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by brandoncordell on Sunday April 09, 2017 @08:02PM (#14075022)
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.

Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by dgelks on Sunday April 09, 2017 @10:29AM (#14072459)
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
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by peter_pen on Sunday April 09, 2017 @11:17AM (#14072672)
Try compare to Valentina Studio. It can do tons things which Sequel Pro do not have.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by dgelks on Wednesday April 12, 2017 @02:15PM (#14100257)
Just downloaded and will investigate - thanks!
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by juandazapata on Wednesday April 12, 2017 @12:52PM (#14099462)
You primary reason to pick a production DB server is the availability of a GUI client? Wow.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by dgelks on Wednesday April 12, 2017 @02:14PM (#14100250)
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.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by alleycat on Sunday April 09, 2017 @11:09AM (#14072630)
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.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by juandazapata on Wednesday April 12, 2017 @12:53PM (#14099476)
Try Navicat Premium. It can handle MySql, Postgres, Sqlite, MSSQL and Oracle.
Re:Ask HN: What are pros and cons of PostgreSQL and MySQL? by reitanqild on Sunday April 09, 2017 @08:18AM (#14071911)
TOAD for MySQL is also free for those who like it and run Windows.