Mac Platform: Intel
OS version: 10.9 or later
Processor type(s) & speed: 64 bit
RAM minimum: -
Video RAM: -
New in v0.28
You can now execute all queries with the keyboard command ⌥⌘↩︎ (behavior similar to Postico before version 0.27)
Fixed an issue where the Execute button became disabled (eg. after hitting ⌘A)
Fixed an issue where typing ⌘/ to uncomment lines didn't work
New in v0.27
System requirements raised to OS X 10.9. Postico wasn't as stable on 10.8 as I wanted it to be. Working around bugs in Mountain Lion and additional QA efforts for the legacy system would have required too much time that I'd rather spend on new features, considering the very low number of users.
Improved error handling during connection establishment. Postico was unreliable when restoring previously open windows in certain conditions. Problems occurred when the server did not support SSL, or when the SSH server required keyboard-interactive authentication. Connection establishment should now be much more reliable. Also, certificate warnings are now shown only once. #81
“Execute” (Cmd-Return) now executes only the current query #11
Improved query history
Filter the history to search for specific queries #74
Detail view shows the full query.
Clicking back/forward now replaces only the current query, or the selection.
Delete multiple queries from the history at once using the context menu.
SQL Preview popover is now bigger and scrolls.
Added support for displaying foreign tables.
Fixed a bug where a query displays no results when it is executed while a previous one is still running.
Improved button styling in SQL Query view in Yosemite (eg. cancel button is now visibly disabled).
Fixed display issues on El Capitan.
Postico now ignores unsupported SSH host key types in known_hosts #78
Fixed a crash when clicking the foreign key table button when multiple rows were selected.
Fixed a problem where strings were quoted incorrectly on Amazon Redshift #73
Fixed a problem where inserting rows failed on Amazon Redshift
Comments are now saved when adding a column to a table #79
Added new filters: “begins with”, “ends with”, and “like” #56
The breadcrumb control now also includes the schema of a table #32
Fixed display issues in the favorite window on OS X 10.9
Postico makes PostgreSQL approachable.
PostgreSQL is an absurdly powerful database, but there's no reason why using it should require an advanced degree in relational theory. Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike.
Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about advanced features of PostgreSQL as you go along.
Mac App Store: https://itunes.apple.com/us/app/postico/id1031280567