Developer: Jakob Egger
Mac Platform: Intel
OS Version: OS X 10.9 or later
Processor type(s) & speed: 64-bit processor
Includes: Pre-K’ed (TNT)
Web Site: http://jabakobob.net
Aims to make working with PostgreSQL databases seem a little simpler with the help of its collection of intuitive tools and a user-friendly interface
PostgreSQL is one of the most powerful and comprehensive database management systems out there, therefore working with it is not as easy as it may seem.
Simple yet powerful PostgreSQL database manager for the Mac
Postico is a streamlined and efficient PostgreSQL database manager that aims to make working with Postgres to be as simple as possible via an intuitive native OS X interface.
As is the case with many application of this kind, PostgreSQL’s user interface is quite straightforward: a top toolbar, a preview and editing panel in the middle of its main window, and a bottom toolbar. Featuring a patched version of Libpq 9.3.4, Postico can connect to servers that use PostgreSQL 8.0, 8.4, 9.1, 9.2, 9.3, 9.4, and Amazon Redshift.
Makes it easy for you to design and edit PostgreSQL databases
Once you have connected to a local PostgreSQL database, you can easily filter rows, sort them, rearrange columns, examine long text or images in the sidebar, and edit rows, as well as change multiple rows.
Furthermore, Postico enables you to add and remove, change their types, and to modify tables so that you can be sure your database’s structure is as you want it. As far as data analysis is concerned, Postico makes this possible with the help of common table expressions, recursive queries, filter aggregates, and window functions.
Well thought out OS X application that helps you manage your databases
As added benefits, Postico comes with support for both SSL and SSH encryption systems and keeps all your passwords stored safely in the keychain system.
Taking all things into consideration, Postico is a dependable and efficient database manager that, in many respects, manages to make the work with PostgreSQL a little more comfortable for both beginner and experienced users alike.
What’s new in Postico 1.3.3
April 5th, 2018
- Added support for late binding views on Amazon Redshift #493
- Fixed an autolayout bug on macOS 10.10 in the preferences window #494
- 2.75x faster SQL parsing
- Better notifications: Clicking a "Query Done" notification now shows the query that was completed. Also, Postico no longer creates notifications when the query is in the foreground. #342
- Security: Postico now ensures that other apps cannot use its SSH Tunnel.
- The text editor now has improved word boundary detection when using schema qualified identifiers (eg. when using option + arrow key) #96
- Support for LISTEN / NOTIFY #496
- Support for using three finger swipe gestures to go back / forward (when enabled in system preferences) #468
- Fixed a crash when using the context menu in the sidebar #521
- Fixed incorrect tab width in SQL text view that occurred with some fonts (eg. Monaco)
- Fixed an issue where SQL text fields "captured" the tab key #465
- Don't abort editing text fields when pressing ⌘. or F5
- Pressing Esc when editing filters no longer removes the filter (it just cancels editing instead)
- Cycling through foreign key fields in the sidebar now works #500
Improvements for autocomplete:
- tab completion beeps a lot less (eg. if multiple completions are possible they are shown right away) #513
- typing a literal tab character is now possible after using tab completion / autocomplete #491
- Pressing ⌥⇥ now always inserts a literal tab (doesn't trigger tab completion any more)
- Don't trigger autocomplete when pressing ⌘.
- Fixed placement of the autocomplete window when the cursor is near the edge of the screen
- Many minor bug fixes
We've made some improvements with regard to connection URL (like postgres://example.com):
- You can now paste URLs into the favorites window #510
- Postico now ignores whitespace when parsing URLs #510
- It's no longer required to include user name & database name when opening URLs if you already have a matching favorite.
- You can use the scheme postico instead of postgresql if you want to open Postico specifically, eg. open postico://example.com