Live data from Hacker News

Postico – A modern PostgreSQL client for OS X

eggerapps.at

31–40 of 62 posts

Re: Postico – A modern PostgreSQL client for OS X

#31
This has a pretty nice look and feel to it, but I've yet to find something that competes with DBVisualizer (http://www.dbvis.com/). Connect to anything with a JDBC driver, auto-completion, SQL history, auto-generate insert statements using a table's data, etc. Great product.

Re: Postico – A modern PostgreSQL client for OS X

#33

For the same price, you can get Navicat Essentials, which has syntax highlighting, import/export, and more. If you want to spend $160, you get the version that can talk to MySQL, SQL Server, SQLite, and more.

I'm a single dev; I can't compete with Navicat on features. But I can try to make an app that does a limited set of things really well.

For example, I'm really proud of the table view in Postico. It's really easy to filter rows by keywords. You can edit multiple rows at once in the sidebar. You can rearrange columns, filters and sort order are remembered automatically...

If you have a workflow where you don't often use the table view, you might not get a lot of value out of Postico. But fortunately there are a few people out there who do like the stuff Postico does!

Re: Postico – A modern PostgreSQL client for OS X

#37
post #17

Earlier quoted context omitted.

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?

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

#39

For the same price, you can get Navicat Essentials, which has syntax highlighting, import/export, and more. If you want to spend $160, you get the version that can talk to MySQL, SQL Server, SQLite, and more.

Agreed. I was really hesitant to buy Navicat Essentials when pgAdmin is available and free. But once I tried the trial I was converted - and it's only $10. It's well worth that for the increase in my productivity.
Post reply on HN