Softpedia >Mac >Developer Tools >SQLPro for Postgres >  Changelog

SQLPro for Postgres Changelog

What's new in SQLPro for Postgres 2024.21

Apr 11, 2024
  • Fixed an issue that could cause a crash when deleting records. [#965](https://github.com/hankinsoft/SQLPro/issues/965)
  • Fixed an issue that could cause a crash when removing the 'format query' shortcut. [#964](https://github.com/hankinsoft/SQLPro/issues/964)

New in SQLPro for Postgres 2024.15 (Apr 11, 2024)

  • Performance improvements with the query editor.
  • Crash fix related to the query editor.

New in SQLPro for Postgres 2024.11 (Apr 11, 2024)

  • Performance improvements.

New in SQLPro for Postgres 2023.10 (Feb 7, 2023)

  • Fixed an issue where new connections were defaulting to read-only.

New in SQLPro for Postgres 2023.06 (Jan 30, 2023)

  • Fixed an issue with connection persistence.

New in SQLPro for Postgres 2021.46 (May 21, 2021)

  • Fixed an issue with scrolling.
  • Fixed an issue with CSV export.

New in SQLPro for Postgres 2021.38 (May 21, 2021)

  • Fixed an issue where setting SSL to disabled would still use preferred.

New in SQLPro for Postgres 2021.08 (May 21, 2021)

  • Fixed a crash that some users were seeing when exporting results.
  • Fixed a crash that some users were seeing when hitting 'Apply without preview' when editing results.
  • Fixed an issue where `execute query in cursor range` set to Enabled but not default, was still defaulting to the current query.
  • Fixed an issue with tabs sizes.

New in SQLPro for Postgres 2020.97 (May 21, 2021)

  • Fixed an issue where columns were not showing for foreign tables.

New in SQLPro for Postgres 2020.96 (Nov 16, 2020)

  • Support for Apple Silicon.

New in SQLPro for Postgres 2020.68 (Aug 10, 2020)

  • Fixed an issue where autocomplete could sometimes remove newlines. [#481](https://github.com/hankinsoft/SQLPro/issues/481)
  • You can now 'reverse-cycle' the autocomplete window. [#473](https://github.com/hankinsoft/SQLPro/issues/473)
  • Working on resolving an issue where the cursor position might jump when autocomplete is entered. [#476](https://github.com/hankinsoft/SQLPro/issues/476)
  • Fixed an issue with Postgres object names beginning with a number were not properly escaped.
  • Autocomplete delay has been reset to the default (1.25 seconds). Due to a bug which had caused some users autocomplete to set to zero.
  • Performance improvements for autocomplete cache (was causing slowdowns on startup for some users). [#468](https://github.com/hankinsoft/SQLPro/issues/468)
  • Adding or removing tables via the query editor (ie CREATE TABLE/DROP TABLE) will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10)
  • Improvement with SSH tunnelling. Previously, every connection created a new tunnel. Now tunnels can be reused.
  • Autocomplete now wraps when using up/down keys. [#473](https://github.com/hankinsoft/SQLPro/issues/473)
  • Selected rows in the results grid now highlight the row numbers. [#465](https://github.com/hankinsoft/SQLPro/issues/465)
  • Adding/removing/altering a table will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10)
  • Fixed insertion text for CTEs and aliases. [#296](https://github.com/hankinsoft/SQLPro/issues/296)
  • Database names colors are now customizable for the query editor. [#404](https://github.com/hankinsoft/SQLPro/issues/404)
  • Made some attempts at fixing autocomplete window sometimes appearing in the incorrect location. [#377](https://github.com/hankinsoft/SQLPro/issues/377)
  • Autocomplete delay now has a preference. [#394](https://github.com/hankinsoft/SQLPro/issues/394)
  • Fixed a crash some MSSQL users would see.
  • Fixed an issue where importing CSVs into a new table would fail. [#447](https://github.com/hankinsoft/SQLPro/issues/447)
  • Improved support for SSH tunnelling when using 'restored UI'.
  • Fixed an issue where Postgres 'alter table' would not show size of 'character' data types.

New in SQLPro for Postgres 2020.59 (Jun 15, 2020)

  • Fixed an issue where when inserting rows, the inserted rows would not be visible once applied (until re-queried).
  • Fixed an issue where opening files created from Microsoft SQL Server would fail.
  • Added 'IS NULL' and 'IS NOT NULL' to result filters. [#402](https://github.com/hankinsoft/SQLPro/issues/402)
  • Fixed an issue which may display some newly purchased licenses as invalid.
  • Syntax highlighting and autocomplete now includes support for objects in other databases (on the same server). [#404](https://github.com/hankinsoft/SQLPro/issues/404)
  • Autocomplete now detects if a table is outside of your current schema and will add the proper schema if required. [#296](https://github.com/hankinsoft/SQLPro/issues/296)

New in SQLPro for Postgres 2020.47 (May 22, 2020)

  • You can now copy the connection string (on clients which use connection strings) from the connections dialog by selecting a connection and choosing copy. [#384](https://github.com/hankinsoft/SQLPro/issues/384)
  • You can set function keys as keyboard shortcuts. [426](https://github.com/hankinsoft/SQLPro/issues/426)
  • You can now rename tabs be either double clicking a tab title, or right clicking and choosing 'Rename'.
  • Fixed a crash that could occur when updating results.
  • Fixed an issue when altering a triggers stored procedure would cause a crash.
  • Fixed an issue which could cause crashes when updating results.
  • Fixed an issue which could cause crashes when expanding JSON results.
  • Fixed an issue when editing results and hitting 'Apply' (without preview) would sometimes generate an error.
  • If no tabs are open and the history menu item is clicked or the keyboard shortcut is activated, a new tab will be opened with the history popup visible.
  • Inserting rows via the results grid no longer pops up an insert dialog. You can still access the dialog by right clicking a row and choosing 'Edit'. [#401](https://github.com/hankinsoft/SQLPro/issues/401)
  • You can now duplicate rows in the results grid. [#57](https://github.com/hankinsoft/SQLPro/issues/57)

New in SQLPro for Postgres 2020.42 (May 22, 2020)

  • Fixed an issue with setting default values via the table designer.
  • Fixed an issue with changing a columns nullability via the table designer.
  • Fixed an issue with importing arrays. [#425](https://github.com/hankinsoft/SQLPro/issues/425)
  • Fixed an issue with importing NULL timestamps. [#424](https://github.com/hankinsoft/SQLPro/issues/424)
  • Fixed an issue which could cause crashes when skipping columns during CSV import. [#424](https://github.com/hankinsoft/SQLPro/issues/424)
  • Fixed an issue which could cause crashes when cancelling a query or closing an tab with an active query running. [#416](https://github.com/hankinsoft/SQLPro/issues/416)
  • Fixed an issue where right clicking on an escaped table name in the query editor would sometimes result in a 'No object selected' issue. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
  • Fixed an issue with keyboard shortcuts would not save properly if tab characters were used. [#403](https://github.com/hankinsoft/SQLPro/issues/403)
  • Fixed an issue where when importing from CSV, the focused table may not be defaulted. [#405](https://github.com/hankinsoft/SQLPro/issues/405)
  • Increased internal SQLite version used. [#412](https://github.com/hankinsoft/SQLPro/issues/412)
  • Fixed an issue with tabs in the query editor. [#395](https://github.com/hankinsoft/SQLPro/issues/395)
  • Improvements with the History popup. [#400](https://github.com/hankinsoft/SQLPro/issues/400)
  • Alias improvements. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
  • When modifying rows via the results-grid there is now an 'Apply' button, so that changes can be applied without needing to preview first.
  • Result messages are now monospaced.
  • Result messages now uses the same font size as the query text editor.
  • Result error messages are now more of a 'whiteish-pink' when using a dark theme (a bit easier on the eyes).
  • Fixed an issue where 'Copy as Insert' did not escape table names. [#390](https://github.com/hankinsoft/SQLPro/issues/390)
  • Additional improvements for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)
  • Added a 'Read-only' intent option (currently for MSSQL). When this option is enabled, all DROP, TRUNCATE, DELETE, UPDATE, INSERT, etc related UI is hidden from the user. This will NOT prevent the user from creating and running their own SQL commands. [#386](https://github.com/hankinsoft/SQLPro/issues/386)
  • Additional improvements for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)

New in SQLPro for Postgres 2020.30 (Apr 22, 2020)

  • Fixed a crash some users were seeing when opening queries.
  • Fix for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)
  • You can now add custom connection groups.
  • You can now expand and collapse connection groups.
  • Fix for 'blue turds' in query text view. [via twitter](https://twitter.com/danielpunkass/status/1236062931097473024?s=21)

New in SQLPro for Postgres 2020.10 (Feb 17, 2020)

  • You can now paste a postgres URI into the host field. [#364](https://github.com/hankinsoft/SQLPro/issues/364)
  • Fixed an issue where the SQL beautifier would add an extra space at the end of lines. [#362](https://github.com/hankinsoft/SQLPro/issues/362)
  • Fixed an issue where dropping procedures would try and run a drop function script. [#352](hhttps://github.com/hankinsoft/SQLPro/issues/352)
  • If you select a Table or Column in the database tree, hitting Copy (via ctrl-c or menu items) will copy the table schema/name or column name to the clipboard.
  • Fixed a crash that could occur when clicking on Foreign Keys in the results data grid.
  • Improved autocomplete with 'order by' clause. Now limits to tables used in the query.
  • Autocomplete is now a background operation. If for some reason the autocomplete is slow it will no longer freeze the main UI thread. [#334](https://github.com/hankinsoft/SQLPro/issues/334).
  • Fixed an issue where refreshing the root server node would do nothing. [#350](https://github.com/hankinsoft/SQLPro/issues/350)
  • Fixed an issue where closing tabs may not disconnect the client. [#353](https://github.com/hankinsoft/SQLPro/issues/353)
  • Postgres inherited tables are now beneath their parents node in the database tree. [#355](https://github.com/hankinsoft/SQLPro/issues/355)
  • Fixed a crash that could when inserting a new row.
  • Improvements to database search.
  • Fixed an issue with CSV import into existing table.
  • Fixed an issue where schemas were being displayed on object in the database tree when 'Group schemas in database tree' was enabled.
  • Foreign tables are now available in the database tree.
  • Fixed an issue with state restoration. The database tree was not getting preserved when you disconnect from a database.
  • Fixed a crash that could occur when duplicating tables.
  • Fixed an issue when duplicating tables where the source table was not always the one duplicated if the source table was not the table select in the database tree.
  • Fixed an issue which could cause crashes when inserting into a result set.
  • Improvements with CSV imports.

New in SQLPro for Postgres 2019.64 (Dec 13, 2019)

  • Fixed an issue with state restoration. The database tree was not getting preserved when you disconnect from a database.
  • Fixed a crash that could occur when duplicating tables.
  • Fixed an issue when duplicating tables where the source table was not always the one duplicated if the source table was not the table select in the database tree.
  • Fixed an issue which could cause crashes when inserting into a result set.
  • Updated to the latest Oracle library.
  • Improvements with CSV imports.
  • Fixed an issue with the 'Disable' option of 'Execute query in cursor range' where the current query would still be highlighted when modifying a query.

New in SQLPro for Postgres 2019.59 (Nov 26, 2019)

  • Performance improvements for autocomplete.
  • Fixed a crash which could occur with autocomplete.
  • 'Execute button' now has additional options.
  • Performance improvements for autocomplete.
  • Improvements to state restore where not all tabs were always being restored.
  • Result grid editing - Primary keys are no longer required (but are still encouraged).
  • Result grid editing - When editing cells, changes are no longer applied until the new 'Preview and Apply' button has been pressed. A discard button is also available.
  • Result grid editing - Shift-Tab now works to move to the previous cell (and regular tab now works better due to the previously mentioned change).
  • Importing CSVs into Oracle is now quicker to list tables.
  • Improved background drawing in query text view when query execution style is 'execute query in cursor range'.
  • Quoted column names are now handled by syntax highlighting.
  • Creating a table in Postgres no longer displays as reversed schema/table name.
  • Fixed an issue which could cause some PostgreSQL connections to crash on connection.
  • Fixed an issue where the 'databases' dropdown in the new/edit connection window could cause a crash.
  • Fixed an issue with could sometimes cause crashes when typing a query.

New in SQLPro for Postgres 2019.45 (Oct 23, 2019)

  • Fixed an issue with connecting to Postgres 12 servers where the app would either display incorrect database or possibly crash.
  • Fixed an issue with setting values from result sets.
  • Autocomplete is now context sensitive. For example, if you enter `SELECT * FROM myTable WHERE ` autocomplete will suggest myTable and columns related to myTable.
  • Boolean fields now appear with color (green for true, red for false - this is a prefernce which can be disabled).
  • Boolean fields now display as true/false rather than 1/0 (this is a preference which can be disabled).
  • CTEs are now included in autocomplete.

New in SQLPro for Postgres 2019.06.26 (Jul 1, 2019)

  • Fixed a crash which could occur for some users when pasting queries.

New in SQLPro for Postgres 2019.05.16 (May 17, 2019)

  • Colors for connections has been improved (easier to tell which tab is active).
  • You can now pick custom colors for connections.
  • Fixed an issue with SSL that could cause certificate rejections.
  • You can now customize results grid apperance.

New in SQLPro for Postgres 1.0.460 (Apr 19, 2019)

  • Fixed an issue where the app could close for some users when opening preferences.
  • The connections window is now resizable on systems running macOS 10.14 and above.
  • Autocomplete no longer requires the AS keyword to detect table aliases.

New in SQLPro for Postgres 1.0.454 (Apr 3, 2019)

  • Added a new 'keyboard' preferences panel:
  • Query execute shortcut has been moved to this panel.
  • Comment/uncomment keyboard shortcut has been added.
  • Default separator and qualifier for copying results can now be specified. It defaults to comma and double quote, but you can change it as needed.
  • Postgres specific:
  • Fixed an issue with Postgres foreign keys designer sometimes not allowing users to add columns for mapping.

New in SQLPro for Postgres 1.0.431 (Mar 29, 2019)

  • Fixed an issue where schemas were not specified when using the 'Delete rows' context menu item on results.
  • Schema grouping options for the database tree have changed. Schema grouping now defaults to automatic. If you have more than one schema, they will be grouped. One or less will not be grouped. The can also be toggled via individual connections 'advanced' options.

New in SQLPro for Postgres 1.0.320 (Mar 12, 2019)

  • You can now click on foreign key columns to be taken to foreign key table data.
  • You can now use pre-existing license keys in SQLPro for Postgres.

New in SQLPro for Postgres 1.0.308 (Nov 11, 2018)

  • Resolved an incorrect display for certain column types.

New in SQLPro for Postgres 1.0.307 (Nov 8, 2018)

  • Fixed an issue where views would not always appear under the appropriate schema.

New in SQLPro for Postgres 1.0.304 (Nov 8, 2018)

  • Fixed a crash that could occur when cancelling queries.

New in SQLPro for Postgres 1.0.302 (Oct 14, 2018)

  • Support for Mojave and dark mode.
  • Performance improvements when opening large files.

New in SQLPro for Postgres 1.0.141 (Aug 28, 2018)

  • Resolved a few performance issues.
  • Made some changes in preparations for an upcoming os.

New in SQLPro for Postgres 1.0.140 (Jul 25, 2018)

  • Fixed an issue where connection colours were not saving with the application.
  • Fixed an issue where some users may see tabs as black.

New in SQLPro for Postgres 1.0.131 (Jun 14, 2018)

  • Fixed some issues with resolving connection ip/port from server name.
  • Fixed a crash that could occur on connection.
  • Closing multiple tabs now prompts with an option to review unsaved changes ignoring any changes.

New in SQLPro for Postgres 1.0.127 (Feb 11, 2018)

  • Fixed an issue where indexes may not show up in the database tree (specifically for tables which needed to be escaped).
  • Fixed an issue with crash recovery.
  • Fixed a table designer issue where the schema name was not always being used when altering tables.

New in SQLPro for Postgres 1.0.125 (Oct 28, 2017)

  • Improvements to database searching.
  • Resolved an issue which could result in a crash during editing results.

New in SQLPro for Postgres 1.0.116 (Aug 4, 2017)

  • Fixed an issue with keyboard navigation.

New in SQLPro for Postgres 1.0.115 (Jul 31, 2017)

  • Fixed a 'copy from result set' issue where you may end up with more data than selected.

New in SQLPro for Postgres 1.0.113 (Jul 24, 2017)

  • Fixed an issue with the comment/uncomment command not adding a required space.
  • Greatly improved memory + performance when selecting results.
  • Fixed an issue where 'shift left' + 'shift right' (cmd + [, cmd + ]) were not using tab style.
  • Fixed an issue where SSH port was not using the user entered value (always defaulted to 22).

New in SQLPro for Postgres 1.0.110 (May 15, 2017)

  • Fixed a crash that would happen when modifying inline results.

New in SQLPro for Postgres 1.0.108 (May 5, 2017)

  • SSH tunnelling was not working in specific conditions. This has been resolved.

New in SQLPro for Postgres 1.0.107 (May 3, 2017)

  • Fixed an crash some users were seeing when running queries. (Issue was with primary key detection).
  • Added a keyboard shortcut (ctrl + ]) to switch between matching brackets.

New in SQLPro for Postgres 1.0.106 (Apr 28, 2017)

  • Resolved a crash some users could see when closing tabs.

New in SQLPro for Postgres 1.0.102 (Jan 27, 2017)

  • Fixed an issue which could cause crashes on startup for some users.

New in SQLPro for Postgres 1.0.99 (Nov 16, 2016)

  • Fixed an issue where schemes were not being displayed properly via Redshift databases.

New in SQLPro for Postgres 1.0.96 (Nov 2, 2016)

  • Fixed a crash that could occur when stored procedure execution results in an error.

New in SQLPro for Postgres 1.0.88 (Oct 13, 2016)

  • Improvements for working with large data sets.

New in SQLPro for Postgres 1.0.85 (Oct 4, 2016)

  • Improvements for Sierra.

New in SQLPro for Postgres 1.0.70 (Sep 8, 2016)

  • Added a 'dark results grid' option to the Appearance preferences.

New in SQLPro for Postgres 1.0.65 (Aug 4, 2016)

  • Added an export to sqlite option to the database and tables node. Currently only exports tables and their data.
  • Fixed an issue some users could have when scripting a table.
  • Fixed an issue where clicking on the close tab button would not prompt to save changes.

New in SQLPro for Postgres 1.0.60 (Aug 3, 2016)

  • Fixed a bug in result set column handling. In the smaller case it would cause the last empty result set to have invalid column names. In the worse case it would include a result set when there should not be, dramatically slowing down database creation scripts.

New in SQLPro for Postgres 1.0.55 (Jul 28, 2016)

  • Improved support for editing and creating foreign keys.

New in SQLPro for Postgres 1.0.48 (Jun 10, 2016)

  • Fixed an issue where the functions node was only showing entries in the default schema.
  • Fixed an issue where queries with no results would not display the column headers.