Softpedia >Mac >Utilities >Postico >  Changelog

Postico Changelog

What's new in Postico 2.1 Build 9684 Dev

Feb 26, 2024
  • Disable Asset Symbols
  • Caused warnings / build errors in Xcode 15.2
  • Fix a crash when clicking the header while the table was still loading

New in Postico 2.1 Build 9682 (Feb 26, 2024)

  • 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

New in Postico 2.1 Build 9681 Dev (Feb 14, 2024)

  • Fix a bug in the query editor where in some cases bytea values were not displayed in the correct format according to Postico settings
  • Fix a crash when exporting or copying large bytea values

New in Postico 2.1 Build 9680 Dev (Feb 6, 2024)

  • Added a workaround for a crash that occurs when using the "is in list" filter
  • This mysterious crash started appearing in September 2023. I was finally able to track it down to a memory error in NSTokenField / NSTokenAttachmentCell. While I can't fix Apple's code, I came up with a way to clean up the dangling pointers before they cause a crash.

New in Postico 2.1 Build 9679 Dev (Jan 25, 2024)

  • Fixed a bug where importing folders with multiple servers was not possible
  • Fix Typo

New in Postico 2.1 Build 9678 Dev (Jan 10, 2024)

  • Add support for foreign keys that reference partitioned tables
  • Don't show an error message when adding a column with a comment to a table

New in Postico 2.1 Build 9677 Dev (Dec 27, 2023)

  • Attempt to handle unknown function argument types in Redshift

New in Postico 2.1 Build 9676 Dev (Dec 24, 2023)

  • Improve support of functions and procedures on Amazon Redshift

New in Postico 2.1 Build 9675 Dev (Dec 23, 2023)

  • Fix a bug where a non-functioning window was displayed asking for a device name
  • Add support for indexes with NULLS NOT DISTINCT

New in Postico 2.1 Build 9674 Dev (Dec 20, 2023)

  • Add support for showing error details when loading autocomplete information fails
  • Format row counts using the default system number format

New in Postico 2.1 Build 9672 Dev (Dec 18, 2023)

  • Add support for providing computer name for multi-user licenses

New in Postico 2.1 Build 9671 Dev (Dec 15, 2023)

  • Prevent escape key from accidentally ending full screen mode

New in Postico 2.1 Build 9670 Dev (Dec 12, 2023)

  • Require holding ⌥ to sort by multiple columns

New in Postico 2.1 Build 9668 Dev (Nov 28, 2023)

  • Set default values for PGUSER, PGPORT and PGDATABASE when executing a pre-connect shell script
  • Enable word wrapping in shell script and startup query fields

New in Postico 2.1 Build 9667 Dev (Nov 25, 2023)

  • Add support for a Pre-Connect Shell Script

New in Postico 2.1 Build 9666 Dev (Nov 14, 2023)

  • Nicer error message when loading data was cancelled
  • Better sorting in the table view:
  • Sort with NULLS FIRST / NULLS LAST
  • Sort by multiple columns at the same time

New in Postico 2.1 Build 9664 Dev (Nov 14, 2023)

  • Repair support for NULL and DEFAULT values in bytea columns

New in Postico 2.1 Build 9662 Dev (Oct 24, 2023)

  • Enable secure restorable state to fix a crash during state restoration

New in Postico 2.0.5 Build 9661 (Oct 22, 2023)

  • 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.

New in Postico 2.1 Build 9660 Dev (Oct 20, 2023)

  • Fix a crash when clicking the database in the breadcrumb control. Unfortunately the progress indicator causes a crash on macOS 14 Sonoma, so I had to remove it.
  • Fix clipping issues when building against macOS 14 SDK
  • Adopt secure coding for saving/restoring navigation state for compatibility with macOS 14 SDK
  • Fix a bug where "Custom SQL" filters sometimes did not work
  • Fix a drawing bug in error popovers

New in Postico 2.1 Build 9659 Dev (Sep 19, 2023)

  • Fix Xcode warnings & enable dead code stripping

New in Postico 2.1 Build 9658 Dev (Sep 18, 2023)

  • Add support for aliases and symbolic links in the file sidebar
  • Added a new security section in Postico preferences. You can now give Postico permission to additional files and folders, which is useful if you use symbolic links.

New in Postico 2.1 Build 9655 Dev (Sep 10, 2023)

  • Suggest filename with timestamp when exporting query results
  • More detailed error message when connecting to SSH server fails

New in Postico 2.1 Build 9653 Dev (Sep 6, 2023)

  • Move "Copy Column Values" command to header context menu

New in Postico 2.0.4 Build 9636 (Jul 10, 2023)

  • 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

New in Postico 2.0.3 Build 9628 (Jun 8, 2023)

  • 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 in Postico 2.0.3 Build 9626 Dev (May 16, 2023)

  • Reduce unnecessary autosaves
  • This might cause an issue where Postico suddenly reverts changes in the SQL query editor

New in Postico 2.0.3 Build 9623 Dev (May 16, 2023)

  • Fixed a bug where Postico said "The server returned an unexpected query result" when creating a table with comments

