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