Hacker News Reader

Comment by vbezhenar | Hacker News Reader

I use Intellij Idea with Database plugin and it works perfectly. SQL syntax highlighting (for PostgreSQL dialect), autocomplete (using actual table definitions from the database), visual table editor. I can run SQL query, edit some cell in the result table and that edit will update the database.

There's a dedicated cheaper product called 0xDBE if you don't own Idea and don't need Java support.

Postico looks nice and I like the fact that it's a native app. But without highlighting and autocomplete it's not very interesting for me, I'm SQL guy.

View on HN

I'm perfectly fine with pgAdmin. It's not pretty, but it does everything I need. And it's free and cross-platform.

I've solely used the command line client for the last few years. I stopped using pgAdmin because it did not gracefully handle flakey network connections (i.e. vpn restarts). Has this improved recently?

This has not improved. However, instead of using screen in a terminal to do a long create table query, I'll now just kick it off in pgAdmin and yank my ethernet. This causes the query to just hang out there indefinitely until it's done. Stupid, yes. But it's kinda fun.

I also abandoned pgAdmin because of flaky connection handling, as well as several annoying bugs on the Mac version. I was happy with psql for a while (and still sometimes use it), but IntelliJ's DB plugin is by far my favorite now. Its autocomplete is really smart, which makes a big difference in writing queries without having to constantly check various table definitions.

For the web, TeamPostgreSQL[1] does most of these, like SQL autocomplete including schema object names, live editing query results, table editing, etc. It also has click-through foreign key references, look up rows that reference this one, and other smart features.

[1a] http://www.teampostgresql.com

[1b] http://teampostgresql.herokuapp.com/ (demo)

Likewise, I'm somewhat excited by what 0xDBE, the upcoming database "IDE" for DBAs and devs, from JetBrains...

I use the PyCharm plugin. It doesn't look like much to start with but now i've used it a bit it's actually one of the best DB clients i've ever used, especially for editing SQL queries thanks to great sytnax highlighting and completions.

I recently discovered pgcli, it is pretty slick

Yep, any varient of jetbrains with their awesome sql +++ support beats this and most others hands down. Especially if you're someone who'd actually use this for real work. Like a statistician/analyst

This is very helpful comment. Reading that this new product does not have highlight, I know that I don't need to investigate it any further for now.

I was using the database navigator plugin for a while for webstorm. It worked okay.

http://plugins.jetbrains.com/category/index?pr=webStorm&cate...

So far so good on 0xDBE. I was happy to see this come out.

https://www.jetbrains.com/dbe/eap/

Yep, started using it recently. Stupid name, great product. Way better than I expected

Reply on news.ycombinator.com