New in Postico 2.0.2 Build 9622 (May 15, 2023)

  • 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

New in Postico 2.0.1 Build 9593 (Mar 20, 2023)

  • 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

New in Postico 2.0 Build 9584 (Mar 13, 2023)

  • 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

New in Postico 2.0 RC 6 (Oct 31, 2022)

  • 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

New in Postico 2.0 RC 5 (Oct 23, 2022)

  • 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)

New in Postico 2.0 RC 4 (Oct 23, 2022)

  • 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 in Postico 2.0 RC 3 (Oct 23, 2022)

  • 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

New in Postico 2.0 RC 2 (Oct 23, 2022)

  • 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 in Postico 2.0 RC 1 (Oct 23, 2022)

  • 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

New in Postico 2.0 Alpha 2 (Oct 23, 2022)

  • 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

New in Postico 1.5.21 (Jul 21, 2022)

  • SSH tunnels now support the rsa-sha2-256 and rsa-sha2-512 authentication methods
  • Add "Copy as Markdown" command
  • Middle-clicking opens an item in a new tab
  • Fixed compatibility issues with macOS 12
  • Fixed a bug when opening a new tab/window while creating a new table
  • Updated libpq to version 14
  • This means Postico now support SNI, which improves compatibility with cloud services like Neon
  • Improved compatibility with CockroachDB

New in Postico 1.5.20 (Nov 5, 2021)

  • Add support for generated columns
  • Postico now supports virtual columns and identity columns #492 #688 #778
  • Add support for EXCLUDE constraints in DDL view
  • Fixed the "Show/Hide Navigation Sidebar" command on macOS Big Sur
  • Ignore BOM at beginning of CSV files when importing
  • Allow updating tables with FLOAT4 columns and no primary key
  • Improved support for Greenplum version 6
  • Limit the length of error messages to avoid UI bugs
  • Fixed a layout glitch in the right sidebar
  • Fixed an issue where radio buttons in the VACUUM dialog were invisible
  • Fixed overflow menu that appears the window is too small to show all toolbar items
  • Show connection encryption badge only after connection is established
  • Fixed a rare crash when double-clicking items in the sidebar
  • Fixed a crash when Postico tries to show an error message on macOS 10.10
  • Fixed a few crashes that are hard to explain
  • New tabs are now always added at the end to work around a macOS bug when using full screen mode

New in Postico 1.5.19 (Jun 11, 2021)

  • Fixed a bug with CSV export #773
  • Fixed a crash when editing NUMERIC values in the sidebar
  • Fixed a bug where columns of type "money" were still sorted incorrectly in the query results table #771

New in Postico 1.5.18 (Jun 7, 2021)

  • Improved support for late binding views in Amazon Redshift
  • Triggering autocomplete via Escape now works in View editor
  • Fixed a bug where NUMERIC values were limited to 38 digits of precision #680
  • Copy as JSON no longer treats JSON and JSONB values as strings #448 #489
  • JSONB values are now pretty-printed by default in the right sidebar #82 #306 #570
  • Pretty printing JSON values no longer escapes forward slashes. #620
  • Fixed a bug where columns of type "money" were sorted incorrectly in the query results table #768
  • Fixed the "Filter…" command in the context menu of UUID columns #765
  • Some errors now have a "Show Details" button to make debugging easier
  • Double click sidebar items to expand them (alternative to clicking the little triangle) #769
  • Modal dialogs are now always attached to the top of the window (macOS 10.15 and earlier) #766

New in Postico 1.5.17 (Dec 22, 2020)

  • CSV Import now supports numbers in exponential notation (like "1.5e9") #746
  • Fix horizontal scrolling in table structure view
  • Fixed filtering boolean columns on older PostgreSQL versions
  • Fix a drawing bug that could cause Postico to hang on Big Sur
  • Table DDL no longer shows an error when tables have constraint triggers (But this bug fix does not add trigger support to DDL view)

New in Postico 1.5.16 (Nov 24, 2020)

  • Fixed a crash when sorting timestamp columns that contain NULL values
  • Fixed a bug that resulted in incorrect sort order when sorting numeric columns that contain NULL values #744
  • Fixed a layout bug in the foreign key popover where the "Open Table" button was not visible
  • Fixed a bug in the crash reporter that could cause Postico to crash again while reporting a crash PLCrashReporter #154
  • Fixed a crash when clicking on index properties on macOS 10.11 and earlier

New in Postico 1.5.15 (Nov 18, 2020)

  • Postico is now a universal binary with native code for Apple Silicon
  • Fixed autosizing of UUID, ENUM and Boolean columns #295
  • Postico now shows a dialog when the password is incorrect #655
  • When scrollbars are set to "Always visible" in System Preferences, Postico no longer auto-hides the vertical scrollbar when the content fits. While this looked cleaner, it unfortunately caused occasional hangs on macOS 10.15 or later.
  • Removed unnecessary horizontal scrollbar in table structure view
  • Fixed sorting of timestamp type columns in the query result table #684
  • We fixed lots of graphical issues on macOS Big Sur
  • Add a workaround for a bug in Big Sur where some TLS certificates can not be read.

