Postico App Icon Postico 2

Changelog

Stable Builds Development Builds
2.1.1 Build 9692 2024-07-05 postico-9692.dmg 536348 launches 436 crashes 0.08% crash rate
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)
2.1 Build 9682 2024-02-26 postico-9682.dmg 843955 launches 449 crashes 0.05% crash rate
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
2.0.5 Build 9661 2023-10-20 postico-9661.dmg 715298 launches 431 crashes 0.06% crash rate
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!
2.0.4 Build 9636 2023-07-10 postico-9636.dmg 502330 launches 1106 crashes 0.22% crash rate
- 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
2.0.3 Build 9628 2023-06-08 postico-9628.dmg 112615 launches 87 crashes 0.08% crash rate
- 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
2.0.2 Build 9622 2023-05-15 postico-9622.dmg 83149 launches 75 crashes 0.09% crash rate
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
2.0.1 Build 9593 2023-03-17 postico-9593.dmg 192489 launches 86 crashes 0.04% crash rate
- 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
2.0 Build 9584 2023-03-13 postico-9584.dmg 17993 launches 20 crashes 0.11% crash rate
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
2.0 RC 6 Build 9481 2022-10-31 postico-9481.dmg 300729 launches 253 crashes 0.08% crash rate
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.
2.0 RC 5 Build 9469 2022-10-19 postico-9469.dmg 6707 launches 2 crashes 0.03% crash rate
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
2.0 RC 4 Build 9404 2022-04-29 postico-9404.dmg 1194 launches 17 crashes 1.42% crash rate
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
2.0 RC 3 Build 9387 2022-03-17 postico-9387.dmg 5 launches
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
2.0 RC 2 Build 9383 2022-03-02 postico-9383.dmg
Fixed a regression in RC 1 where Postico crashed after creating a new database, refreshing a materialized view, reindexing, truncating or vaccuuming a table.
2.0 RC 1 Build 9348 2022-02-18 postico-9348.dmg
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
2.0 Alpha 2 Build 9170 2021-12-10 postico-9170.zip
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
2.0 Alpha Build 9114 2021-12-01 postico-9114.zip
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.