News for hackers. Stuff that matters.
Re:Underrated Features of PostgreSQL by saturn on Wednesday November 02, 2011 @11:26AM (#3187190)
The one thing I miss after switching to PostgreSQL from MySQL is Sequel Pro. pgAdmin 3, sorry to say, sucks, and I grow tired of rails dbconsole - but that's my only option, really.

Please, someone, make a good osx pg client. Just copy Sequel Pro if you don't know what I mean by that. I would pay a lot of money for a good osx client, I am not kidding, I have to deal with this every day. I cannot be the only one..

Re:Underrated Features of PostgreSQL by jpeterson on Wednesday November 02, 2011 @12:12PM (#3187452)

    #> psql mydb
Re:Underrated Features of PostgreSQL by jpitz on Wednesday November 02, 2011 @05:12PM (#3188950)
Seriously. The command line console for postgres really is that good. I'd rather spend a day in it than any vendor-provided or third party GUI for any database I have ever touched. This includes things like dbVisualizer, SquirrelSQL, pgAdmin3, SQL Server Management Studio, and the various flavors of Toad. A screen session with psql in one display and emacs in the other is heaven.
Re:Underrated Features of PostgreSQL by ryanbraganza on Wednesday November 02, 2011 @03:52PM (#3188649)
rails dbconsole is the same thing. (it runs psql for you with args as specified in your database config)
Re:Underrated Features of PostgreSQL by willcodeforfoo on Wednesday November 02, 2011 @12:57PM (#3187730)
Sequel Pro is awesome... I think they are working toward offering Postgres support: http://code.google.com/p/sequel-pro/issues/detail?id=362 but haven't seen anything concrete yet.

I just learned SP has bundles, like TextMate. Nifty.

Re:Underrated Features of PostgreSQL by Pewpewarrows on Wednesday November 02, 2011 @11:30AM (#3187220)
Is Navicat not a good option?
Re:Underrated Features of PostgreSQL by megaman821 on Wednesday November 02, 2011 @12:27PM (#3187537)
It is not free, but neither is my time. I find that Navicat is awesome.
Re:Underrated Features of PostgreSQL by michaelbuckbee on Wednesday November 02, 2011 @01:21PM (#3187871)
The Navicat Lite option is free and pretty adequate (on par feature wise with pgAdmin 3).
Re:Underrated Features of PostgreSQL by a2tech on Wednesday November 02, 2011 @06:45PM (#3189282)
DbVis is GREAT and multi-db management tool http://www.dbvis.com/
Re:Underrated Features of PostgreSQL by pak on Thursday November 03, 2011 @01:33AM (#3190462)
As soon as I see "available on all major operating systems" I groan, because of course it seems to be a Java app. The user experience for Cocoa apps on OS X blows away that of a Java app. The reason Sequel Pro is great is because it feels like a first-rate Mac app and seamlessly fits in with everything else.

You can make a Java app feel almost native on OS X, like with Cyberduck, but it is really, really hard and you have to prioritize that target in your design. Then what happens, as seen with Cyberduck, is the Mac version coming out pretty good and the Windows version feeling a little "off."

Re:Underrated Features of PostgreSQL by bsg75 on Thursday November 03, 2011 @03:42PM (#3193363)
I share some of your sentiments about x-plat Java UIs, but DbVisualizer does an admirable job. I now use on Windows for SQL Server for most tasks even when the native GUI is available. Its worth a look.
Re:Underrated Features of PostgreSQL by bockris on Wednesday November 02, 2011 @12:49PM (#3187676)
Just curious, is it a pgadmin3 on OSX that is the problem for you or pgadmin3 in general?

On Windows, I find that I quite like pgadmin3 as compared to MySQL workbench but it's likely just a matter of taste.

Re:Underrated Features of PostgreSQL by izak30 on Wednesday November 02, 2011 @12:44PM (#3187638)
You could do alright (and very customizable) with the django admin and introspection. "Somebody" should probably write up a guide on doing that.
Re:Underrated Features of PostgreSQL by caf on Wednesday November 02, 2011 @07:38PM (#3189440)
Have you tried Aqua Data Studio?
Re:Underrated Features of PostgreSQL by dramaticus3 on Wednesday November 02, 2011 @12:57PM (#3187732)
What's wrong with the console ?
Re:Underrated Features of PostgreSQL by reuven on Wednesday November 02, 2011 @03:46PM (#3188618)
Good question; I'm not sure. That said, none (literally none) of my PostgreSQL-using clients use psql, and they're somewhere between amazed and horrified that I prefer it for working with the database.

I'm not against GUIs, but it seems to me that psql has all of the advantages of the GUI administration tools, and then some.