New in Postico 1.5.14 (Jul 22, 2020)

  • Fixed some cosmetic bugs on macOS 11
  • Ask for confirmation when loading or restoring big query files which could lead to degraded performance
  • Fixed a number of crashes

New in Postico 1.5.13 (Jul 22, 2020)

  • Updated bundled version of OpenSSL
  • Fixed a crash when matching columns in the CSV Import panel
  • Fixed a crash when quickly duplicating & deleting rows
  • Fixed a crash when index expression could not be read
  • Fixed a crash after deleting the last object in the sidebar

New in Postico 1.5.12 (Jul 22, 2020)

  • Fixed a crash in the table structure view. #699

New in Postico 1.5.11 (Jul 22, 2020)

  • The password field is now immediately highlighted in the dialog prompting for the connection password.
  • DDL View: Fixed a bug where reserved keywords that were used as column / table names view were not quoted
  • Upgrade included libraries (OpenSSL 1.1.1d, libpq 10.12, and libssh2)

New in Postico 1.5.10 (Jul 22, 2020)

  • Fixed an embarassing bug where the "Save Changes" bar in the table structure editor did not appear.

New in Postico 1.5.9 (Jul 22, 2020)

  • Postico is now notarized to ensure compatibility with future versions of macOS.
  • We made history navigation (forward/backward) more responsive
  • Postico no longer calls has_column_privilege() on CockroachDB since it doesn't work #672
  • Improved handling of non-standard whitespace and fixed an issue when pasting code from VS Code #445
  • Fixed a few crashes:
  • Fixed a crash when sorting query results
  • Fixed a crash related to autocomplete
  • Fixed a crash when importing CSV files with many columns
  • Fixed a crash that sometimes occurred when displaying rows with bytea columns in the sidebar
  • CSV Export improvements #572 #638
  • Postico no longer consumes all available memory when exporting large tables
  • Postico now cleans up temporary files when an error occurs or the export is cancelled

New in Postico 1.5.8 (Jun 6, 2019)

  • Fixed an issue that caused failed or lost connections when connecting via SSH. #658

New in Postico 1.5.7 (Jun 6, 2019)

  • Fixed compatibility with PostgreSQL 12beta1
  • Updated OpenSSL to version 1.1.1b
  • Improved error reporting when TLS certificate validation fails.

New in Postico 1.5.6 (Jun 6, 2019)

  • Add support for SSH tunnels to unix domain sockets
  • Added keyboard shortcuts ⌘S for "Save Query…" and ⌘O for "Load Query…" #46
  • Fixed an issue where the text in the SQL editor disappeared
  • Fixed a bug where edited cells were not highlighted on macOS 10.12 and earlier
  • Fixed a bug where "Generate UUID" did not work
  • Fixed some UI bugs when creating temporary tables
  • The "Schema" popup button is now enabled when creating new tables on Amazon Redshift
  • Fixed an issue where postgresql+ssh:// type connection URLs were sometimes not parsed correctly
  • Postico now actually uses a provided uuid when creating favorites from a connection URL
  • And we fixed 8 crashes that are hard to describe

New in Postico 1.5.5 (Feb 13, 2019)

  • Fixed an issue where tabbing between buttons did not work in the certificate verification dialog when "Full Keyboard Access" is enabled
  • Better error reporting when an error occurs after selecting files (eg. SSH and TLS keys) #633
  • The status display in the window title bar is no longer tinted gray for colorless favorites, it shines in beautiful white again (or dark grey, if you prefer dark mode)
  • Fixed a lot of crashes:
  • when trying to uncomment lines in an empty SQL editor
  • when double clicking on an empty string constant in the SQL editor
  • when adding a new row after loading the table has failed
  • after cancelling CSV import
  • and a few more that are hard to describe

New in Postico 1.5.4 (Jan 26, 2019)

  • Fixed performance issues with the SQL editor (especially on macOS 10.13) #629
  • Hiding the sidebar now works again #617
  • We also fixed a number of crashes reported by the automatic crash reporter
  • CSV Import improvements:
  • Better error messages
  • Empty columns are no longer ignored #627
  • Fewer Crashes

New in Postico 1.5.3 (Dec 31, 2018)

  • Fixed an issue where Postico did not read license files during startup on older versions of macOS #624

New in Postico 1.5.2 (Dec 28, 2018)

  • Fixed a crash when pressing backspace in the SQL Query View #623

New in Postico 1.5.1 (Dec 28, 2018)

  • Added a preference to enable Dark Mode even when the system is using light mode #164
  • Improved Scrolling Performance for table views on macOS 10.13 and 10.14 #622
  • Fixed a problem where the "Execute" button was drawn incorrectly on macOS 10.14
  • Fixed a number of crashes:
  • fixed a crash after double clicking an error symbol
  • fixed a crash when opening popovers with high contrast mode enabled
  • fixed a crash related to query history navigation
  • fixed a crash when exporting some tables to CSV file
  • fixed a crash when pressing shift-tab and the cursor was at the end of the text view

