2023.50
2023-06-26
+ Fixed an issue with scripting views.
2023.21
2023-03-02
+ Fixed an issue with handling queries. [#888](https://github.com/hankinsoft/SQLPro/issues/888)
2020.43
2020-05-13
+ 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.
+ Fixed an issue where export to CSV may display 'No table'.
+ 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)
2019.63
2019-11-30
+ Fixed an issue which could cause duplicate databases in the server/database dropdown.
+ 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 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.
+ Fixed multiple issues with state restoration.
+ Many buttons now respect the systems accent color (macOS 10.14 and above).
+ Fixed an issue where CTE columns may display incorrect column names. [#314](https://github.com/hankinsoft/SQLPro/issues/314)
+ Fixed an issue autocomplete window may display below the bottom of the screen. [#315](https://github.com/hankinsoft/SQLPro/issues/315)
+ Postgres table designer now supports Table comments. [#313](https://github.com/hankinsoft/SQLPro/issues/313)
+ CTEs and Aliases are now highlighted in the query editor (there is a limitation on the maximum query length before this gets disabled).
+ Fix for a crash that could occur with autocomplete [317](https://github.com/hankinsoft/SQLPro/issues/317)
+ Fixed an issue with expand/collapse database tree sidebar (when search tab was selected) which could mess up the UI.
+ Fixed a crash that could occur when right clicking on some database tree nodes and choosing 'refresh'.
+ Fixed a few improvements with state restoration.
+ Improved performance with the search scope selector.
+ Fixed an issue where right clicking on the 'messages results' (contains text such as 'query finished successfully') could cause crashes.
+ Fixed an issue where some MySQL errors would not be displayed to the user.
+ Fixed a performance issue with the connection dialog on macOS 10.13 and before.
+ Fixed searching not working.
+ Fixed an issue you could sometimes not insert into a table from result sets. (Inserting from a result set still requires a 'simple query'). [#312](https://github.com/hankinsoft/SQLPro/issues/312)
+ Added advanced searching. [#180](https://github.com/hankinsoft/SQLPro/issues/180)
+ You can now right click on a table name in the query editor and perform a few actions such as 'select first 1,000 rows', 'script as create statement', 'script as drop and create statement' and 'script as drop statement'. This also works on aliases.
+ Fixed an issue where entering/exiting full screen could be slow.
+ Autocomplete now includes partial matches as well as full matches.
+ 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 preference which can be disabled).
+ Boolean fields now display as true/false rather than 1/0 (this is a preference which can be disabled).
+ Autocomplete now includes partial word matches.
+ CTEs are now included in autocomplete.
+ Oracle connections now have a 'group by schema' option (Automatic by default, but can be set to enabled/disabled).
+ Improvements for Oracle autocomplete.
2019.09.17
2019-09-18
+ Fixed an issue where some users would get 'Connecting' indefinitely.
2019.07.02
2019-07-02
+ Fixing an issue which could cause the app to hang when closing.
2019.06.26
2019-06-27
+ Fixed a crash that could occur when duplicating connections.
+ Fixed a crash that could occur when pasting queries overplace of existing queries.
1.0.469
2019-04-30
+ 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.
+ Resolved some issues with SSH Tunneling.
+ You can now duplicate connections.
1.0.453
2019-04-10
+ Improvements to SSH tunnel logging.