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

41–50 of 62 posts

Re: Postico – A modern PostgreSQL client for OS X

#41

Post by cmpb »

jakobegger wrote: post #33
bdcravens wrote: post #32

For the same price, you can get Navicat Essentials, which has syntax highlighting, import/export, and more. If you want to spend $160, you get the version that can talk to MySQL, SQL Server, SQLite, and more.

I'm a single dev; I can't compete with Navicat on features. But I can try to make an app that does a limited set of things really well. For example, I'm really proud of the table view in Postico. It's really easy to filter rows by keywords. You can edit multiple rows at once in the sidebar. You can rearrange columns, filters and sort order are remembered automatically... If you have a workflow where you don't often u…

I see what you're saying about the table filtering! Very slick. Dragging columns around feels very fluid. Great work, I think I might have to go ahead and purchase this one!

Re: Postico – A modern PostgreSQL client for OS X

#42

Post by ClayM »

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…

Yep, started using it recently. Stupid name, great product. Way better than I expected

Re: Postico – A modern PostgreSQL client for OS X

#44

Post by buckbova »

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 was using the database navigator plugin for a while for webstorm. It worked okay.

http://plugins.jetbrains.com/category/index?pr=webStorm&cate...

So far so good on 0xDBE. I was happy to see this come out.

https://www.jetbrains.com/dbe/eap/

Re: Postico – A modern PostgreSQL client for OS X

#45

Post by leesalminen »

cmpb wrote: post #41
jakobegger wrote: post #33

Earlier quoted context omitted.

I'm a single dev; I can't compete with Navicat on features. But I can try to make an app that does a limited set of things really well. For example, I'm really proud of the table view in Postico. It's really easy to filter rows by keywords. You can edit multiple rows at once in the sidebar. You can rearrange columns, filters and sort order are remembered automatically... If you have a workflow where you don't often u…

I see what you're saying about the table filtering! Very slick. Dragging columns around feels very fluid. Great work, I think I might have to go ahead and purchase this one!

That was the main sell for me. Purchased!

Re: Postico – A modern PostgreSQL client for OS X

#46

Post by sfaxon »

jakobegger wrote: post #33
bdcravens wrote: post #32

For the same price, you can get Navicat Essentials, which has syntax highlighting, import/export, and more. If you want to spend $160, you get the version that can talk to MySQL, SQL Server, SQLite, and more.

I'm a single dev; I can't compete with Navicat on features. But I can try to make an app that does a limited set of things really well. For example, I'm really proud of the table view in Postico. It's really easy to filter rows by keywords. You can edit multiple rows at once in the sidebar. You can rearrange columns, filters and sort order are remembered automatically... If you have a workflow where you don't often u…

I've been using Navicat Essentials for years and I still get frustrated with it on a regular basis. Only after bdcravens' comment did I find the section of the UI that allows syntax highlighting. Years ago, when I first tried, Navicat failed to import a standard pg_dump file so I've given up on it for import/export. Which is fine, I prefer the command line most of the time for things like that anyway.

I gave PGAdmin a shot, but it does not support left-right scrolling from a Magic Mouse. Getting to table views is cumbersome, 5-6 whole clicks. On the up side it does visualize explain queries really well. But 99% of the time I just want to browse some data to see what data is there.

I've spent 3-4 hours using Postico today and really like it. I can see it being really useful in my normal workflow. I can move data from the command line, browse tables and make quick updates in Postico and if I really need to dig into a query use PGAdmin. Syntax highlight would be nice, but I've been without it for so long (due to my own inability to find a button in Navicat) that it's a nice to have at this point.

Keep up the great work! I do hope there is a way to transfer my license over to the AppStore version when it comes along.

Re: Postico – A modern PostgreSQL client for OS X

#49

Post by khebbie »

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 recently discovered pgcli, it is pretty slick
Post reply on HN