New Features and changes:
- Quick Filter Actions: You can now right-click a value to show only rows with the same value, or to hide rows with that value
- Added "Copy Name with Schema" command to sidebar context menu
- Postico no longer uses escape string literals (like E'...') when copying INSERT statement
Bug Fixes and improvements:
- Fixed a problem with adding/removing files from the SQL query sidebar
- Upgraded to Swift 6 and refactored some code to use modern Swift Concurrency
- Fixed a lot of crashes, including a few compatibility issues with macOS 26 Beta
- New version of the Autoupdate framework (Sparkle)
Bug fixes:
- prevent a crash when moving the mouse over "is in list" filter on macOS Sequoia on Intel Macs
- "bytea" columns: Replaced the "Crockford" style with "ULID". The ULID style is also a Crockford encoding, but the bits are right-aligned to match ULIDs
- fixed a rare crash that could happen when dragging files on the Postico window
- improved error reporting and minor fixes
Bug Fixes:
- fixed a bug where Postico failed to import CSV files with lines > 1MB
- prevent the query editor from disappearing by setting a minimum height
New Feature:
- added an Internet Access Policy (used by the firewall app Little Snitch)
New Features:
- Added a new setting that allows you to display binary values ("bytea") as Hex, Base64, or Crockford's Base32
- Multi-column sort! Sometimes a single column just isn't enough. Postico can now sort tables by multiple columns.
Just hold down the option key when clicking the column to sort.
- Sort NULLSs first or last. Right click the column header and make your choice.
- Preconnect Shell Script: Postico can now run a shell script before connecting to the database.
This makes it a lot easier to use identity management software like AWS IAM or SSO solutions.
- More ways to organise your queries: Postico now supports symbolic links and aliases.
If necessary, you can grant Postico permissions to additional folders in the new security settings pane.
Small Improvements:
- Added a command to copy all values in a column
- Added a way to add a device name when activating multi-user licenses
- Add support for "nulls not distinct" indics
- Postico now has a command for generating UUIDv7 values
- Row counts are now formatted according to system settings (eg. 1,000,000 rows instead of 1000000 rows)
- Escape key no longer ends full screen mode
- Better support for functions & stored procdedures on Amazon Redshift
Bug Fixes:
- Fixed a few crashes eg. when refreshing while the mouse is inside the "is in list" filter text field
- Fixed bug when adding columns with comments
- Better error messages when autocomplete fails
Bug Fixes:
- Fixed a crash on macOS 14 when clicking the database in the breadcrumb control
- Fixed a bug where "Custom SQL" filters sometimes did not work
- Fixed a glitch when displaying error messages
- Fixed a crash when reading a damaged server properties file
Improvements for SSH Tunnels:
- Fixed a problem where Postico incorrectly handled closed SSH channels, leading to an issue where the SSH server would sometimes disconnect after a query was cancelled
- Improved SSH Tunnel error reporting
- Added support for private keys encrypted with AES-GCM methods
Fixed a few memory leaks:
- Postico now closes all connections used by a window when clicking the "disconnect" button
- Fixed retain cycles that lead to connections staying open even after the window was closed
- Fixed a memory leak during CSV import: Temporary memory was freed only at the end of the import, which would cause Postico to run out of memory when importing large files.
Postico can now read passwords from the ~/.pgpass file. For more information, see the PostgreSQL documentation.
I've also updated some of the libraries used by Postico 2: OpenSSL 1.1.1u, libssh2 1.11.0, libpq 14.8
And finally, Postico 2 now remembers column widths in table view!
- added a workaround for a bug where macOS keeps showing keychain dialogs
- add "delete" and "share" buttons for servers
- CMD-R no longer clears query results
- Fixed a bug where Postico said "The server returned an unexpected query result" when creating a table with comments
- Reduce unnecessary autosaves (this might have caused an issue where Postico suddenly reverts changes in the SQL query editor)
- Add documentation about common errors when activating a Postico license fails
New Features:
- added a new "is in list" filter
- rows marked for deletion can be "undeleted"
Bugfixes:
- fixed a bug where exported CSV files had an incorrect file name
- fixed a possible single byte buffer overflow when parsing NUMERIC columns
- fix size of some buttons on macOS Ventura
- update bundled libraries: OpenSSL 1.1.1t, libpq 14.7, libssh2 0809c4b
- fix a potential crash when downgrading from a future version with more filter types
Bugfixes:
- Fixed an issue where the "new tab" button opened a new window instead
- Hidden columns are now ignored when copy/pasting rows
- The dialog for picking SSH keys now shows hidden files and starts in ~/.ssh
- Fixed a rare crash when importing servers from Postico 1.5
- Postico is now more responsive when loading libraries from slow network drives
- A few minor bug fixes that are difficult to explain in a bullet point
New:
- Cockroach Serverless and Neon.tech servers now have a custom icon
Bugfixes:
- Fixed a bug where opening SSH Tunnels with aes256-cbc encrypted private keys didn't work
- Fixed a bug where the "Go To Queries" command would sometimes reopen a connection to a different recently used server
- Fixed a bug where Postico sometimes used 100% CPU after an SSH tunnel was closed
- Use Find Bar instead of Find Panel in the SQL Query Editor because there is an unfixed macOS bug that causes apps using Find Panels to crash
This release is the very very last one that supports macOS 10.13 and 10.14. Future releases will require macOS 10.15 or later.
New Features:
- SSH tunnels now support rsa-sha2-256 and rsa-sha2-512 authentication
- Update bundled library versions: libpq to 14.4, OpenSSL to 1.1.1q
This adds support for SNI which improves compatibility with cloud services like Neon.
Minor Improvements:
- Suggest filename with timestamp when exporting query results
- More detailed error message when connecting to SSH server fails
Bugfixes:
- Fixed a bug where the JSON editor was blank for rows pasted from the clipboard
- Fix a bug where the red strike-through line was not shown when deleting a NOT NULL or PRIMARY constraint
- Fix a bug when creating temp tables on CockroachDB (currently an experimental feature)
This will be the last build of Postico 2 that is compatible with macOS 10.13 and macOS 10.14. The next build will require at least macOS 10.15
New Feature:
- Automatic deployment of Postico licenses for managed Macs
Fixed:
- Fixed a problem where Postico could not save passwords in the keychain
- Fixed a crash in the SQL parser
- Fixed blurry icons in the toolbar
- Fixed a performance issue when loading tables with large jsonb values
- Fixed a bug in the function editor on PostgreSQL 14 or newer
Fixed a regression in RC 1 where Postico crashed after creating a new database, refreshing a materialized view, reindexing, truncating or vaccuuming a table.
New Features:
- Added a button to create a new server from a connection URL…
- Allow changing font size of left sidebar
- Automatically Expand Query Search Results in the Sidebar
- Autocomplete now also searches in "pg_temp" alias
- SQL preview popup supports find via CMD+F
- JSON popup supports find via CMD+F
Compatibility Improvements:
- Cockroach v21.2 support
- Support for connection parameter 'options'
- Support for importing encrypted Postico 1.x favorites
Fixes:
- Fixed a permission error in the query editor
- Fixed a bug where saving a temp table can lead to a broken UI state
- Fixed a bug where the table filter button did not hide the filter view
- Fixed a bug where clicking the reload button in the sidebar did not work
- Fixed loading table filter files
- Fixed rare crash when source table of view was changed
- Fixed crash when creating new tab in readonly libraries
- Fixed crash when reloading connection
- Fixed crash when opening new tab from new table/function screen
- Fixed crash when clicking remove library button in library preferences
- Fixed a rare crash when resizing the window
- Fixed a crash in the CSV Importer
- Table Filter no longer adds unnecessary % symbol
- Fix Preferences layout issue
Distribute app as disk image (DMG) instead of ZIP archive
Our first "stable" Release of Postico 2
Unlike the beta/development builds, stable builds don't expire after 6 weeks. You can now disable automatic updates and continue to use a outdated version as long as you want!
Stable builds no longer accept Postico 1.x license files. If you want to keep using Postico 2, please purchase an upgrade license.
Postico 2