Softpedia >Mac >Developer Tools >SQLPro Studio >  Changelog

SQLPro Studio Changelog

What's new in SQLPro Studio 2024.21

Apr 11, 2024
  • Fixed a crash that could occur when modifying MySQL table structures.

New in SQLPro Studio 2024.20 (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 Studio 2024.17 (Apr 11, 2024)

  • Fixed a crash that could occur during autocomplete.

New in SQLPro Studio 2024.15 (Apr 11, 2024)

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

New in SQLPro Studio 2023.73 (Apr 11, 2024)

  • Added an option to set a default query for a table. [#940](https://github.com/hankinsoft/SQLPro/issues/940)
  • Added an option for generic tabs to not be promoted for a save. [#949](https://github.com/hankinsoft/SQLPro/issues/949)
  • Added an option to disable the cmd + number shortcuts. [#942](https://github.com/hankinsoft/SQLPro/issues/942)
  • Added the option to set a default query to be executed for tables. [#940](https://github.com/hankinsoft/SQLPro/issues/940)

New in SQLPro Studio 2023.56 (Apr 11, 2024)

  • Added support for right aligning numericals. [#914](https://github.com/hankinsoft/SQLPro/issues/914)
  • Added support for importing from JSON files. [#924](https://github.com/hankinsoft/SQLPro/issues/924)
  • Added support for exporting tables directly to Json via the database tree table context menu.
  • Moved themes location on file system. [#780](https://github.com/hankinsoft/SQLPro/issues/780)
  • Added support for keyboard shortcuts to export result sets as csv/json/xml. [#913](https://github.com/hankinsoft/SQLPro/issues/913)
  • Renaming a table will instantly update the autocomplete. [#922](https://github.com/hankinsoft/SQLPro/issues/922)
  • You can refresh a tab loaded from the file system by right clicking the tab and choosing 'Reload file'. [#902](https://github.com/hankinsoft/SQLPro/issues/902)
  • You can now delete a MySQL database from the database tree by right clicking on the database and choosing 'Drop database'. (There are confirmations before any deletions). [#911](https://github.com/hankinsoft/SQLPro/issues/911)

New in SQLPro Studio 2023.43 (Apr 11, 2024)

  • Fixed an issue with paste.

New in SQLPro Studio 2023.42 (Apr 11, 2024)

  • Fixed an issue with CR vs LF. [#904](https://github.com/hankinsoft/SQLPro/issues/904)
  • Fixed an export issue.

New in SQLPro Studio 2023.41 (Apr 11, 2024)

  • Added support for STRICT sqlite tables.
  • Added FTS3,FTS4 and FTS5 support in sqlite.
  • When exporting, you can now choose create to create a folder for each entry. [https://github.com/hankinsoft/SQLPro/issues/899](https://github.com/hankinsoft/SQLPro/issues/899)

New in SQLPro Studio 2023.35 (Apr 18, 2023)

  • There is now an option to sync preferences via iCloud. [#686](https://github.com/hankinsoft/SQLPro/issues/686)
  • There is now a preference to auto-capatialize as you type. [#536](https://github.com/hankinsoft/SQLPro/issues/536)

New in SQLPro Studio 2023.21 (Apr 18, 2023)

  • Fixed an issue with decimal display. [#890](https://github.com/hankinsoft/SQLPro/issues/890)
  • Fixed an issue with csv export not showing all schemas in postgres. [#889](https://github.com/hankinsoft/SQLPro/issues/889)

New in SQLPro Studio 2023.20 (Apr 18, 2023)

  • Fixed horizontal grid setting not working properly. [#880](https://github.com/hankinsoft/SQLPro/issues/880)
  • The 'export as csv' settings will now persist. [#885](https://github.com/hankinsoft/SQLPro/issues/885)
  • Added 'decimal separator' and 'thousands separator' to the results appearance section in preferences.
  • Made improvements to MySQL connections (there is now an option to disable compression - which is disabled by default). [#884](https://github.com/hankinsoft/SQLPro/issues/884)

New in SQLPro Studio 2023.15 (Apr 18, 2023)

  • Fixed an issue where grid appearance was not working properly. [#880](https://github.com/hankinsoft/SQLPro/issues/880)
  • Fixed an issue with column wildcard search in autocomplete. [#879](https://github.com/hankinsoft/SQLPro/issues/879)
  • Select all occences context menu will now select the word in scope if no selection has already been made. [#789](https://github.com/hankinsoft/SQLPro/issues/789)
  • Added support for MSSQL 'table shortcut' in autocomplete. [#877](https://github.com/hankinsoft/SQLPro/issues/877)

New in SQLPro Studio 2023.12 (Apr 18, 2023)

  • Added a 'Select All Occurrences' context menu item to the editor. [#789](https://github.com/hankinsoft/SQLPro/issues/789)

New in SQLPro Studio 2023.10 (Apr 18, 2023)

  • Improvements with connection storage.
  • You can now specify the 'focus database tree' and 'focus database tree search' shortcuts. [#870](https://github.com/hankinsoft/SQLPro/issues/870)

New in SQLPro Studio 2023.05 (Feb 7, 2023)

  • Made some improvements with storing history.
  • Fixed a crash which could occur when cancelling a mysql query.
  • Added a readonly option for connections.

New in SQLPro Studio 2023.01 (Feb 7, 2023)

  • Fixed an issue which could cause a crash when discarding changes to edited rows.

New in SQLPro Studio 2022.83 (Feb 7, 2023)

  • MSSQL user-created types now show the type details in the database tree.

New in SQLPro Studio 2022.82 (Feb 7, 2023)

  • Resolved an issue with 'format query'.

New in SQLPro Studio 2022.81 (Feb 7, 2023)

  • Fixed an issue where device sleeping may not properly close all connections. [#847](https://github.com/hankinsoft/SQLPro/issues/847)
  • Autocomplete insertion can now be toggled to include/exclude tab and enter. [#845](https://github.com/hankinsoft/SQLPro/issues/845)
  • Improved alias scope detection. [#844](https://github.com/hankinsoft/SQLPro/issues/844)
  • Fixed an issue where query formatting could skip some objects. [#815](https://github.com/hankinsoft/SQLPro/issues/815)

New in SQLPro Studio 2022.77 (Feb 7, 2023)

  • Fixed an issue where views in postgres were being treated as tables.
  • Fixed an issue where expanding triggers in postgres could cause a crash. [#842](https://github.com/hankinsoft/SQLPro/issues/842)

New in SQLPro Studio 2022.71 (Sep 27, 2022)

  • Postgres connection string support. [810](https://github.com/hankinsoft/SQLPro/issues/810)
  • Fixed an issue with postgres connection speed. [#749](https://github.com/hankinsoft/SQLPro/issues/749)
  • Fixed an issue with snowflake and variables. [#840](https://github.com/hankinsoft/SQLPro/issues/840)

New in SQLPro Studio 2022.65 (Sep 27, 2022)

  • Fixed keyboard shortcut for search in result sets.
  • You can now re-order result columns. [#818](https://github.com/hankinsoft/SQLPro/issues/818)
  • Fixed an issue with searching and modify columns.
  • Fixed an issue with right click -> edit on some postgres result sets. [#821](https://github.com/hankinsoft/SQLPro/issues/821)

New in SQLPro Studio 2022.61 (Sep 27, 2022)

  • The truncate table dialog now includes the hostname and database details on the confirmation panel.
  • Fixed an issue with mssql IDENTITY_INSERT. [#825](https://github.com/hankinsoft/SQLPro/issues/825)
  • Added a 'find column' hotkey. [#819](https://github.com/hankinsoft/SQLPro/issues/819)
  • Added a 'make uppercase' and 'make lowercase' hotkey. [#814](https://github.com/hankinsoft/SQLPro/issues/814)

New in SQLPro Studio 2022.51 (Sep 27, 2022)

  • Shift + Enter no longer indents. [#813](https://github.com/hankinsoft/SQLPro/issues/813)
  • You can right click and 'switch to tab' on the tab bar now. [#808](https://github.com/hankinsoft/SQLPro/issues/808)

New in SQLPro Studio 2022.50 (Sep 27, 2022)

  • Fixed a crash that could occur when adding a new theme.

New in SQLPro Studio 2022.48 (Sep 27, 2022)

  • Added support for changing background color [#805](https://github.com/hankinsoft/SQLPro/issues/805).
  • Fixed an issue where a new tab may not select the proper database. [#](https://github.com/hankinsoft/SQLPro/issues/806)

New in SQLPro Studio 2022.46 (Sep 27, 2022)

  • Fixed an issue which could cause a crash when filtering results.

New in SQLPro Studio 2022.45 (Sep 27, 2022)

  • Fixed an issue where removing the default connection group could cause issues with creating and viewing existing connections.

New in SQLPro Studio 2022.37 (Sep 27, 2022)

  • Fixed an issue where move/duplicate line up/down would insert extra blank lines.

New in SQLPro Studio 2022.36 (Sep 27, 2022)

  • Fixed an issue where some users could not remove connections.

New in SQLPro Studio 2022.35 (Sep 27, 2022)

  • Fixed a crash that could occur when editing postgres foreign keys.
  • Fixed a crash that could occur with the text editor.

New in SQLPro Studio 2022.34 (Sep 27, 2022)

  • Fixed a crash that could occur when removing full words or sentences from the query editor and autocomplete was visible. [#672](https://github.com/hankinsoft/SQLPro/issues/672)

New in SQLPro Studio 2022.33 (Sep 27, 2022)

  • Fixed an issue which could cause CREATE statements to fail.

New in SQLPro Studio 2022.32 (Sep 27, 2022)

  • Fixed a crash that could occur for some users.

New in SQLPro Studio 2022.28 (Sep 27, 2022)

  • Fix for crash on setting an empty shortcut preference.
  • You can now move multiple lines with the `Shift+up` keyboard shortcut. [#763](https://github.com/hankinsoft/SQLPro/issues/763)
  • You can now duplicate the selected line(s) with the `Shift+option+up` keyboard shortcut. [#764](https://github.com/hankinsoft/SQLPro/issues/764)

New in SQLPro Studio 2022.27 (Sep 27, 2022)

  • Potentially fixed a crash that could occur with MySQL connections.
  • Added the option to set a shortcut for switching between results and messages. [#716](https://github.com/hankinsoft/SQLPro/issues/716)

New in SQLPro Studio 2022.24 (Sep 27, 2022)

  • You can now resize the history window. [#399](https://github.com/hankinsoft/SQLPro/issues/399)
  • Sidebar and window size now store properly. [#411](https://github.com/hankinsoft/SQLPro/issues/411)
  • Changing the case of a favorites name now works works properly. [#741](https://github.com/hankinsoft/SQLPro/issues/741)
  • Fixed an issue with multiple select statements not separated with semicolons when using SQL Server. [#758](https://github.com/hankinsoft/SQLPro/issues/758)
  • Fixed a crash that could occur when exporting mssql encrypted procedures. [#747](https://github.com/hankinsoft/SQLPro/issues/747)

New in SQLPro Studio 2022.20 (Sep 27, 2022)

  • Fixed an issue where multiple SQL Server statements without a semicolon could mess up delete/inserts. For MSSQL if a semicolon or go is not used to split statements, then primary keys will not be detected and the results cannot be modified. [#758](https://github.com/hankinsoft/SQLPro/issues/758)
  • Fixed a crash when exporting encrypted mssql stored procedures. [#747](https://github.com/hankinsoft/SQLPro/issues/747)
  • You can now resize the history window (and the size will persist). [#399](https://github.com/hankinsoft/SQLPro/issues/399)

New in SQLPro Studio 2022.15 (Sep 27, 2022)

  • Fixed an issue with aliases in table names when updating records. [#748](https://github.com/hankinsoft/SQLPro/issues/748)

New in SQLPro Studio 2022.13 (Mar 8, 2022)

  • Fixed an issue where some users were not having their purchases recognized.

New in SQLPro Studio 2022.12 (Mar 8, 2022)

  • Added some additional logging for removing connection groups.
  • Added some improvements to foreign key autocomplete joins.
  • Fixed snowflake schemas being displayed in the database tree when they should not be [#742](https://github.com/hankinsoft/SQLPro/issues/742).
  • Added middle click to close tables [#740](https://github.com/hankinsoft/SQLPro/issues/740)
  • Made a fix to results tab getting stuck on messages [#716](https://github.com/hankinsoft/SQLPro/issues/716)

New in SQLPro Studio 2022.11 (Mar 8, 2022)

  • Fixed an issue with connecting to snowflake on Mac silicon systems.
  • When inserting a row via MySQL, SQLite or SQL Server DEFAULT values will now be processed/displayed instantly. MySQL requires a primary key. SQL Server requires an identity field. SQLite requires rowid to be enabled.

New in SQLPro Studio 2022.10 (Mar 8, 2022)

  • Fixed an issue where MySQL foreign keys may not always load properly. [#657](https://github.com/hankinsoft/SQLPro/issues/657)

New in SQLPro Studio 2022.7 (Mar 8, 2022)

  • Diagnostics for foreign keys.

New in SQLPro Studio 2022.5 (Mar 8, 2022)

  • Exporting and scripting MSSQL tables, now includes their triggers. [#327](https://github.com/hankinsoft/SQLPro/issues/327)
  • MSSQL now includes constraints in the database tree. [#656](https://github.com/hankinsoft/SQLPro/issues/656)

New in SQLPro Studio 2021.111 (Mar 8, 2022)

  • Fixed an issue where MSSQL calculated fields were not being scripted. [#711](https://github.com/hankinsoft/SQLPro/issues/711)
  • Additional fix for crash that could occur when using the filter keyboard shortcut. [#708](https://github.com/hankinsoft/SQLPro/issues/708)

New in SQLPro Studio 2021.110 (Mar 8, 2022)

  • Fixed an issue where postgres primary keys would stop loading (causing update and delete commands to fail). [#709](https://github.com/hankinsoft/SQLPro/issues/709)
  • Fixed a crash that could occur when hitting 'Filter column'. [#708](https://github.com/hankinsoft/SQLPro/issues/708)
  • Fixed an issue where editing MSSQL tables may miss a closing bracket on default values. [#707](https://github.com/hankinsoft/SQLPro/issues/707)
  • Fixed an issue where the cancel button could take additional time. [#706](https://github.com/hankinsoft/SQLPro/issues/706)
  • Favourites have been moved to the file system.

New in SQLPro Studio 2021.104 (Mar 8, 2022)

  • Improvements for connecting to MySQL servers.

New in SQLPro Studio 2021.102 (Nov 24, 2021)

  • Fixed a crash that could occur when using menu items.

New in SQLPro Studio 2021.101 (Nov 24, 2021)

  • You can now copy results 'as update statement'. [#698](https://github.com/hankinsoft/SQLPro/issues/698)
  • Fixed an issue with MySQL where some users would be unable authenticate. [#703](https://github.com/hankinsoft/SQLPro/issues/703)
  • Added an 'Enforce SSL' preference to MySQL connections which can be Preferred, Enabled, or Disabled. [#685](https://github.com/hankinsoft/SQLPro/issues/685)

New in SQLPro Studio 2021.98 (Nov 7, 2021)

  • Oracle support has been temporary removed. (Until Oracle supports Apple Silicon). [#696](https://github.com/hankinsoft/SQLPro/issues/696)
  • SQLPro Studio now fully supports Apple Silicon (M1/M1 Pro/M1 Max). [#696](https://github.com/hankinsoft/SQLPro/issues/696)
  • Improvements for MySQL connections and SSH. [#685](https://github.com/hankinsoft/SQLPro/issues/685] and [#693](https://github.com/hankinsoft/SQLPro/issues/693)

New in SQLPro Studio 2021.92 (Nov 7, 2021)

  • Fixed a crash that could occur when modifying MSSQL tables.

New in SQLPro Studio 2021.91 (Nov 7, 2021)

  • Fix crash which could occur when altering a postgres table.
  • MySQL connections can now specify authentication method.
  • Fixed an issue some users were seeing with editing results in PostgreSQL.
  • Editing text results now has a json/xml highlight option. JSON has a pretty print and minify option.

New in SQLPro Studio 2021.80 (Oct 27, 2021)

  • Fixed a crash that could occur when opening SQLite files.
  • Exporting to CSV now includes a numeric delimiter and thousands separator option.

New in SQLPro Studio 2021.78 (Oct 27, 2021)

  • Fixed a crash that could occur when opening a SQLite file.

New in SQLPro Studio 2021.76 (Sep 8, 2021)

  • Fixed for a crash that could occur for some users during connection.
  • Fixed a crash that could occur when adding a foreign key to a postgres table.

New in SQLPro Studio 2021.75 (Sep 8, 2021)

  • Fixed a few issues with Postgres views. [#683](https://github.com/hankinsoft/SQLPro/issues/683)
  • Extra logging and possible fix for a crash that could occur for some users during connection.

New in SQLPro Studio 2021.74 (Sep 8, 2021)

  • Fixed an issue where the `Display bools as true/false` variable may not save/load properly.
  • Foreign key links are now shown in the results grid by default. The old behaviour of only appearing when moused over can be enabled by unchecking `Always show foreign keys` in Preferences -> Appearance -> Results.
  • Fixed some autocomplete issues. [#655](https://github.com/hankinsoft/SQLPro/issues/655)
  • You can now search for column names. [#601](https://github.com/hankinsoft/SQLPro/issues/601)

New in SQLPro Studio 2021.72 (Sep 8, 2021)

  • Fixed an issue where editing Postgres results may generate invalid SQL. [#671](https://github.com/hankinsoft/SQLPro/issues/671)
  • Fixed a crash some users could see shortly after startup.

New in SQLPro Studio 2021.70 (Sep 8, 2021)

  • Fixed an issue with editing MySQL triggers.
  • Added 'Script as' drop & create for MySQL trigger context menu.
  • Fixed an issue where editing favourites would sometimes not display proper syntax highlighting.
  • Fixed an issue where Snowflake schemas may not sort properly. [#668](https://github.com/hankinsoft/SQLPro/issues/668)

New in SQLPro Studio 2021.69 (Sep 8, 2021)

  • Fixed an issue with Postgres table detection. (Affects primary/foreign key loading and editing result sets).
  • Made some improvements with scripting Redshift functions.

New in SQLPro Studio 2021.68 (Sep 8, 2021)

  • Fixed a crash introduced in the last version with snowflake and oracle database tree.
  • Improvements to query formatter to use the proper indention.

New in SQLPro Studio 2021.67 (Sep 8, 2021)

  • Holding option while selecting from the database tree now includes the column names. [#662](https://github.com/hankinsoft/SQLPro/issues/662)
  • Fixed some keyword/function issues. [#655](https://github.com/hankinsoft/SQLPro/issues/655)
  • Fixed an issue with is null/is not null filters. [#659](https://github.com/hankinsoft/SQLPro/issues/659)

New in SQLPro Studio 2021.62 (Sep 8, 2021)

  • Fixed the app icon. It was slightly larger than it should be. [#627](https://github.com/hankinsoft/SQLPro/issues/627)
  • Fixed an issue where table detection may detect the wrong table if a comment proceeded the query. [#650](https://github.com/hankinsoft/SQLPro/issues/650)
  • Possibly fixed an issue where MySQL database tree may show `Unknown version`, even when the tree node was refreshed. [#647](https://github.com/hankinsoft/SQLPro/issues/647)
  • Added autocomplete/syntax highlight support for additional Snowflake functions. [#655](https://github.com/hankinsoft/SQLPro/issues/655)

New in SQLPro Studio 2021.60 (Sep 8, 2021)

  • Improvements for displaying errors in the query editor.
  • Fixed a crash that could occur when pre-loading foreign keys.

New in SQLPro Studio 2021.58 (Sep 8, 2021)

  • Fixed a crash that could occur when duplicating tables via the database tree.
  • Fix for MySQL table designer. Renaming a column and adding a column was sometimes ordered incorrectly.
  • Added an 'Advanced' -> 'Connection settings' option to MySQL connections. Timezone and timeouts can now be specified.
  • Improvements to primary key and foreign key caching.
  • Autocomplete now includes JOIN statements for foreign keys.
  • Improved Snowflake database tree performance for schemas and tables.

New in SQLPro Studio 2021.56 (Sep 8, 2021)

  • Fixed an issue with MySQL foreign key links on results grid being reversed, which would cause invalid lookups (#639).
  • Fixed some autocomplete functions. (#638, #469)
  • Improvements for Snowflake timestamp columns (#617).
  • Fixed an issue with adding MySQL columns to an existing table and re-ordering/renaming columns.

New in SQLPro Studio 2021.55 (Sep 8, 2021)

  • Fixed an issue with foreign key links in the results table view.
  • Added support for foreign key via results grid in Snowflake databases.
  • Improved support for loading Postgres foreign keys.
  • Fixed an issue where the query editors theme might not switch properly with light/dark mode.

New in SQLPro Studio 2021.53 (May 21, 2021)

  • Fixed an issue with temp tables not showing up in SQL Server.
  • Added a 'focus database tree' keyboard shortcut (CTRL-D).
  • Alias colors can now be changes via the preferences.

New in SQLPro Studio 2021.52 (May 21, 2021)

  • Added a keyboard shortcut to the `search database` tab (CTRL+F).
  • Default database search now uses fuzzy search - it will initialize to contains, but also include results which contain all all of the letters sequentially (similar to autocomplete).
  • Improvements with highlighting the selected text.

New in SQLPro Studio 2021.51 (May 21, 2021)

  • Fixed a crash that could occur when querying snowflake columns.
  • Fixed an issue with adding mysql columns via the table designer.
  • Fixed an issue with snowflake and variables.

New in SQLPro Studio 2021.49 (May 21, 2021)

  • Find in query editor will now pre-populate with selected text.
  • Autocomplete now includes partial matches for missing letters. (pkmn would match pokemon).
  • Improvements to highlighting selected word.

New in SQLPro Studio 2021.46 (May 21, 2021)

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

New in SQLPro Studio 2021.45 (May 21, 2021)

  • Fixed an issue with creating MySQL tables.

New in SQLPro Studio 2021.44 (May 21, 2021)

  • Improvements with results grid layout.

New in SQLPro Studio 2021.43 (May 21, 2021)

  • Improvement for 'Close open connections'.

New in SQLPro Studio 2021.42 (May 21, 2021)

  • Improvements to the results grid. Results grid sizing should now work better.
  • Improvements when scrolling multiple results grids.

New in SQLPro Studio 2021.39 (Apr 16, 2021)

  • Improvements to query formatting.
  • Added a 'Close open connections' menu items to server nodes. This closes all connections to the server without removing the database node.
  • Improvements for highlighting instances of your selected text.

New in SQLPro Studio 2021.38 (Apr 16, 2021)

  • Fixed an issue where scripting MySQL views could result in a view from another schema. [#610](https://github.com/hankinsoft/SQLPro/issues/610).
  • Fixes for selected word highlighting.

New in SQLPro Studio 2021.37 (Apr 16, 2021)

  • Fixed an issue with highlighting the selected word.
  • Fixed an issue with display query connection times.

New in SQLPro Studio 2021.35 (Apr 16, 2021)

  • Performance improvements for Snowflake databases.
  • You can now move connection groups up or down.
  • You can now move query lines up/down with OPTION + up/down keyboard commands.

New in SQLPro Studio 2021.27 (Apr 16, 2021)

  • Improvements with CSV import.

New in SQLPro Studio 2021.23 (Apr 16, 2021)

  • Improvements for SSL connections.

New in SQLPro Studio 2021.22 (Apr 16, 2021)

  • Resolving some issues with temporary table detection, autocomplete and syntax highlighting.

New in SQLPro Studio 2021.21 (Apr 16, 2021)

  • Autocomplete improvements.

New in SQLPro Studio 2021.19 (Apr 16, 2021)

  • Fixed an issue with updating multiple rows in an sqlite connection.
  • Queries run through the 'preview dialog' are now added to the query history.
  • Fixed an issue where if multiple schemas contains a table with the same name, only one entry would show up in autocomplete.

New in SQLPro Studio 2021.13 (Apr 16, 2021)

  • Fixed an issue with SQLite databases.
  • Postgres databases can now export tables and views to SQL.

New in SQLPro Studio 2021.11 (Apr 16, 2021)

  • Improvements to temporary table detection.

New in SQLPro Studio 2021.10 (Apr 16, 2021)

  • Added support for temp tables in autocomplete. [#454](https://github.com/hankinsoft/SQLPro/issues/454)
  • Performance improvements with the syntax highlighter (typing on larger queries will be faster).

New in SQLPro Studio 2021.09 (Apr 16, 2021)

  • Fixed an issue where duplicating connections not in the main connection group might cause 2x connections to appear. [#576](https://github.com/hankinsoft/SQLPro/issues/576).
  • Fixed a scrolling issue.

New in SQLPro Studio 2021.08 (Apr 16, 2021)

  • 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 Studio 2021.07 (Feb 9, 2021)

  • Fix for Snowflake create table from select not showing number of rows. [#491](https://github.com/hankinsoft/SQLPro/issues/491)
  • Autocomplete suggestion delay improvement. [#394](https://github.com/hankinsoft/SQLPro/issues/394)
  • Added functions and procedures to the Snowflake database tree. [#391](https://github.com/hankinsoft/SQLPro/issues/391)

New in SQLPro Studio 2021.05 (Feb 9, 2021)

  • Fixed an issue with connection groups. [#570](https://github.com/hankinsoft/SQLPro/issues/570).
  • Improvements with CSV import. [#568](https://github.com/hankinsoft/SQLPro/issues/568)
  • Added foreign keys to Oracle tables. [#564](https://github.com/hankinsoft/SQLPro/issues/564)
  • SQLite connection improvements.

New in SQLPro Studio 2021.04 (Feb 9, 2021)

  • SQLite improvement - Connections are now stored on the connection screen.
  • SQLite improvement - Connections can be edited. Aliases and tab colors are now available.
  • SQLite improvement - Restored SQLite sessions work better.
  • Fixed an issue with exporting dates to CSV.

New in SQLPro Studio 2021.01 (Feb 9, 2021)

  • Additional fix for `Query tab color does not change when changing connection (#559)`
  • Improvements to Oracle CSV importing.

New in SQLPro Studio 2020.110 (Feb 9, 2021)

  • Fixed an issue - `Query tab color does not change when changing connection`. [#559](https://github.com/hankinsoft/SQLPro/issues/559)
  • Fixed an issue - `Query results grid reverts to default scroll position (far left) after switching tabs`. [#555](https://github.com/hankinsoft/SQLPro/issues/555)
  • Fixed an issue - `Calling proc results in `Commands out of sync error.`. [#557](https://github.com/hankinsoft/SQLPro/issues/557)

New in SQLPro Studio 2020.107 (Feb 9, 2021)

  • Fixed an issue which was causing some users to see slower than expected results.

New in SQLPro Studio 2020.106 (Feb 9, 2021)

  • Autocomplete improvements when using BigSur.

New in SQLPro Studio 2020.104 (Feb 9, 2021)

  • Fixed an issue which was causing crashes for some users.
  • Changes around sha256 authentication.

New in SQLPro Studio 2020.103 (Nov 29, 2020)

  • Fixed a crash some users were seeing when exporting to CSV.

New in SQLPro Studio 2020.102 (Nov 29, 2020)

  • Fixed a crash some users could see on startup.
  • Improvements for how tab database pool works.
  • Improvements for multicursor support.

New in SQLPro Studio 2020.101 (Nov 29, 2020)

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

New in SQLPro Studio 2020.100 (Nov 29, 2020)

  • Fixed an issue where some users were seeing MySQL commands were timeout after 10 seconds.
  • Multicursor improvements.
  • Fix for a crash that could occur when running large MSSQL commands.

New in SQLPro Studio 2020.99 (Nov 29, 2020)

  • Multicursor improvements.
  • Improvements to Oracle triggers.
  • Fix for Postgres foreign tables not displaying columns.

New in SQLPro Studio 2020.97 (Nov 29, 2020)

  • Fixed an issue where triggers from other schemas were not displaying on tables. [#505](https://github.com/hankinsoft/SQLPro/issues/505)
  • Fixed a crash that could occur for some users when exporting to CSV file.

New in SQLPro Studio 2020.96 (Nov 29, 2020)

  • MacOS 10.12 or above is now the minimum version supported.
  • Fixed a crash that could occur when hitting the 'History' button on a MongoDB connection.
  • Improved the 'drop view' support when queries are run. [#523](https://github.com/hankinsoft/SQLPro/issues/523)
  • Fixed an issue where 'Drop table' was being shown rather than 'Drop view' when right clicking an Oracle view in the database tree. [#524](https://github.com/hankinsoft/SQLPro/issues/524)
  • Fixed an issue with newlines on export. [#522](https://github.com/hankinsoft/SQLPro/issues/522)
  • Fixed an issue where database role was not being saved properly. [#528](https://github.com/hankinsoft/SQLPro/issues/528)
  • Fixed a crash which could occur when running large queries. [#514](https://github.com/hankinsoft/SQLPro/issues/514)
  • Importing a CSV file now has the option to truncate the target table before importing. [#511](https://github.com/hankinsoft/SQLPro/issues/511)
  • Autocomplete with Functions and Keywords will now always default to uppercase.
  • SQLite files now appear in the 'Open Recent' file list.

New in SQLPro Studio 2020.88 (Nov 29, 2020)

  • Fixed a crash that could occur when closing tabs.

New in SQLPro Studio 2020.87 (Nov 29, 2020)

  • SQLite files now appear in the 'Open Recent' file list.
  • Fixed an issue which could cause crashes for macOS 10.11 users.
  • Fixed a keyboard shortcut issue when using Dvorak layout.
  • Fixed an issue with some triggers not appearing in the database tree. [#505](https://github.com/hankinsoft/SQLPro/issues/505)
  • Fixed an issue where exporting as Pipe would not always work. [#498](https://github.com/hankinsoft/SQLPro/issues/498)
  • Multi cursor improvements with arrow up/down cursor selection.
  • Fixed an issue with query line numbers display.
  • Fixed an issue where some MSSQL columns may be missing in the database tree.

New in SQLPro Studio 2020.83 (Sep 25, 2020)

  • Fixed a crash that could occur on the connections list window.
  • Fixed an issue where oracle connections may not run user queries successfully.

New in SQLPro Studio 2020.72 (Aug 14, 2020)

  • Fixed a performance issue with MSSQL connections.
  • Fixed an issue where when creating tables, the database tree UI may show garbage values for the table name.
  • Fixed an issue with shift + click to select text.
  • Sorting results from a 'basic select' will now use the database server to perform the sort. [#381](https://github.com/hankinsoft/SQLPro/issues/381)
  • Fixed a crash that could occur when right-clicking a result and choosing 'edit'.
  • Fixed an issue where pasting was sometimes using overwrite rather than insert. [#483](https://github.com/hankinsoft/SQLPro/issues/483)
  • Multicursor support. [#200](https://github.com/hankinsoft/SQLPro/issues/200)

New in SQLPro Studio 2020.69 (Aug 13, 2020)

  • Fixed a crash which could occur when right clicking a result and choosing 'edit'.
  • Fixed an issue where pasting was sometimes using overwrite rather than insert. [#483](https://github.com/hankinsoft/SQLPro/issues/483)
  • Multicursor support. [#200](https://github.com/hankinsoft/SQLPro/issues/200)

New in SQLPro Studio 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)
  • SQLite2 is no longer supported.
  • Added some advanced MSSQL connection options. You can now specify `Encryption level`, `Use NTLMv2` and `Enable TLSv1`.
  • 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)
  • Added COALESCE keyword (Snowflake). [#469](https://github.com/hankinsoft/SQLPro/issues/469)
  • Adding/removing/altering a table will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10)

New in SQLPro Studio 2020.61 (Aug 10, 2020)

  • Fixed insertion text for CTEs and aliases. [#296](https://github.com/hankinsoft/SQLPro/issues/296)
  • Snowflake will now display // as single line comments. [#456](https://github.com/hankinsoft/SQLPro/issues/456)
  • 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)

New in SQLPro Studio 2020.59 (Jun 17, 2020)

  • (MySQL) Fixed an issue where inserts were not always escaping columnNames. [#443](https://github.com/hankinsoft/SQLPro/issues/443)
  • 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 Studio 2020.48 (Jun 17, 2020)

  • Fixed SQLite support for RTREE. [#439](https://github.com/hankinsoft/SQLPro/issues/439)
  • Fixed MySQL foreign keys not displaying when adding a key. [#437](https://github.com/hankinsoft/SQLPro/issues/437)
  • Fixed an issue where when inserting rows, the inserted rows would not be visible once applied (until re-queried).

New in SQLPro Studio 2020.47 (May 26, 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.

New in SQLPro Studio 2020.46 (May 21, 2020)

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

New in SQLPro Studio 2020.38 (Apr 29, 2020)

  • Snowflake - Fix not displaying proper affected rows.
  • Fixed an issue where right clicking on an escaped table name in the query editor would sometimes result in a 'No object selected' issue.
  • Snowflake - Fixed an issue with signed integers being treated as unsigned.
  • MySQL - Fixed an issue where column names were not always being properly escaped when performing an update.
  • MySQL - Fixed a connection issues where some users may see 'Client does not support authentication protocol requested by server; consider upgrading'.
  • MySQL - Fixed a crash that could occur on connection.
  • Fixed an issue with keyboard shortcuts would not save properly if tab characters were used.
  • Fixed an issue where when importing from CSV, the focused table may not be defaulted.
  • Increased internal SQLite version used.
  • MSSQL - No longer setting `SET QUOTED_IDENTIFIER OFF` when updating results.
  • MSSQL - You can now specify IDENTITY details when creating a new table or adding a new column. [#374](https://github.com/hankinsoft/SQLPro/issues/374)
  • MSSQL - You can now reorder columns when creating a table.

New in SQLPro Studio 2020.35 (Apr 7, 2020)

  • [macOS/MySQL] Fixed an issue with backslashes not being escaped properly. [#393](https://github.com/hankinsoft/SQLPro/issues/393)
  • [macOS] Fixed an issue with tabs in the query editor. [#395](https://github.com/hankinsoft/SQLPro/issues/395)
  • [macOS] Improvements with the History popup. [#400](https://github.com/hankinsoft/SQLPro/issues/400)
  • [macOS] Alias improvements. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
  • [macOS] Snowflake improvements. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
  • [macOS] When modifying rows via the results-grid there is now an 'Apply' button, so that changes can be applied without needing to preview first.
  • [macOS] Fixed an issue with SQLite table editor not displaying column types in dropdown. [#398](https://github.com/hankinsoft/SQLPro/issues/398)

New in SQLPro Studio 2020.14 (Feb 24, 2020)

  • [macOS/iOS] Added support for ed25519 keys.
  • [Redshift] Support for seeing non schema bound columns in views (database tree).
  • [macOS] SSH Tunnel dialog now has a 'Validate' option to verify private key and password.
  • [macOS] Fixed a crash with autocomplete.
  • [Redshift] Fixed an issue where tables were not loading.
  • [Oracle] Fixed an issue where UUIDS may appear garbled or as NULLs.

New in SQLPro Studio 2020.08 (Feb 11, 2020)

  • 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 `Drop View` context action (in Snowflake) would try and run a drop table script. [#359](https://github.com/hankinsoft/SQLPro/issues/359)
  • Fixed an issue where dropping a postgres 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.
  • You can now create a virtual table from a CSV file (SQLite).
  • Fixed an issue where 'Create Table' menu items were missing from the database tree (SQLite).
  • Fixed a crash that could occur with the 'Format Query' action.
  • Fixed a crash that could occur when loading Postgres tables.
  • 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)

New in SQLPro Studio 2019.54 (Nov 7, 2019)

  • Fixed an issue where the previous app update was requiring license keys (I accidentally uploaded the website build rather than the App Store build). Sorry about that!
  • Fixed an issue which could cause some PostgreSQL connections to crash on connection.
  • Fixed an issue with some MSSQL connections which could crash when failing to determine default schemas.

New in SQLPro Studio 2019.09.04 (Sep 6, 2019)

  • Fixed an issue where some users could not pick the database type they wish to add.

New in SQLPro Studio 2019.09.03 (Sep 5, 2019)

  • Fixed a case where connections to a MSSQL server could fail.
  • Fixed an issue where Snowflake connections could receive 'ssl' errors on connection.
  • Fixed an issue where Snowflake connections were not handling NULLs properly.
  • Fixed an issue with Snowflake autocomplete escaping a bit too aggressively.

New in SQLPro Studio 2019.08.27 (Aug 29, 2019)

  • Resolving a hanging issues some users have been seeing.

New in SQLPro Studio 2019.07.18 (Jul 19, 2019)

  • Handoff is now supported! You can send queries from iPhone/iPad to macOS. (The latest iOS app version is required).

New in SQLPro Studio 2019.06.26 (Jul 16, 2019)

  • Fixed a crash that could occur when pasting queries overplace of existing queries.

New in SQLPro Studio 2019.06.11 (Jun 18, 2019)

  • Fixed an issue introduced in the last version where some Postgres password would fail (due to in-proper escaping).

New in SQLPro Studio 2019.05.13 (May 21, 2019)

  • You can now pick custom colors for connections.
  • Fixed a connection issue that could occur with Postgres via SSL.
  • Added SSL support for MySQL.

New in SQLPro Studio 2019.05.10 (May 16, 2019)

  • Fixed an issue with the MSSQL database tree.

New in SQLPro Studio 1.0.465 (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.
  • Fixed a crash that could occur when connecting to sample database.

New in SQLPro Studio 1.0.461 (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 Studio 1.0.454 (Apr 10, 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.
  • SQLite Specific:
  • Fixed an issue where some SQLite files would not open.
  • Fixed an issue where the 'Alter' table database tree context menu item was not available.
  • Postgres specific:
  • Fixed an issue with Postgres foreign keys designer sometimes not allowing users to add columns for mapping.

New in SQLPro Studio 1.0.452 (Apr 2, 2019)

  • General:
  • Improvements with CSV importing (specifically around handling blank/empty values).
  • Fixed an issue where 'disconnect' when filtering in the database tree would do nothing.
  • You can now print queries.
  • Postgres:
  • 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 Studio 1.0.417 (Feb 26, 2019)

  • Fixed a crash that could occur when deleting text in the query window.

New in SQLPro Studio 1.0.416 (Feb 21, 2019)

  • Working on a stability fix.

New in SQLPro Studio 1.0.409 (Feb 13, 2019)

  • Fixed a crash that was introduced in the last release. SQLPro occasionally crashed when selecting text and executing a query. Specifically if there was whitespace, followed by nothing else after the selected text.
  • Fixed an issue where the results grid context menu did not always respect dark/light appearance.

New in SQLPro Studio 1.0.405 (Feb 11, 2019)

  • Added foreign key linking in results for SQLite and Oracle.
  • Fix for MSSQL - dragging tables from the database tree will properly add schema name if required.

New in SQLPro Studio 1.0.403 (Feb 5, 2019)

  • SQLPro Studio now offers Monthly and Lifetime subscriptions (Lifetime purchase is still available as well).
  • Users who have previously purchased are automatically registered to the lifetime option. If prompted to purchase, please hit 'restore purchase'.
  • Existing license keys can now be entered into SQLPro Studio.
  • MySQL specific:
  • Support for caching_sha2_password authentication.
  • Support for geometric columns.

New in SQLPro Studio 1.0.311 (Nov 23, 2018)

  • A few Mojave improvements

New in SQLPro Studio 1.0.301 (Sep 27, 2018)

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

New in SQLPro Studio 1.0.169 (Apr 15, 2018)

  • Sample connections can now be disabled.
  • Connections can now be searched.

New in SQLPro Studio 1.0.163 (Mar 6, 2018)

  • Fixed an issue with SSH tunnelling.
  • Fixed a crash some users would see when waking MacBooks from sleep.
  • Added initial support for SQLite. (No table designer yet).
  • Added a 'script as' action for MySQL views.

New in SQLPro Studio 1.0.151 (Nov 8, 2017)

  • Fixed an issue with smart quotes.
  • Resolving a few mysql issues.

New in SQLPro Studio 1.0.127 (Aug 7, 2017)

  • Fixed an issue with keyboard navigation on results.

New in SQLPro Studio 1.0.126 (Jul 24, 2017)

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

New in SQLPro Studio 1.0.125 (Jul 22, 2017)

  • Fixed a MySQL date time issue.
  • Fixed an issue with the comment/uncomment command not adding a required space.
  • Greatly improved memory + performance when selecting results.
  • Fixed an issue where Oracle timestamp columns were not being processed properly.
  • Fixed an issue where tab style was not saving properly.
  • Fixed an issue where 'shift left' + 'shift right' (cmd + [, cmd + ]) were not using tab style.

New in SQLPro Studio 1.0.122 (May 7, 2017)

  • Fixed a crash some users would sometimes see when closing tabs.
  • Added a keyboard shortcut to move to a matching bracket (ctrl + ]).

New in SQLPro Studio 1.0.115 (Apr 3, 2017)

  • MSSQL: Fixed an issue where certain connections could freeze.

New in SQLPro Studio 1.0.107 (Feb 9, 2017)

  • Resolved a few issues with SSH tunnelling.

New in SQLPro Studio 1.0.103 (Jan 22, 2017)

  • Fixed an issue with gpu usage.
  • Fixed an issue with Postgres SSL tunnelling when multiple (10+ databases) were on the target server.

New in SQLPro Studio 1.0.88 (Nov 11, 2016)

  • MSSQL:
  • Fixed a crash when processing dates on non-english systems.