TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Postico: A Modern PostgreSQL Client for OS X

41 点作者 daviducolo将近 10 年前

12 条评论

leetrout将近 10 年前
Previously discussed <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=9075827" rel="nofollow">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=9075827</a> around the time it launched.
msluyter将近 10 年前
It&#x27;s improved since the last time I looked at it, so good work. A couple of issues I ran into:<p>1) if you have an empty blank line after a query, you get a syntax error<p>2) an option to expand column widths to match column name would be nice.<p>3) Perhaps I&#x27;m not getting it, but for ad hoc sql queries, I&#x27;d prefer a free form text window a la Toad or Squirrel, where the query that the cursor is on is the current query to be executed (via key binding). I switch back and forth between queries a lot, and it&#x27;s useful to be able view several of them simultaneously. The current interface is feels way too limited and clumsy, imho. Being able to go forward&#x2F;back in history is nice (though I need to be able to rebind the shortcut, as ctrl-cmd-left&#x2F;ctrl-cmd-right are both bound to Spectacle), but not sufficient, imho. You need to be able to view multiple queries at a time.<p>4) An optional &#x27;auto-limit&#x27; is an awesome feature of squirrel that allows you to do all sorts of queries quickly without having to always type &quot;limit 1&quot; or whatnot. I had forgotten how much I had relied on it until I tried using this and kept accidentally getting giant result sets.<p>5) Another nice to have (also in Squirrel) - autocomplete.<p>6) If you could pull up and instasearch the query history with like cmd-P (like sublime or atom) or something that would be amazing.<p>7) Essential: allow user to remap&#x2F;redefine keyboard shortcuts.<p>Keep going! If one day this is sufficient to supplant Squirrel then I&#x27;ll definitely buy it.
hankinsoft将近 10 年前
You could also try SQLPro for Postgres <a href="http:&#x2F;&#x2F;hankinsoft.com&#x2F;SQLProPostgres&#x2F;" rel="nofollow">http:&#x2F;&#x2F;hankinsoft.com&#x2F;SQLProPostgres&#x2F;</a><p>There is a good review available at <a href="https:&#x2F;&#x2F;www.compose.io&#x2F;articles&#x2F;tooltime-sqlpro-for-postgres-and-keylord-for-redis&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.compose.io&#x2F;articles&#x2F;tooltime-sqlpro-for-postgres...</a><p>Disclaimer that I am the dev.
评论 #9841393 未加载
评论 #9839364 未加载
评论 #9839274 未加载
评论 #9839388 未加载
cfeduke将近 10 年前
I nearly bought this when it launched due to how frustrated I get with pgAdmin.<p>As other posters noted its missing a lot of features. I knew my frustrations would not be solved.<p>I use IntelliJ&#x27;s database stuff instead, which I &quot;discovered&quot; as a result for my hunt for <i>the</i> PGSQL admin tool after Postico&#x27;s announcement. (Until that point I had largely avoided IDE database stuff because they often try to make you do insane things, like use the mouse to design tables.) When I considered the price of purchase for a stand alone PGSQL admin tool and an IntelliJ personal license [including yearly renewals] it became pretty clear what the correct choice for me was.<p>In terms of the things I need to do as a software engineer in regards to PGSQL, IntelliJ has everything I need; plus in recent versions IdeaVIM works more reliably.
评论 #9839550 未加载
评论 #9839484 未加载
mendozao将近 10 年前
My favorite postgres gui by far has been Psequel.<p><a href="http:&#x2F;&#x2F;www.psequel.com&#x2F;" rel="nofollow">http:&#x2F;&#x2F;www.psequel.com&#x2F;</a>
eddieroger将近 10 年前
It&#x27;s very pretty, but I can&#x27;t seem to find how to look at and&#x2F;or modify functions, which are a pretty big part of my current setup. Lots of promise though, but I&#x27;m not sure I&#x27;d drop this much money on it&#x27;s current feature set based on my use, especially when Navicat Essentials for Postgres is the same price.
jordigg将近 10 年前
Been using it for some months already and love it. I&#x27;m missing some features like being able to dump or upload an entire DB backup from a file (have to use another app for that). Hope I can get all functionality in one place soon.<p>UI is great and really easy to use. I really recommend it to anyone using PostgreSQL as DB.<p>Great job from Jakob, the developer behind it.
评论 #9838956 未加载
hit8run将近 10 年前
I really like <a href="http:&#x2F;&#x2F;www.sequelpro.com&#x2F;" rel="nofollow">http:&#x2F;&#x2F;www.sequelpro.com&#x2F;</a> for mysql. The lack of a good admin gui for postgres is one reason I preferred mysql over postgres.
评论 #9839328 未加载
bradleyankrom将近 10 年前
I seem to recall there being talk about Sequel Pro adding support for Postgres a while back. Anyone know if that&#x27;s still on the table?
eis将近 10 年前
Just gave it a try but it&#x27;s stuck in &quot;Opening connection to server...&quot; and never finishes. Doesn&#x27;t even seem to have any error log window or similar where I would be able to see what the issue is. Also has no timeout it seems.<p>Am using the SSH tunnel feature btw.
评论 #9840065 未加载
agopaul将近 10 年前
Looks good. Still, pg doesn&#x27;t have a client with a <i>good</i> graphical editor yet (to draw tables and their relationships between them).<p>On the other hand, MySQL has MySQL Workbench which works quite well, even if it has some bugs
swalsh将近 10 年前
I&#x27;m happy for this thread, before this I&#x27;ve just the standard Admin app, and it&#x27;s always been one of the worst parts of using Postgres.