New in Postico 1.5 (Dec 20, 2018)

  • Dark Mode:
  • Postico now fully supports the dark mode introduced in macOS 10.14 Mojave. #164
  • More discoverable color setting:
  • Lots of people contact us to request the ability to assign colors to favorites. But that feature was already there!! The new color picker makes it easier to discover. #187
  • Automatic Crash Reporting:
  • Postico now automatically sends anonymous crash reports (when it crashes). This allows us to fix bugs even if you don't tell us about them! For details, please see the documentation.
  • Connection URL improvements:
  • You can now use URLs to create and update Postico favorites, including setting SSH keys. More details can be found in the docs. #598

New in Postico 1.4.4 (Dec 4, 2018)

  • Reduced CPU usage while queries are running in the background #610
  • Tabs now have an activity indicator
  • Fixed a text layout issue in the right sidebar
  • Fixed a bug where Postico crashed when triggering autocomplete
  • Performance improvements for autocomplete
  • Fixed a bug where an error was displayed after successful reload
  • DDL view now respects font size user preference
  • Fixed an issue where Postico incorrectly parsed passwords with special characters from URLs

New in Postico 1.4.3 (Nov 8, 2018)

  • Fixed a bug where the DDL generated for views contained double semicolons #560
  • Report correct line number when an error occurs during CSV Import #564
  • Fixed a bug where Postico crashed when trying to import a file that you don't have permissions for
  • Added a workaround to make sure MS office file types in bytea fields are correctly identified on macOS 10.14
  • Fixed a bug where the Postico structure editor shows pending SQL changes (empty) after clicking an index attribute #563
  • Fixed a bug where autocomplete did not work with the latest cockroach version v2.0.5.
  • Fixed a crash when an error message was not valid UTF-8 #584
  • Improved error messages when authenticating to the SSH server fails.
  • Fixed display bugs on macOS 10.14.
  • Fixed a bug where Postico froze when autocomplete was triggered for a database with many tables or schemas.
  • Fixed a bug where Postico ran into a memory leak when exporting large tables as CSV #572
  • Postico now restores the height of the favorites window correctly #602
  • Improved compatibility with CockroachDB #600

New in Postico 1.4.2 (Jun 18, 2018)

  • Fixed SSH connection problems with ed25519 host keys #558

New in Postico 1.4.1 (Jun 18, 2018)

  • Fixed a crash when connecting to some SSH servers #558
  • Fixed a severe performance issue when importing CSV files on old PostgreSQL servers with escape_string_warning = on

New in Postico 1.4 (Jun 14, 2018)

  • Bug fix: Fixed a crash on macOS 10.10 and 10.11 when using the shift-left / shift-right commands
  • Bug fix: Fixed UI lag on macOS 10.14 #552
  • Bug fix: Buttons no longer disappear after duplicating a favorite #545
  • CSV Import #68:
  • Postico now allows importing data from CSV files! Select a table in the sidebar, then select "Import CSV" from the File menu. The rest should be self-explanatory! If not, check out the documentation
  • DDL View #34:
  • You can now display CREATE TABLE statements in the DDL (Data Definition Language) view.
  • Better SSH tunnel support:
  • support for EDCSA keys
  • support for ED25519 keys

New in Postico 1.3.5 (May 4, 2018)

  • Fixed a bug where foreign key popovers close right after being opened on Macs with a Touch Bar #528
  • Fixed a bunch of display glitches in the table view

New in Postico 1.3.4 (Apr 26, 2018)

  • Double click blank area to insert a new row #501
  • Fixed a bug where Postico did not update a changed SSH key passphrase even though "Save in Keychain" was checked.
  • Tried to be more resilient when we receive invalid strings with bytes from broken servers #523
  • Fixed display of constraints with newlines #526
  • Fixed a bug where changes to constraints were not saved when you press Cmd-S before closing the popover
  • Fixed a bug where editing foreign key values directly in the sidebar did not work
  • Jump back to page 1 after truncating a table #509

