Re:Why old-school PostgreSQL is so hip again
by enkrs on Monday December 11, 2017 @01:30PM
(#15899116)
I can answer this, as I purchased Postico for our team just today (just out of gratitude really, as the free version is good enough)
Tunnelling via SSH works great, but you do have to provide and save your ssh key password in Postico, because it does not use ssh-agent.
Lots of great features and small updates here and there: it was updated with touch bar support quite quickly. A killer feature is Ctrl+P fuzzy search for table names in database.
It's great for getting query data out of your db quickly or just browsing around. Ok to add the odd column here and there. However managing roles and permissions seems to be out of scope.
Re:Why old-school PostgreSQL is so hip again
by newmanships on Monday December 11, 2017 @01:01PM
(#15898825)
Not the op but connecting through SSH works great in my experience and is very straight forward in the UI. I feel like updates are pretty frequent as well. I also love that it saves all my queries unlike psequel.
Could you share some user experiences, like how often you get updates, and the start guide has a 'Connecting to a remote PostgreSQL server via SSH' section, without content yet, does tunnelling via SSH work nice/as expected?