How would you compare it to http://www.psequel.com?
Postico – A modern PostgreSQL client for OS X
11–20 of 62 posts
Re: Postico – A modern PostgreSQL client for OS X
#12I'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…
Check out Datazenit[0]
Re: Postico – A modern PostgreSQL client for OS X
#13I 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 like the fact that it's a native app. But without highlighting and autocomplete it's not very interesting for me, I'm SQL guy.
Re: Postico – A modern PostgreSQL client for OS X
#14Is there a way to get rid of the blank space between rows in the structure view? Besides being a poor use of space, it has twice as many horizontal lines as necessary: visual clutter. The content view with single thin separating lines is much preferred.
Re: Postico – A modern PostgreSQL client for OS X
#15I 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…
Likewise, I'm somewhat excited by what 0xDBE, the upcoming database "IDE" for DBAs and devs, from JetBrains...
Re: Postico – A modern PostgreSQL client for OS X
#16Is there a way to get rid of the blank space between rows in the structure view? Besides being a poor use of space, it has twice as many horizontal lines as necessary: visual clutter. The content view with single thin separating lines is much preferred.
You can type column comments in the blank space.
Re: Postico – A modern PostgreSQL client for OS X
#17I 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.
Re: Postico – A modern PostgreSQL client for OS X
#18Could 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 seconds), and you can find more keybindings by looking throught the menus.
5. The history search totally makes sense and I just haven't gotten around to implement it yet.
Re: Postico – A modern PostgreSQL client for OS X
#19Nice! Finally a good client
Re: Postico – A modern PostgreSQL client for OS X
#20I 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…
Yep, any varient of jetbrains with their awesome sql +++ support beats this and most others hands down. Especially if you're someone who'd actually use this for real work. Like a statistician/analyst