New in Postico 1.3.3 (Apr 5, 2018)

  • Added support for late binding views on Amazon Redshift #493
  • Fixed an autolayout bug on macOS 10.10 in the preferences window #494
  • 2.75x faster SQL parsing
  • Better notifications: Clicking a "Query Done" notification now shows the query that was completed. Also, Postico no longer creates notifications when the query is in the foreground. #342
  • Security: Postico now ensures that other apps cannot use its SSH Tunnel.
  • The text editor now has improved word boundary detection when using schema qualified identifiers (eg. when using option + arrow key) #96
  • Support for LISTEN / NOTIFY #496
  • Support for using three finger swipe gestures to go back / forward (when enabled in system preferences) #468
  • Fixed a crash when using the context menu in the sidebar #521
  • Fixed incorrect tab width in SQL text view that occurred with some fonts (eg. Monaco)
  • Fixed an issue where SQL text fields "captured" the tab key #465
  • Don't abort editing text fields when pressing ⌘. or F5
  • Pressing Esc when editing filters no longer removes the filter (it just cancels editing instead)
  • Cycling through foreign key fields in the sidebar now works #500
  • Improvements for autocomplete:
  • tab completion beeps a lot less (eg. if multiple completions are possible they are shown right away) #513
  • typing a literal tab character is now possible after using tab completion / autocomplete #491
  • Pressing ⌥⇥ now always inserts a literal tab (doesn't trigger tab completion any more)
  • Don't trigger autocomplete when pressing ⌘.
  • Fixed placement of the autocomplete window when the cursor is near the edge of the screen
  • Many minor bug fixes
  • We've made some improvements with regard to connection URL (like postgres://example.com):
  • You can now paste URLs into the favorites window #510
  • Postico now ignores whitespace when parsing URLs #510
  • It's no longer required to include user name & database name when opening URLs if you already have a matching favorite.
  • You can use the scheme postico instead of postgresql if you want to open Postico specifically, eg. open postico://example.com

New in Postico 1.3.2 (Jan 31, 2018)

  • Added a preference to disable autocomplete when typing a period #478
  • Query Autosave improvements: Postico now autosaves queries for each window or tab separately in the Application Support directory. Previously, Postico only stored the query of the last window you closed. Now Postico restores queries in the order that windows / tabs were created. This should fix an issue where the saved query "disappears" after restarting Postico.
  • When pasting strings like "hostname:port" into the host field, Postico now puts the port into the correct field. Additionally, you can now paste PostgreSQL URLs into the host field, and Postico will put everything into the correct fields. #455
  • Postico now saves the color when exporting and importing favorites #456
  • Fixed preference window on Mac App Store version (connection handling settings were not displayed)
  • Updated PostgreSQL client libraries to version 10. This means that Postico now supports the new scram-sha-256 authentication method. Fixes the "authentication method 10 not supported" error #79

New in Postico 1.3.1 (Dec 19, 2017)

  • Fixed a crash that happened when using Autocomplete on some Amazon Redshift clusters #470
  • Fixed a memory error that sometimes caused a crash when using Autocomplete on macOS 10.11 #470
  • Disable thousands grouping character in the "Go To Page" number field to avoid issues with localization #472

New in Postico 1.3 (Dec 19, 2017)

  • NEW FEATURE: AUTOCOMPLETE:
  • Postico now has a brand new autocomplete feature for the SQL query editor.
  • Press Esc or Ctrl-Space to show a list of possible completions. Postico shows completions for SQL keywords, table names, column names and functions.
  • Press Tab to automatically complete words. Tab completion works very similar to command line tools like psql and bash.
  • BUGFIXES AND IMPROVEMENTS:
  • Postico now correctly detects Microsoft Office documents in bytea columns #447
  • The text field in the DROP DATABASE dialog is now focussed initially #358
  • Fixed a bug that caused text to disappear when clicking the "view definition" field on macOS High Sierra #464
  • Filter Improvements:
  • the "Does Not Contain" filter now includes NULL values
  • the "Is Distinct From" filter now works on Amazon Redshift #446

New in Postico 1.2.4 (Dec 19, 2017)

  • Postico now correctly detects Microsoft Office documents in bytea columns #447
  • The text field in the DROP DATABASE dialog is now focussed initially #358
  • Fixed a bug that caused text to disappear when clicking the "view definition" field on macOS High Sierra #464
  • Filter Improvements:
  • the "Does Not Contain" filter now includes NULL values
  • the "Is Distinct From" filter now works on Amazon Redshift #446
  • added test cases for text filters

New in Postico 1.2.3 (Oct 23, 2017)

  • Generate correct PostgreSQL URLs when user, password, host or database contains special characters like question marks #419
  • Unicode Fun: Fixed a problem where the editor didn't work reliably with some combining characters (eg. country flag emojis 🇦🇹).
  • More Unicode Fun: The syntax highlighter now supports non-ascii identifiers without quotes 😳
  • Fixed an issue with columns of type geometry(…)[] #436
  • Fixed a crash when pasting rows with invalid data for an ENUM column

New in Postico 1.2.2 (Aug 7, 2017)

  • Fixed an issue with activating Postico license files.

New in Postico 1.2.1 (Aug 7, 2017)

  • Fixed an issue that prevented Postico 1.2 from connecting to pg_bouncer.
  • Fixed an issue where the connection security info could not be displayed #413

New in Postico 1.2 (Aug 5, 2017)

  • NEW FEATURES:
  • Keep Connection Alive: Postico now periodically sends a command to the server to ensure that the connection isn't terminated by a firewall or similar. This setting replaces the "Disconnect Automatically" function, which did not work reliably when using temp tables or changing settings like the search path. #310
  • Restore session settings: Postico now remembers session settings (like time zone, datestyle, search path) and restores them after reconnecting when the connection was lost.
  • The new SQL Preview button for filters lets you display the SQL generated by Postico #61
  • Postico now displays partitioned tables (introduced in PostgreSQL 10)
  • Postico can now display Redshift Spectrum tables #382
  • Switch between tabs with ⌘1 to ⌘9 #391
  • IMPROVEMENTS:
  • I added an "is distinct from" filter, and removed "is not exactly" to avoid confusion. The difference is that the former includes NULL values while the latter does not. #368
  • Filters with blank fields are now ignored. There is now a new filter that searches for empty strings. #330
  • Made row count & elapsed time selectable #334
  • Added keyboard shortcuts for changing the font size (⌘+ and ⌘-) #335
  • Reloading no longer collapses schemas #102
  • ⌘↩ now applies filters in the table view #313
  • Foreign keys are now editable #264
  • Made it more obvious how to activate Postico. All nag dialogs now have an "Activate License…" button, and I've added an "Activate License…" menu item to the help menu. #404
  • More consistent handling of the ESC key:
  • ESC now means "Revert Changes" in most text fields
  • ESC no longer triggers System Autocomplete #379
  • ESC dismisses the filter bar & page selector
  • BUG FIXES:
  • Fixed an issue that prevented pasting into the SQL Query View #244
  • Fixed an issue where the Open Quickly command searched the wrong database #363
  • Fixed minor display issues #281 #365
  • Fixed a problem where the detail sidebar always showed "no row selected" #336
  • Fixed a problem when reloading a relation that changed type (eg. view -> table) #146
  • Postico now sets the extra_float_digits parameter to 3 when connecting to the server. This ensures that no information is lost when transmitting float or double values. If setting the parameter to 3 fails (server older than 9.0), Postico falls back to extra_float_digits=2 #289
  • Fixed an issue where Postico showed old data when a table or view was replaced with a new one of the same name #398
  • Truncating multiple tables now works on old PostgreSQL servers and Redshift.

New in Postico 1.1.2 (Mar 28, 2017)

  • Added a preference to use a monospace font for the table view #38
  • SQL Query is no longer filtered when searching tables in the side bar #116 #324
  • Added a command to sort favorites (in the context menu).
  • Fixed a bug where the Quick Open command (⌘P) sometimes didn't match schema names.
  • Postico now shows a warning if you go to a page that doesn't exist #67
  • Fixed an issue with placement of new windows and tabs when using a secondary display.
  • Improved error message when an unsuitable character encoding was used for export #319
  • Postico no longer commits an already active transaction when saving changes.
  • Fixed a layout glitch in the table filter view.
  • Fixed errors when clicking SQL Preview button while not connected.
  • Fixed a crash when displaying a table that has no columns (have you heard of table dum and table dee?)
  • Don't try to open a temporary table when doing window restoration (the table won't be there anymore) #350
  • Replaced a unicode character in the change list for version 0.28 that caused a crash on macOS 10.9 (The culprit was VARIATION SELECTOR-15)

