August 14, 2015
Postico v0.26
-
More responsive user interface
- When designing new tables, they appear in the sidebar in italic until they are saved
- Deleting objects now removes them from the sidebar and the main window without needing to refresh #3
- Truncating a table refreshes it and no longer shows a modal dialog #4 #20
- Table view automatically refreshes after making changes to table structure
- Postico now remembers settings like column order when renaming tables
- Improved data entry for enums, booleans, and foreign keys
- Tweaked the design of the table view. The header is now light gray and single-line, and I've added vertical grid lines. #26
- Views now load constraints from their source tables, allowing foreign key selection in editable views.
- Fixed layout issues on El Capitan
- Fixed a crash when editing table structure with a check constraint that is not related to any columns. #30
- Improve performance for tables containing very long text by truncating tooltips.
- Fixed an issue where toggling the right sidebar didn't work.
- Skip count query when number of rows can be inferred.
- Added an option in preferences to disable forced sorting (improves performance for large tables without indices) #16
- Check constraints are now syntax-highlighted.
- Server Nickname is now displayed correctly in breadcrumb navigation
- Added reload button to the default toolbar #45
- Fixed a problem where changing the "Rows per page" preference did not take effect. #35
- Filters are now displayed at the top #27
- Changed default column type on Redshift from SERIAL (unsupported) to INTEGER
- The status display now shows "Transaction active" when a transaction is in progress.
- Postico now reloads the full row after making changes.
July 9, 2015
Postico v0.25
- Open new windows from the dock menu. #5
- Open connections now have a "New Window" button in the favorites window #9
- Quickly comment (and uncomment) code in the SQL Query View. Hit Cmd-/ to comment selected lines. Or use Cmd-Alt-/ to comment a block of text. #10
- Added a "Copy Column Name" menu item to the table view header context menu #13
- Previously open windows are now restored when app is restarted. (related to #14)
- Add support for deleting databases #23
- Update to PostgreSQL 9.3.9
- Update to libssh2 1.6.0
- Update to OpenSSL 1.0.2d – Fixes CVE-2015-1793
- Fixed button styling in SQL Query View on OS X El Capitan
- You can now select and copy error messages in the Favorites window
- Added a workaround for a bug in NSTableView where only the first 32000 characters are selected when starting to edit a cell with more that 32000 characters.
June 26, 2015
Postico v0.24
-
Filter Tables in the sidebar
Another feature that many people have requested. With convenient keyboard shortcuts: Press Cmd-Shift-F and type a few characters to filter tables. Then select a table using up and down arrow keys. - Syntax highlighting is now enabled for the view definition text field, for SQL expression filters, and for the SQL preview popover.
- Fixed back tab behavior when full keyboard access is turned on. #1
- Hitting escape in text fields now discards changes and aborts editing instead of invoking auto-complete. #2
- Toast schemas and temporary schemas from other connections are now hidden in the sidebar. Additionally, there are now two separate settings for expanding the public schema and hiding system tables. Confusingly, these two settings used to be combined. #12
- Fixed a crash when the server sends an error message containing invalid characters.
- Return now commits changes in the sidebar. To insert a newline, type alt-return instead.
- Fixed a problem were license files failed to validate (caused by a bug in Aquatic Prime).
- Fixed a crash when opening a table with an exclusion constraint on a function.
- Fixed a drawing bug on OS X 10.11.
June 12, 2015
Postico v0.23
- Fixed a bug where DELETE TABLE, TRUNCATE TABLE did not work on OS X 10.9 10.8.
- Updated OpenSSL to version 1.0.2b
- Updated libpq to version 9.3.8
May 22, 2015
Postico v0.22
- Fixed a crash when typing three consecutive single quotes into the query text field.
- Fixed a crash when typing 'u' into an empty query text field.
- Added support for syntax highlighting on Redshift and older versions of PostgreSQL.
- Fixed a problem where characters that can't be displayed using Menlo were hidden in the query text view (eg. Chinese characters, Emojis)
- It is now possible to provide a nickname parameter when using postgres:// URLs.
- Allow deleting schemas from the sidebar context menu.
- Customize CSV export format.
May 19, 2015
Postico v0.21
-
Syntax Highlighting
Postico now includes a custom made syntax highlighter that was designed from the ground up for PostgreSQL. It supports all language features (including peculiarities like nested C-style comments or dollar quoted string constants). The high efficiency parser automatically runs in the background as you type and can handle even very large queries. -
Smart Text Selection
Double-click quotes to select the entire quoted string. Also works for comments – just double click the start or end markers. - Line Numbers
- Improved Connection Handling
- You can now forcefully disconnect if the connection was lost without closing the window by pressing ⌘⌥.
- Canceling the current query no longer freezes the UI if the connection was lost
- Connections are disconnected more reliably when windows are closed, any still running queries are cancelled
- Separate windows now use separate connections
- It is now possible to cancel commands when using SSH tunnels
- SSH tunnels now use a random unused local port
- More reliable caching of table structure
- Fixed a bug where Postico would hang when typing Shift-Tab (to reduce indentation) when the cursor was at the end of SQL text view.
- Improved performance when executing thousands of queries at once
- Fixed a problem where large integers were converted to double when entering data
- Added command to context menu in table view for inserting special values (NULL, DEFAULT, empty strings)
- Improved responsiveness when connecting to a database with 50000 tables
March 30, 2015
Postico v0.20
- Sidebar automatically expands schema/database to show current table
- Small performance improvements for SSH tunnels
- Fixed compatibility issue with OS X 10.8 and 10.9 (eg. TRUNCATE command did not work)
- Fixed a compatibility issue with PostgreSQL 8.0 and Amazon Redshift
- Updated to OpenSSL 1.0.2a
- The favorites window now displays the app version again
March 12, 2015
Postico v0.19
- Display table owner in the list view
- Escape key now works as expected when a table cell in the query view is selected
- Connection status messages in the favorites window no longer overflow
- New connections now open with your most recently used view mode (icon view or list view)
- Fixed a problem where view structure was incorrectly marked as having changes
- Improved autosizing behavior when double clicking separator between column headers.
- Display prettier SQL for default expressions and check constraints.
- Started to write documentation.
- Updated to libssh2 version 1.5.0
March 06, 2015
Postico v0.18
- Improved Reconnection Behavior
- Navigation Popup in window titlebar replaced with breadcrumb buttons
- Status display now full width
- Allow moving window when starting drag on status display
- Restored ‘Copy Name’ command in context menu
- Query View no longer cleared when reloading
- Shift-Tab now un-indents even when no text is selected
- Fixed ‘Copy Cell’ command in context menu
- Fixed database view on PostgreSQL 8.3 and earlier
- Upgrade libpq to 9.3.6; OpenSSL to 1.0.1l
February 2015
Postico – changes from PG Commander
-
All new design — optimized for Yosemite
I have simplified and completely redesigned PG Commander to take full advantage of Yosemite's new design language. The new design degrades gracefully and also looks great on older versions of OS X. -
Table Structure Editor
The most requested feature in PG Commander is finally here!- Rename tables, change schema, change tablespace
- Rename columns, add columns, remove columns
- Change column type and default value
- Add & remove column constraints (Primary Key, Unique, Check, Not Null, Foreign Key)
- Add comments to tables, columns, and individual constraints
-
Table Contents View
- Inline Editor: double click cell to edit
- Batch editing: insert, update, delete multiple rows in a single transaction
- Update views
- Sanity check: PG Commander checks the number of affected rows before committing
- Row detail view now in the sidebar
- Update many rows at once with the sidebar
- Vastly improved scrolling performance
-
SQL Query View
I have completely replaced the SQL Terminal with the all new SQL Query View inspired by Sequel Pro. I thought that the SQL terminal was a good idea, but it had a lot of usability issues. For example, a common complaint from customers was that controls moved around. Also, the terminal had unfixable performance issues.- All new design & improved performance
- Support for large results (more than a million rows)
- Support for long SQL queries (100.000 lines or more)
- Query history popup: browse recent queries, clear individual queries from history
-
Status Display
There is now a status display in the title bar. It shows what query is currently executing. When idle, it shows which database you are connected to, and the server version. -
Cancel command
The keyboard shortcut ⌘. now aborts the current query. -
Improved Reload behavior
Cached data is now purged more reliably when reloading. The terminal is no longer cleared when you reload. -
Improved change tracking
PG Commander is now more reliable when you navigate away from a view with unsaved changes, eg. when using the back button. -
New Sidebar Icons
Updated to a flatter look. Schemas now have a folder icon. - Table column titles now span multiple lines when there isn't enough space to show them in a single line
- Added a preference to require confirmation before connecting to SSL servers with valid, but unknown certificates
- Added a command to truncate tables.