Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postico – A modern PostgreSQL client for OS X

eggerapps.at

Post reply on HN
Print view View original

1–10 of 62 posts

Re: Postico – A modern PostgreSQL client for OS X

#4

Post by ratsbane »

I've been wanting a better Postgres client. Pgadmin works but it's a bit dated. Postico looks promising. Download and setup went seamlessly and the ssh tunnel functionality worked great. This error message was shown when I connected to the database and I wasn't able to browse catalogs, etc.: PostgreSQL said: syntax error at or near "num_total_pages" To be fair, the Postgres server I was connecting to is old and obsolete (8.3.7). I'll look forward to trying this more!

Re: Postico – A modern PostgreSQL client for OS X

#5

Post by tortilla »

cmwelsh wrote: post #3

I'll be recommending this to my coworkers as an alternative to Navicat for PostgreSQL. The time limit on the trial version of Navicat makes it hard to recommend to contractors and designers who think the price is too high for commercial use.

I picked up Navicat Essentials for PostgreSQL in the Mac App Store for something like $14 when it was on sale. It's more than enough for my needs when I want to visually view my data.

BTW, Postico is a successor to PG Commander

http://eggerapps.at/

Re: Postico – A modern PostgreSQL client for OS X

#7

Post by msluyter »

Could be promising but falls short for my use cases, which mainly consists of running ad hoc queries. I don't like Squirrel, but here are a few things squirrel does that are nice that I wish this did:

1. Auto limit

2. Syntax highlighting

3. Multiple queries can be written in the editor; spaces separate them. This seems to run the first query in the editor afaict.

4. Key bindings (I discovered that cmd-enter appears to run the query, but I didn't see these documented anywhere nor are the configurable.)

Also, stylistically it's a little spare. Alternating textures per row might be nice.

I do like the live table editing and the quick auto-querying of tables (though, there are cases where I might not like that.) Another thing I like is the query history -- one thing that would be nice would be to highlight those queries that failed due to syntax errors in red or something, to help you read the list, but even more importantly, a search feature (like Sublime's cmd-P).

Re: Postico – A modern PostgreSQL client for OS X

#8

Post by jakobegger »

ratsbane wrote: post #4

I've been wanting a better Postgres client. Pgadmin works but it's a bit dated. Postico looks promising. Download and setup went seamlessly and the ssh tunnel functionality worked great. This error message was shown when I connected to the database and I wasn't able to browse catalogs, etc.: PostgreSQL said: syntax error at or near "num_total_pages" To be fair, the Postgres server I was connecting to is old and obsol…

I think I found the problem. Had a query missing "AS" for a column alias. Could you try if this build works? https://s3-eu-west-1.amazonaws.com/eggerapps.at/postico/post...

Re: Postico – A modern PostgreSQL client for OS X

#10

Post by ratsbane »

jakobegger wrote: post #8
ratsbane wrote: post #4

I've been wanting a better Postgres client. Pgadmin works but it's a bit dated. Postico looks promising. Download and setup went seamlessly and the ssh tunnel functionality worked great. This error message was shown when I connected to the database and I wasn't able to browse catalogs, etc.: PostgreSQL said: syntax error at or near "num_total_pages" To be fair, the Postgres server I was connecting to is old and obsol…

I think I found the problem. Had a query missing "AS" for a column alias. Could you try if this build works? https://s3-eu-west-1.amazonaws.com/eggerapps.at/postico/post...

Yes, that's awesome! Thank you.
Post reply on HN