Hacker News Reader

Comment by wenc | Hacker News Reader

The biggest gripe I've had with Postgres (and I mention this elsewhere) is the lack of a decent GUI/IDE.

But as Datagrip matures, the landscape can only get better. Datagrip is not free, but I'm willing to pay for something that works better than pgAdmin.

There are some exciting things happening in the Postgres space. Outside of Citus for scaling out, TimescaleDB has a plugin that makes Postgres a strong contender in the time-series database space. Temporal joins have always been a problem with NoSQL time-series databases; otoh joins are what SQL databases have traditionally been optimized for. It'll be exciting to have a large-scale datastore where you can easily combine and recombine different time-series in a single query.

View on HN

For OSX: Postico (https://eggerapps.at/postico/). You have to pay, and it's no Sequel Pro, but it's leagues better than all the garbage free ones.

Hmm i have been looking at this one before.

Could you share some user experiences, like how often you get updates, and the start guide has a 'Connecting to a remote PostgreSQL server via SSH' section, without content yet, does tunnelling via SSH work nice/as expected?

Not the op but connecting through SSH works great in my experience and is very straight forward in the UI. I feel like updates are pretty frequent as well. I also love that it saves all my queries unlike psequel.

I can answer this, as I purchased Postico for our team just today (just out of gratitude really, as the free version is good enough)

Tunnelling via SSH works great, but you do have to provide and save your ssh key password in Postico, because it does not use ssh-agent.

Lots of great features and small updates here and there: it was updated with touch bar support quite quickly. A killer feature is Ctrl+P fuzzy search for table names in database.

It's great for getting query data out of your db quickly or just browsing around. Ok to add the odd column here and there. However managing roles and permissions seems to be out of scope.

I tried Datagrip, and ... I cant say I am enthusiastic

First thing to note, datagrip is a sql development ide, not a sql server admin tool, so it may lack some of the administration tool you might expect, like monitoring for example

Even as an IDE, it seems lacking some basic notions, for example, there isnt really a meaningful way to have a SQL Project, you get a bunch of connection and query shells, but you dont really get a Project that encapsulate both, also there is not support for deployment

Finally, I am getting the impression that Jetbrains, it getting too stretched, if you follow their bug list, its too big ... and many IDEs do not seem to get the same attention as others

In conclusion, dont bet on Datagrip, its got a long way to go, there doesnt seem to be a good designer with interesting concepts behind it .. so it will just be at best a glorified sql mode

> I am getting the impression that Jetbrains, it getting too stretched,

And how. With the rate at which they're churning out new projects and initiatives, I have to assume that they're either severely understaffed, or seeing the average tenure of their development team dropping like a stone with all those new hires. Maybe both at the same time.

My workplace uses Aqua Data Studio (http://www.aquafold.com/aquadatastudio_features). It supports everything from Oracle, DB2 and SQL Server to PostgreSQL, MySQL, and SQLite. It even supports MongoDB. And it even has tools for importing from Excel spreadsheets directly. Pretty much if your RDBMS has a JDBC provider, it works with Aqua Data Studio.

It's not free, and it's not cheap, but it's really quite nice.

PGadmin and DBeaver are nice, just in case you didn't tried them.

+1 for DBeaver, tried most of the alternative clients already, love how you can easily copy and paste a generated INSERT statement based on a selected row, makes easy for "debug cycles".

Pgadmin went downhill, the new version is borderline unusable.

Yep. I'm still using pgadmin 3.

If you haven't checked out Postico, it is hands-down the nicest database GUI I've worked with: https://eggerapps.at/postico/

Although it's expensive, Navicat (https://www.navicat.com) provides polished experience for PostgreSQL.

We use Sql Pro for Postgres. It's been great. https://macpostgresclient.com/

Have you tried pycharm? It offers some nice things like auto-complete over SQL as well as your table schema.

datagrip and pycharm are both made by JetBrains. Datagrip is probably the exact same thing built into pycharm, but as a standalone product.

Having use intellij ultimate and datagrip, pretty much, datagrip was a DBA orientated product built around the excellent database tools in intellij.

Reply on news.ycombinator.com