Hacker News Reader

Comment by garyclarke27 | Hacker News Reader

Wow, well done Microsoft, I am looking forward to trying this out. PgAdmin is an embarrassment to the incredible Postgres community - it’s SQL editor is virtually useless, so slow and buggy. Probably because PSQL is the favoured option for most of the contributors, I’m not a huge fan of command line editing, I much prefer tools like Sublime Text, so I use Sublime Text 3 for SQL editing and it’s wonderful - blazing speed, rock solid, quite happy to display a few million rows, such queries would have no chance in Pgadmin. Also has a pg specific syntax highlighting plugin.

View on HN

I'm quite happy with https://dbeaver.io/

Maybe give it a try?

Dbeaver just has one glaring issue in my mind -it has a VERY slow pace of development and issue managment. They had something like 900 issues open on their github the last time i saw it with around 200 of them having no replies at all. I was trying it out for sql server though so i don't know if it does better or not for postgres

The large number of open issues is a valid complaint although that is more of an indicator of popularity. As for the pace of development I’d challenge you to name another SQL IDE that releases updates twice a month. (Note: The exception was the last release cycle which took 3 weeks rather than 2 but that was for the 6.0 release)

When the new version of PgAdmin came out, I kept using the previous native version, much better than their UI reboot.

Pgadmin 4 is just an absolutely shocking piece of software.

Shocking, as in? Could you elaborate?

They moved from an UI written in C++ to a Python process that launches a Web based UI.

I wouldn't mind a web based UI if it didn't mean less functionality, more bugs, and a worse user experience.

pgAdmin3 doesn't connect to newer PG versions though.

MySQL and SQLite are logically the next databases for Azure Data Studio to target.

Then it will become the swiss army chainsaw for DBdevs and DBA's.

I am happy with electron apps when quality is at the level of VScode.

Buy more RAM ;)

Reply on news.ycombinator.com