Changelog

- 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

New Features: - Customizable tab layout in left sidebar - Copy as Markdown - Middle click opens item in new tab

Bugfixes: - Fixed a bug where Postico showed an error message after truncating multiple tables

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

Auto-Uppercase Keywords! We added a preference to Postico that allows you to auto-uppercase SQL Keywords.

Reduce padding in left sidebar

Fix layout glitches with RTL text

Fix a problem where the SQL editor scrolled erratically while entering quotes

Fix a crash when importing servers from Postico 1.x on macOS Monterey

Remove outdated docs bundled with the app

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.