19 ms·

My personal favorite - Valentina Studio. Available in windows, mac and linux. Can work with MySQL, PostgreSQL, SQLite. https://www.valentina-db.com/en/valenti

My personal favorite - Valentina Studio. Available in windows, mac and linux. Can work with MySQL, PostgreSQL, SQLite. https://www.valentina-db.com/en/valentina-studio-overview https://www.valentina-db.com/en/valentina-studio-overview

eswat 9y ago
Thanks for the suggestion. While the OP is awesome over pgadmin I had been looking for a good polyglot DB tool for a while.
- acmecorps 9y ago
  Yes, and best of all - it's free! *with more paid advance features, but hey, if you need those, it's worth it.
- brightball 9y ago
  I've been pretty happy with DBeaver in that regard.
- _e 9y ago
  Check out Navicat Premium from their website [1]: Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud and Google Cloud. You can quickly and easily build, manage and maintain your databases. [1] https://www.navicat.com/en/products/navicat-premium https://www.navicat.com/en/products/navicat-premium
  - acmecorps 9y ago
    Yeah, navicat is great! It's just for a small time developer / student, the $1,299.00 price tag is not really enticing. I'll gladly pay for a subscription model like adobe cc.
    - snuxoll 9y ago
      Dunno if it's still offered anymore, but Navicat Premium Essentials was a decent value - you buy a small base and add the features you want on top with IAP's. I didn't care for any of the diagramming / data modeling stuff so I just bought the base plus a couple add-ons. Of course, I just use DataGrip now, but if you want Navicat see if Premium Essentials is still around as it may work for you.
      - _e 9y ago
        I tried DataGrip when it first came out but found it lacking in some areas. I'm sure much has changed since the first release but are you wishing there are any features in Navicat that should be in DataGrip?
        snuxoll 9y ago
        The notable missing features are the synchronization tools, beyond that I haven't found anything of import missing. The data modeling tools in IntelliJ/DataGrip aren't anything to write home about, but I rarely use them (I've always just busted out Visio or LucidChart for UML/relational modeling when I have to do it). For my own work use I really have no choice but DataGrip, it's the only database utility that supports DB2 for i, Microsoft SQL Server and PostgreSQL - all of which we use heavily at work. But also being a heavy user of other JetBrains products (IntelliJ, ReSharper, PyCharm) having a familiar interface is a huge positive over Navicat since all of my keyboard shortcuts work the same and I only have two different (VS vs IntelliJ-based IDE) ways I have to remember how to do code snippets instead of three.
        _e 9y ago
        Thank you for sharing your thoughts on the two. You might find Vertabelo [1] useful and possible replacement of LucidChart & Visio for db modeling. [1] http://www.vertabelo.com/ http://www.vertabelo.com/

eswat 9y ago

Thanks for the suggestion. While the OP is awesome over pgadmin I had been looking for a good polyglot DB tool for a while.

acmecorps 9y ago
Yes, and best of all - it's free! *with more paid advance features, but hey, if you need those, it's worth it.
brightball 9y ago
I've been pretty happy with DBeaver in that regard.
_e 9y ago
Check out Navicat Premium from their website [1]: Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud and Google Cloud. You can quickly and easily build, manage and maintain your databases. [1] https://www.navicat.com/en/products/navicat-premium https://www.navicat.com/en/products/navicat-premium
- acmecorps 9y ago
  Yeah, navicat is great! It's just for a small time developer / student, the $1,299.00 price tag is not really enticing. I'll gladly pay for a subscription model like adobe cc.
  - snuxoll 9y ago
    Dunno if it's still offered anymore, but Navicat Premium Essentials was a decent value - you buy a small base and add the features you want on top with IAP's. I didn't care for any of the diagramming / data modeling stuff so I just bought the base plus a couple add-ons. Of course, I just use DataGrip now, but if you want Navicat see if Premium Essentials is still around as it may work for you.
    - _e 9y ago
      I tried DataGrip when it first came out but found it lacking in some areas. I'm sure much has changed since the first release but are you wishing there are any features in Navicat that should be in DataGrip?
      - snuxoll 9y ago
        The notable missing features are the synchronization tools, beyond that I haven't found anything of import missing. The data modeling tools in IntelliJ/DataGrip aren't anything to write home about, but I rarely use them (I've always just busted out Visio or LucidChart for UML/relational modeling when I have to do it). For my own work use I really have no choice but DataGrip, it's the only database utility that supports DB2 for i, Microsoft SQL Server and PostgreSQL - all of which we use heavily at work. But also being a heavy user of other JetBrains products (IntelliJ, ReSharper, PyCharm) having a familiar interface is a huge positive over Navicat since all of my keyboard shortcuts work the same and I only have two different (VS vs IntelliJ-based IDE) ways I have to remember how to do code snippets instead of three.
        _e 9y ago
        Thank you for sharing your thoughts on the two. You might find Vertabelo [1] useful and possible replacement of LucidChart & Visio for db modeling. [1] http://www.vertabelo.com/ http://www.vertabelo.com/