New in Postico 1.1.1 (Feb 1, 2017)

  • Fixed two crashes when opening the structure view of some tables on some Redshift clusters.
  • Text fields in views can now be edited in the sidebar. #288
  • Fixed erratic auto sizing behavior for table columns in the SQL query view #291

New in Postico 1.1 (Jan 28, 2017)

  • Create Indexes for Tables and Materialized Views
  • Postico now has a really nice GUI for adding indexes. Existing indices are also displayed graphically (instead of raw SQL). #19
  • Add support for the Touch Bar on the new MacBook Pro #311
  • In the query view, Postico now immediately displays error messages even when a query returns rows. Additionally, Postico now displays a status icon after the query completes so you immediately see if it succeeded. #302
  • The elapsed time for queries is now printed with monospaced digits to avoid jittering.
  • Improved performance when editing large SQL scripts in the query view.
  • Are you annoyed that Postico automatically creates a favorite when you open a postgres:// URL? You can now disable this behavior with a hidden preference. Just execute the following command: defaults write at.eggerapps.Postico CreateFavoritesForURLs 0
  • Added purple color option for favorites.
  • Fixed a bug that caused high CPU usage while Postico is connecting via SSH #123
  • Fixed a crash when adding large files to bytea fields #299
  • Fixed a bug where using the Quick Open command accidentally filtered tables in the side bar.
  • Updated bundled libraries: libpq 9.5.5, OpenSSL 1.0.2j, libssh2 1.8.0.
  • Since libpq 9.5.5 no longer uses the shared SSL Context, this release should also fix a potential deadlock while connecting. When this happened, Postico just showed the message "Working..." and did nothing #294

New in Postico 1.0.10 (Oct 12, 2016)

  • The “Open Quickly” now works better across multiple databases. It is also faster, more stable, and has improved ranking of search results. #258
  • Added “Copy JSON” and “Copy HTML Table” commands #245
  • Copy INSERT now includes table schema #197
  • Fixed a number of issues where syntax highlighting did not work as expected.
  • Fixed an issue where Postico disconnected from the server after an error occurred when using localised error messages #255
  • Add support for deleting and renaming indices in CockroachDB #251
  • Error messages are no longer duplicated in the SQL Query View #262
  • “Clear Results” command (⌘K) lets you clear the SQL Query View #262
  • Added a hidden setting to disable restoring the text in the SQL Query View #256 defaults write at.eggerapps.Postico DontRestoreQueryViewText 1
  • Postico now remembers the size & position of the favorites window.
  • The bundled version of libpq was updated to version 9.5.4
  • Removed bundled libmagic
  • Fixed a crash when Postico opens many connections simultaneously (eg. when using the Quick Open command)
  • Fixed a crash when displaying error messages on macOS 10.9 #276

