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

51–60 of 62 posts

Re: Postico – A modern PostgreSQL client for OS X

#52

Post by jdhendrickson »

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…

Casting another vote for 2 and 5. Thanks for all your hard work!

Re: Postico – A modern PostgreSQL client for OS X

#54

Post by mangecoeur »

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 use the PyCharm plugin. It doesn't look like much to start with but now i've used it a bit it's actually one of the best DB clients i've ever used, especially for editing SQL queries thanks to great sytnax highlighting and completions.

Re: Postico – A modern PostgreSQL client for OS X

#57

Post by domoarevil »

In 15 years of database centric roles, it's certainly the most beautiful SQL client I have used, so bravo for that. (Currently in Sybase hell, so switching to playing with this when I get home is a real joy.) I don't use Postgres outside of that of a hobbyist, but I'll be certainly trying it out where I can. Thanks!

Re: Postico – A modern PostgreSQL client for OS X

#58

Post by RommeDeSerieux »

domoarevil wrote: post #57

In 15 years of database centric roles, it's certainly the most beautiful SQL client I have used, so bravo for that. (Currently in Sybase hell, so switching to playing with this when I get home is a real joy.) I don't use Postgres outside of that of a hobbyist, but I'll be certainly trying it out where I can. Thanks!

What's wrong with Sybase? Quite a powerful database.

Re: Postico – A modern PostgreSQL client for OS X

#59

Post by rotten »

I was underwhelmed by Postico when I tried it. On the other hand, I've been underwhelmed by pretty much every one of these tools over the past few years.

Some minor complaints about Postico:

1) Most of the time I am not changing ddl. Postico over emphasizes the infrequent tasks and under emphasizes the things I do every day.

2) Everything I do should be automatically logged, and not something that I have to explicitly save.

3) Syntax highlighting would be nice. It has been around in other SQL tools for many years. Why would a new tool not include it?

4) It is a common task for me to compare the schema and data between two databases. This tool didn't seem to make that any easier.

5) I also will log in with various identities and different times. After you have a dozen or so databases and two or three users on each - this did not strike me as a tool that would let me organize them very well.

6) It still doesn't see Foreign tables. None of the tools I've tried allow for visual interaction with foreign tables. A new tool should definitely include support for it.

7) In spite of its emphasis on table structure, it doesn't seem to show indexes, comments, size, dependencies, ownership, and other details that are on the table besides just the columns. (that I could find)

Without having the time to write my own, I'm sticking with the legacy and really feeling old, SQLExplorer (based on Eclipse). It gives me most of the features I need (and for multiple data sources, not just PG). I would love to find something more modern and better, so I'll keep looking...

Post reply on HN