Postico overview
Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about advanced features of PostgreSQL as you go along. Postico is an intuitive app for looking at data. Filter rows, sort them, rearrange columns. You can examine long text or images conveniently in the sidebar. Even related rows from referenced tables are shown. Edit rows directly, or use the sidebar, a great choice for long text. You can even change multiple rows at once. Batch saving (with SQL preview) lets you commit changes to multiple rows in a single transaction. Postico sports a query view inspired by Sequel Pro, the popular MySQL client. But with sophisticated features like multiple query results, Postico goes even beyond its role model.
What’s new in version 2.0.5
Updated on Jan 10 2024
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!
Information
App requirements
- Intel 64
- Apple Silicon
- macOS 10.15 or later
(0 Reviews of )
Comments
User Ratings
