4 ms·
I use Intellij Idea with Database plugin and it works perfectly. SQL syntax highlighting (for PostgreSQL dialect), autocomplete (using actual table definitions
by vbezhenar 12y ago
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.
- rpwilcox 12y agoLikewise, I'm somewhat excited by what 0xDBE, the upcoming database "IDE" for DBAs and devs, from JetBrains...
- skrause 12y agoI'm perfectly fine with pgAdmin. It's not pretty, but it does everything I need. And it's free and cross-platform.
- bmurphy1976 12y agoI'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?
- mistermcgruff 12y agoThis 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.
- Fishkins 12y agoI 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.
- spaznode 12y agoYep, 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
- kylecordes 12y agoThis 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.
- johnyzee 12y agoFor 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 http://www.teampostgresql.com [1b] http://teampostgresql.herokuapp.com/ http://teampostgresql.herokuapp.com/ (demo)
- ClayM 12y agoYep, started using it recently. Stupid name, great product. Way better than I expected
- buckbova 12y agoI was using the database navigator plugin for a while for webstorm. It worked okay. http://plugins.jetbrains.com/category/index?pr=webStorm&category_id=45 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/ https://www.jetbrains.com/dbe/eap/
- khebbie 12y agoI recently discovered pgcli, it is pretty slick
- mangecoeur 12y agoI 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.