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

21–30 of 62 posts

Re: Postico – A modern PostgreSQL client for OS X

#21

Post by bmurphy1976 »

skrause wrote: post #17
vbezhenar wrote: post #13

I use Intellij Idea with Database plugin and it works perfectly. SQL syntax highlighting (for PostgreSQL dialect), autocomplete (using actual table definitions from the database), visual table editor. I can run SQL query, edit some cell in the result table and that edit will update the database. 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'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?

Re: Postico – A modern PostgreSQL client for OS X

#22

Post by uxp »

jakobegger wrote: post #18
msluyter wrote: post #7

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 t…

1. I don't really want to modify the SQL the user types in the query 2. Syntax highlighting is hard to get right, but I'll add it eventually. 3. Postico by default runs all the queries, you can use the popup menu at the bottom to toggle between results. Select some text (even discontinuous selection using ⌘) and only the selected part is executed. 4. Key bindings are shown as tooltips (hover over buttons for a few se…

An alternative to syntax highlighting might be query structuring/beautifying (on command, not by default).

And +1 from me for search history. Thanks for building these apps. Sequel Pro nails it for MySQL, but up until lately there seemed to be a void on the PG side. I've been using PG Commander for about 5 months and am excited I can use my license on Postico. So far the app works as I expect it to, and looks fantastic.

Re: Postico – A modern PostgreSQL client for OS X

#24

Post by kylecordes »

vbezhenar wrote: post #13

I use Intellij Idea with Database plugin and it works perfectly. SQL syntax highlighting (for PostgreSQL dialect), autocomplete (using actual table definitions from the database), visual table editor. I can run SQL query, edit some cell in the result table and that edit will update the database. There's a dedicated cheaper product called 0xDBE if you don't own Idea and don't need Java support. Postico looks nice and…

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

#27

Post by johnyzee »

vbezhenar wrote: post #13

I use Intellij Idea with Database plugin and it works perfectly. SQL syntax highlighting (for PostgreSQL dialect), autocomplete (using actual table definitions from the database), visual table editor. I can run SQL query, edit some cell in the result table and that edit will update the database. There's a dedicated cheaper product called 0xDBE if you don't own Idea and don't need Java support. Postico looks nice and…

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

#28

Post by mistermcgruff »

bmurphy1976 wrote: post #21
skrause wrote: 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?

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

#29

Post by jiaaro »

Killswitch wrote: post #11

How would you compare it to http://www.psequel.com ?

It's pretty similar.

Psequel doesn't currently offer anything for schema editing, so you have to write your own queries for ALTER, CREATE INDEX, etc.

PSequel also doesn't show you the execution time of a query, which seems minor, and yes I know you can use EXPLAIN ANALYZE, but it bugs me pretty much every time I use it.

Neither one provides any way to add, view, or remove indexes

Re: Postico – A modern PostgreSQL client for OS X

#30

Post by clintboxe »

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.
Post reply on HN