New in Postico 1.0.9 (Aug 6, 2016)

  • Postico now automatically restores text in the SQL query editor #152
  • Added "Open Quickly…" command. Press ⌘P and type a part of a table name to show a list of matching tables, then press enter to navigate to the the matching table. #228
  • Postico now supports tabs on macOS Sierra. Press ⌘T to open a new tab. #44
  • You can now select PEM files for TLS client certificates #237
  • Fixed an issue where Postico did not update the total number of rows after changing filter settings. #230
  • Postico now uses a heuristic to decide whether to restore the filter in foreign key popovers #232
  • Errors during loading of the structure view are now reported in more detail.
  • Fixed a problem where connection errors where displayed only partially.

New in Postico 1.0.8 (Jun 1, 2016)

  • Fixed an issue that prevented Postico from updating Boolean columns.

New in Postico 1.0.7 (May 31, 2016)

  • Postico now supports using client certificates for authentication #218
  • Postico now has basic support for CockroachDB #224
  • Numbers with type NUMERIC(x,y) are now displayed with trailing zeros. #205
  • Support for copy/pasting tables with cells that contain newlines #59
  • Fixed a problem where Postico could hang when quickly clicking the next page button #220
  • Fixed a problem with NULL values in the sidebar #219
  • Clicking the column header now cancels the previous query, so you no longer have to wait until Postico has finished loading a table before you can change the sort order. If you accidentally clicked the header, you can now just click it again to deactivate sorting again. #221
  • Postico now asks for confirmation before deleting favorites #210
  • Error messages for loading tables are no longer modal #198
  • Numbers in generated SQL are no longer quoted.
  • Bundled libpq updated to 9.5.3, OpenSSL updated to 1.0.2h

New in Postico 1.0.6 (Apr 12, 2016)

  • Performance of column auto-sizing has been vastly improved, especially for tables with many columns.
  • Add support for the standard Find & Replace panel in the Query View. You can activate it by ⌘F. Unfortunately this means I've had to change the shortcut for filter rows to ⌥⌘F #53 #165
  • A small button in the status bar now shows whether the connection is encrypted or not. Clicking the button lets you validate details such as the SSH host key or TLS certificates sent by the server.
  • You can now delete rows by pressing backspace (as an alternative to Cmd-Backspace)
  • Added a "Reload Current View Only" command ⌥⌘R
  • Added a list of keyboard shortcuts to the documentation
  • Fixed an issue where Postico would try to sort by inaccessible columns (eg. ctid)

New in Postico 1.0.5 (Mar 4, 2016)

  • Postico now treats UUID columns as numeric when filtering #184
  • Updated OpenSSL to version 1.0.2g.
  • Fixed a bug where text was sometimes truncated when changing row height to a single line.
  • Fixed problem when displaying error message.
  • psql commands are now highlighted in red (they are not supported) #145

New in Postico 1.0.4 (Feb 25, 2016)

  • Postico now uses Notification Center to show update notifications. #135
  • Postico now remembers the last used window size #14 #98 #136
  • Fixed a bug where Postico rejected certificates signed by intermediate Certificate Authorities #158
  • Fixed a bug where Postico gets confused when you replace a view/table with an object of a different type. #146 #163
  • Fixed a bug where navigating between foreign keys didn't work #177
  • Update bundled OpenSSL to 1.0.2f
  • Update bundled libpq to 9.3.11
  • Update bundled libssh2 to version 1.7.0. This version adds support for diffie-hellman-group-exchange-sha256, and it fixes CVE-2016-0787
  • Table view:
  • Added preferences for font size, number of lines per row, alternating row background color #26 #38
  • Postico now adjusts column widths intelligently #87
  • The number of selected rows is now displayed in the status bar #170
  • Improved display of floating point numbers #166
  • Postico now remembers whether you last used the contents or structure view #40
  • Postico no longer attempts to load columns that you don't have permission to view. #179
  • Server view:
  • Added a search field to filter databases.
  • Added a "Create Database" button #112
  • SQL Query View:
  • Press Ctrl-H to look up the current word in Dash #176
  • You can now change the tab width (default 4 spaces) and use spaces instead of tabs #103
  • Additional keyboard shortcuts: Shift Left ⌘[ and Shift Right ⌘] #103

