6 ms·
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
by saturn 15y ago
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..
- Pewpewarrows 15y agoIs Navicat not a good option?
- megaman821 15y agoIt is not free, but neither is my time. I find that Navicat is awesome.
- michaelbuckbee 15y agoThe Navicat Lite option is free and pretty adequate (on par feature wise with pgAdmin 3).
- jpeterson 15y ago#> psql mydb
- ryanbraganza 15y agorails dbconsole is the same thing. (it runs psql for you with args as specified in your database config)
- jpitz 15y agoSeriously. 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.
- izak30 15y agoYou could do alright (and very customizable) with the django admin and introspection. "Somebody" should probably write up a guide on doing that.
- bockris 15y agoJust 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.
- willcodeforfoo 15y agoSequel Pro is awesome... I think they are working toward offering Postgres support: http://code.google.com/p/sequel-pro/issues/detail?id=362 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.
- dramaticus3 15y agoWhat's wrong with the console ?
- reuven 15y agoGood 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.
- dramaticus3 15y agoPeople everywhere seem terrified of the console. It has a banner over it saying "Know What You Are Doing" and most would prefer to stab away at tree controls and tabs randomly filling in fields until it does something similar to what they want.
- a2tech 15y agoDbVis is GREAT and multi-db management tool http://www.dbvis.com/ http://www.dbvis.com/
- pak 15y agoAs 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."
- bsg75 15y agoI 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.
- caf 15y agoHave you tried Aqua Data Studio?