Re:Postico – A modern PostgreSQL client for OS X
by skrause on Thursday February 19, 2015 @03:11PM
(#9076638)
I'm perfectly fine with pgAdmin. It's not pretty, but it does everything I need. And it's free and cross-platform.
Re:Postico – A modern PostgreSQL client for OS X
by bmurphy1976 on Thursday February 19, 2015 @03:37PM
(#9076845)
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?
Re:Postico – A modern PostgreSQL client for OS X
by Fishkins on Thursday February 19, 2015 @05:46PM
(#9077671)
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.
Re:Postico – A modern PostgreSQL client for OS X
by mistermcgruff on Thursday February 19, 2015 @03:56PM
(#9076980)
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.
Re:Postico – A modern PostgreSQL client for OS X
by johnyzee on Thursday February 19, 2015 @03:55PM
(#9076973)
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)
Re:Postico – A modern PostgreSQL client for OS X
by rpwilcox on Thursday February 19, 2015 @03:02PM
(#9076583)
Likewise, I'm somewhat excited by what 0xDBE, the upcoming database "IDE" for DBAs and devs, from JetBrains...
Re:Postico – A modern PostgreSQL client for OS X
by mangecoeur on Friday February 20, 2015 @05:30AM
(#9079834)
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.
Re:Postico – A modern PostgreSQL client for OS X
by khebbie on Friday February 20, 2015 @02:36AM
(#9079394)
I recently discovered pgcli, it is pretty slick
Re:Postico – A modern PostgreSQL client for OS X
by spaznode on Thursday February 19, 2015 @03:30PM
(#9076780)
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
Re:Postico – A modern PostgreSQL client for OS X
by kylecordes on Thursday February 19, 2015 @03:51PM
(#9076944)
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.
Re:Postico – A modern PostgreSQL client for OS X
by buckbova on Thursday February 19, 2015 @07:30PM
(#9078177)
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.
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.