New in Postico 1.0.3 (Jan 12, 2016)

  • PostGIS geometry and geography columns are now detected even if they use annotations like geography(Point,4326) #140
  • Fixed a bug where loading SQL files with Windows linebreaks was slow and led to odd behavior.
  • Additional filters for text columns (>, >=,

New in Postico 1.0.2 (Nov 30, 2015)

  • Fixed an issue when pasting values into columns of type NUMERIC
  • Tabs in the SQL query view are now exactly 4 spaces wide #103
  • Fixed two regressions from version 1.0.1:
  • Inserting tabs into the SQL query view works as expected again
  • Postico now again shows proper error messages when saving changes fails

New in Postico 1.0.1 (Nov 24, 2015)

  • Added an option in preferences to change the font size of the SQL Query text view #38
  • The interface now refreshes correctly after deleting the last index.
  • The SQL Query View now recognises statements containing semicolons #109
  • Fixed a bug where the execute button was enabled even though there was no query on the line.
  • Postico now correctly handles special characters in filenames (like /) when exporting.
  • When saving changes to a table, you now have the option to commit changes even when the number of affected rows does not match what Postico expected #130
  • You can now also disable the check altogether with a hidden preference: defaults write at.eggerapps.Postico IgnoreAffectedRows 1
  • Postico now automatically replaces non-standard space and newline characters in the SQL query view, and it strips byte order marks. #75 #84
  • You can disable this behaviour with a hidden preference: defaults write at.eggerapps.Postico SanitizeWhitespace 0
  • Added a "Copy with Header" command #65 #125
  • Added a preference to disable Magic Mouse and trackpad gestures #129
  • Type select in the grid view: You can now just start typing to select tables in the grid view #119
  • Filter tables & schemas in the grid view #119

New in Postico 1.0 (Nov 4, 2015)

  • Indexes: Postico now displays table indexes in the table structure view right below the columns. This feature is currently mainly useful for informative purposes: it's convenient to get a quick overview. You can also rename indexes, add comments, or delete indexes. However, there is no graphical user interface yet for creating indexes (I will add that in a future version) #19
  • Avoid lost connections: Postico now automatically disconnects from the server before your Mac goes to sleep, or when the connection was idle for 5 minutes. Postico reconnects automatically the next time you try to execute a query. This should hopefully fix the problem of lost connections when servers are configured with a timeout. You can disable the idle timeout in preferences. #66
  • Typography: Postico now uses Apple's new system font San Francisco everywhere (except for SQL which is shown in Menlo). I also switched back to fixed width digits for better legibility of tabular data. Additionally, numeric columns are now right-aligned. I've also tweaked all the margins since the different x-height of the new font requires slightly different alignment occasionally.
  • PostGIS geometry and geography columns are now displayed as EWKT, which is slightly more readable than the default binary gibberish #92
  • Deleting a table that hasn't been saved yet no longer shows an error message and works as expected.
  • I added a context menu for table column headers in the SQL Query view #97
  • Fixed a deadlock (beachball) in the syntax highlighter #108
  • When using the "Copy As Insert" command, Postico now separates rows with newlines #104
  • Redesigned foreign key fields in the sidebar for a more consistent look and feel.
  • The sidebar now displays column types.
  • The tables in the popup menu for foreign keys are now sorted again #85
  • The query history popover lets you now insert queries by double clicking or pressing enter #101

New in Postico 0.27 Beta (Oct 8, 2015)

  • System requirements raised to OS X 10.9. Postico wasn't as stable on 10.8 as I wanted it to be. Working around bugs in Mountain Lion and additional QA efforts for the legacy system would have required too much time that I'd rather spend on new features, considering the very low number of users.
  • Improved error handling during connection establishment. Postico was unreliable when restoring previously open windows in certain conditions. Problems occurred when the server did not support SSL, or when the SSH server required keyboard-interactive authentication. Connection establishment should now be much more reliable. Also, certificate warnings are now shown only once. #81
  • “Execute” (Cmd-Return) now executes only the current query #11
  • Improved query history:
  • Filter the history to search for specific queries #74
  • Detail view shows the full query.
  • Clicking back/forward now replaces only the current query, or the selection.
  • Delete multiple queries from the history at once using the context menu.
  • SQL Preview popover is now bigger and scrolls.
  • Added support for displaying foreign tables.
  • Fixed a bug where a query displays no results when it is executed while a previous one is still running.
  • Improved button styling in SQL Query view in Yosemite (eg. cancel button is now visibly disabled).
  • Fixed display issues on El Capitan.
  • Postico now ignores unsupported SSH host key types in known_hosts #78
  • Fixed a crash when clicking the foreign key table button when multiple rows were selected.
  • Fixed a problem where strings were quoted incorrectly on Amazon Redshift #73
  • Fixed a problem where inserting rows failed on Amazon Redshift
  • Comments are now saved when adding a column to a table #79
  • Added new filters: “begins with”, “ends with”, and “like” #56
  • The breadcrumb control now also includes the schema of a table #32
  • Fixed display issues in the favorite window on OS X 10.9

New in Postico 0.26 Beta (Aug 15, 2015)

  • 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.
  • 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:
  • You can now select values for enum and boolean columns from a popup menu #33
  • Foreign Keys now have a little icon that lets you pick rows from the related table
  • Added a button to view the related table #22

New in Postico 0.25 Beta (Jul 10, 2015)

  • 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 upport 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.

New in Postico 0.24 Beta (Jun 26, 2015)

  • 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.
  • #1 Fixed back tab behavior when full keyboard access is turned on.
  • #2 Hitting escape in text fields now discards changes and aborts editing instead of invoking auto-complete.
  • #12 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.
  • 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.

New in Postico 0.23 Beta (Jun 13, 2015)

  • 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

New in Postico 0.22 Beta (Jun 13, 2015)

  • 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.

New in Postico 0.21 Beta (May 20, 2015)

  • 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

New in Postico 0.20 Beta (Apr 3, 2015)

  • 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