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

SQLPro for MySQL Changelog

What's new in SQLPro for MySQL 2024.15

Apr 11, 2024
  • Performance improvements with the query editor.
  • Crash fix related to the query editor.

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

  • Performance improvements.

New in SQLPro for MySQL 2023.80 (Apr 11, 2024)

  • Fixed a crashes that could occur when removing a connection.
  • Added searching with favourite queries dropdown menu.

New in SQLPro for MySQL 2023.75 (Apr 11, 2024)

  • Added support for searching in favourites. [#950](https://github.com/hankinsoft/SQLPro/issues/950)

New in SQLPro for MySQL 2023.27 (Apr 11, 2024)

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

New in SQLPro for MySQL 2023.10 (Feb 8, 2023)

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

New in SQLPro for MySQL 2023.07 (Feb 5, 2023)

  • Improvements to connections.

New in SQLPro for MySQL 2023.02 (Feb 5, 2023)

  • Fixed an issue which could cause a crash when discarding changes to edited rows.
  • Potentially fixed a crash that could occur when cancelling mysql queries.

New in SQLPro for MySQL 2022.103 (Feb 5, 2023)

  • Fixed an issue with creating mysql tables and specifying nulls. [#860](https://github.com/hankinsoft/SQLPro/issues/860)

New in SQLPro for MySQL 2022.61 (Sep 14, 2022)

  • The truncate table dialog now includes the hostname and database details on the confirmation panel.
  • 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 for MySQL 2022.33 (Sep 14, 2022)

  • Fixed an issue which could cause crashes when connecting for some users.

New in SQLPro for MySQL 2022.26 (Sep 14, 2022)

  • Fixed an issue that could cause a crash when using the help -> search dialog.

New in SQLPro for MySQL 2021.110 (Mar 14, 2022)

  • Favorites are now stored in iCloud (or locally if iCloud is not enabled).

New in SQLPro for MySQL 2021.101 (Mar 14, 2022)

  • SSL can now be configured as Preferred, Enforced or Disabled.

New in SQLPro for MySQL 2021.76 (Mar 14, 2022)

  • Fixed a crash some users could see when connecting to server.

New in SQLPro for MySQL 2021.72 (Mar 14, 2022)

  • Fixed a crash some users could see shortly after startup.

New in SQLPro for MySQL 2021.63 (Mar 14, 2022)

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

New in SQLPro for MySQL 2021.37 (Apr 8, 2021)

  • You can now move connection groups up or down.
  • You can now move query lines up/down with OPTION + up/down keyboard commands.
  • Fixed a crash that could occur when applying database changes.

New in SQLPro for MySQL 2020.96 (Nov 22, 2020)

  • Apple Silicon support.

New in SQLPro for MySQL 2020.95 (Nov 22, 2020)

  • macOS 10.12 or above is now the minimum version supported.
  • 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)
  • Fixed a keyboard shortcut issue when using Dvorak layout.
  • Multi cursor improvements with arrow up/down cursor selection.
  • Fixed an issue with query line numbers display.
  • Fixed a crash that could occur on the connections list window.

New in SQLPro for MySQL 2020.82 (Nov 22, 2020)

  • Fixed an issue that could cause a crash when inserting/duplicating rows, deleting rows, then cancelling actions together on the results grid.
  • Added the common enter/exit full-screen keyboard shortcut. [#497](https://github.com/hankinsoft/SQLPro/issues/497).
  • Multi-cursor improvements. Cmd+Delete and Opt+Delete now work properly.
  • Fixed an issue where tables with periods were not handled properly. [#496](https://github.com/hankinsoft/SQLPro/issues/496)
  • Keyboard support added for selecting multi-cursors. Cmd+Option+Up/Down arrows.
  • Fixed a few crashes which could occur with multi-cursors.
  • Improved pasting with multi-cursors.
  • Fixed an issue when inserting rows where the string 'default' could sometimes be used rather than the default value.
  • You can now rename a MySQL column from the database tree, by right clicking the column name and choosing 'Rename'.
  • When connecting to MySQL or MSSQL server with an expired password, you can now set a password.
  • Some improvements with the autocomplete cache.

New in SQLPro for MySQL 2020.71 (Sep 21, 2020)

  • 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 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)
  • 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)
  • 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 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 MySQL 2020.59 (Jun 12, 2020)

  • Fixed foreign keys not displaying when adding a key. [#437](https://github.com/hankinsoft/SQLPro/issues/437)
  • Fixed an issue where inserts were not always escaping columnNames. [#443](https://github.com/hankinsoft/SQLPro/issues/443)
  • 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 MySQL 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)
  • Fixed a crash that could occur when updating results.
  • You can now rename tabs be either double clicking a tab title, or right clicking and choosing 'Rename'.
  • Fixed an issue which could cause crashes when updating results.
  • Fixed an issue which could cause crashes when expanding JSON results.
  • For Stored Procedures. [#432](https://github.com/hankinsoft/SQLPro/issues/432)
  • Fixed an issue where expanding triggers may display an error. [#421](https://github.com/hankinsoft/SQLPro/issues/421)

New in SQLPro for MySQL 2020.44 (May 14, 2020)

  • 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 MySQL 2020.05 (Feb 7, 2020)

  • 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 with the 'Format Query' action.
  • 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 closing tabs may not disconnect the client. [#353](https://github.com/hankinsoft/SQLPro/issues/353)
  • Fixed a crash that could when inserting a new row.
  • Fixed a crash that could occur with autocomplete.
  • Improvements to database search.
  • Fixed an issue with CSV import into existing table.

New in SQLPro for MySQL 2019.64 (Dec 12, 2019)

  • 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 MySQL 2019.07.15 (Sep 13, 2019)

  • Fixed an issue with SSH tunnel key not syncing between macOS and iOS devices.

New in SQLPro for MySQL 2019.07.03 (Jul 4, 2019)

  • Improvements when using a license key.
  • Improvements to the appearance preference tab.
  • Added a 'Pipe' delimiter option when working with CSVs.

New in SQLPro for MySQL 2019.06.28 (Jul 1, 2019)

  • Improvements when using custom tab colors.
  • Fixed a crash that could occur when scripting objects.

New in SQLPro for MySQL 2019.06.26 (Jun 28, 2019)

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

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

  • Added SSL support for MySQL connections.
  • Colors for connections has been improved (easier to tell which tab is active).
  • You can now pick custom colors for connections.

New in SQLPro for MySQL 2019.04.30 (May 16, 2019)

  • Improvements to table designer. Added unsigned option and fixed an issue with column data types.
  • Autocomplete improvement - table alias no longer need the AS keyword to be detected.
  • Added a preferences section for results grid display options.

New in SQLPro for MySQL 1.0.425 (Mar 12, 2019)

  • Stability improvements (fixed the top crashes).

New in SQLPro for MySQL 1.0.320 (Feb 7, 2019)

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

New in SQLPro for MySQL 1.0.316 (Nov 23, 2018)

  • Added a lifetime purchase option

New in SQLPro for MySQL 1.0.308 (Nov 9, 2018)

  • Fixed an issue with results display for certain column types.

New in SQLPro for MySQL 1.0.303 (Oct 16, 2018)

  • Fixed a crash that could occur when cancelling queries.

New in SQLPro for MySQL 1.0.301 (Sep 27, 2018)

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

New in SQLPro for MySQL 1.0.78 (Sep 11, 2018)

  • Select now defaults to 1,000 records rather than 100.

New in SQLPro for MySQL 1.0.76 (Aug 28, 2018)

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

New in SQLPro for MySQL 1.0.75 (Aug 9, 2018)

  • Fixed an issue with version detection.

New in SQLPro for MySQL 1.0.73 (Jul 25, 2018)

  • Fixed an issue where tabs may sometimes appear as black to some users.

New in SQLPro for MySQL 1.0.72 (Jul 23, 2018)

  • You can now specify a color for connection. Specifying a color will follow the connection through the app, such as changing the tabs color. This is a great way to identify production vs development servers.

New in SQLPro for MySQL 1.0.64 (Mar 7, 2018)

  • Improved performance and memory usage during CSV export.

New in SQLPro for MySQL 1.0.63 (Mar 6, 2018)

  • Fixed an issue with crash recovery.
  • Added a sample database for usage.

New in SQLPro for MySQL 1.0.55 (Oct 25, 2017)

  • Images are now detected in results and will display better details such as 'PNG 4.3mb'.
  • Images can now be previewed directly.
  • Fixed an issue where editing a connection may not instantly apply changes.

New in SQLPro for MySQL 1.0.54 (Sep 28, 2017)

  • We now have an iOS app! Search for 'SQLPro for MySQL' on your iOS device.
  • Added support for High Sierra.
  • Removed support for Yosemite and older.
  • Major update to results grid. Better performance and memory handling.
  • Connections now sync between devices using iCloud.
  • Fixed an issue which could cause crashes when cancelling queries.

New in SQLPro for MySQL 1.0.35 (May 5, 2017)

  • Fixed a crash when modifying results inline.

New in SQLPro for MySQL 1.0.34 (Apr 28, 2017)

  • Fixed an issue which could cause crashes for some users when closing tabs.

New in SQLPro for MySQL 1.0.27 (Oct 15, 2016)

  • Improvements for large data sets.

New in SQLPro for MySQL 1.0.26 (Oct 4, 2016)

  • Fixed an issues where some users would be unable to alter tables.
  • Improvements for Sierra.

New in SQLPro for MySQL 1.0.24 (May 27, 2016)

  • Fixed an issue where connections would sometimes not reload properly.

New in SQLPro for MySQL 1.0.23 (May 22, 2016)

  • Fixed a crash for some users when creating a new connection.

New in SQLPro for MySQL 1.0.21 (May 20, 2016)

  • Auto complete now shows column data types.
  • Added crash recovery. In the event of a system shutdown, or application cash,
  • queries should be recovered on next launch.
  • Fixed a freezing issue that could happen when selecting to the start of the previous line (cmd + shift + left keyboard shortcut).
  • Improved support for schemas in autocomplete (and syntax highlighting).
  • Fixed an issue with autcomplete that could use the previous word.

New in SQLPro for MySQL 1.0.19 (Apr 22, 2016)

  • Stability improvements.

New in SQLPro for MySQL 1.0.16 (Mar 31, 2016)

  • Performance improvements.
  • Fixed an issue with bit columns.

New in SQLPro for MySQL 1.0.13 (Jan 26, 2016)

  • Keyboard shortcuts Cmd + 1-9 can now be used to switch tabs.
  • Fixed a few issues which could cause crashes.

New in SQLPro for MySQL 1.0.12 (Nov 19, 2015)

  • Added a new connection screen.
  • Added an import csv option.
  • Fixed a crashing issue that affected some users.

New in SQLPro for MySQL 1.0.11 (Sep 7, 2015)

  • New app icon.
  • You can now inline sort query results.
  • Fixed an issue where closing an unsaved tab (and choosing save) may sometimes cause the tab to stay open.
  • Added keyboard shortcuts for switching tabs. (Cmd+Shift+[ for previous tab, Cmd+Shift+] for next tab).
  • Fixed an issue where closing many tabs quickly (cmd+w repeatedly) could cause crashes.
  • Improved multiple result-set auto resizing.
  • Added support for 'Execute current query' mode (rather than executing all queries
  • only the current query as split by delimiters will be executed).
  • Return key now works as a shortcut for the connection screen.
  • Improvements to syntax highlighting performance.
  • Fixed an issue which could sometimes cause crashes during syntax highlight.
  • Added a pully on the results view for easier resizing.
  • Added a query history dropdown, plus keyboard shortcut (Cmd-Shift-H).
  • Added a toolbar with hide/show sidebar and results options.
  • Line breaks in table results now get replaced with a ΒΆ character to make the details easier to see.
  • Query execution now stops on the first error.
  • Warning/Error icon on tab when a query fails.
  • Double clicking text in a quote (such as "helloworld" no longer selects the quotes by
  • default. You now need to be holding the alt key for the quotes to be selected.
  • Improved column display in the tree-view.
  • Copying text from the query view now includes a rich copy (specifically rtf and html
  • both get includeded).
  • Hitting space with autocomplete is visible now inserts a space rather than adds the
  • completed word. This is to match default mac (and ssms) behaviour. Rather the enter key or tab must be used to trigger completion.
  • Window size/position should now be saved through connections.
  • Mouse drag to select multiple rows in the results view.
  • Fixed an issue which could cause a crash when users filter, then modify a function.
  • Fixed an issue where cmd + right could go to the next line rather than the current line.
  • Added tab context menus 'New query tab', 'Close tab' and 'Close other tabs'.

New in SQLPro for MySQL 1.0.10 (Aug 13, 2015)

  • Fixed an issue where result line numbers are off by one on OSX 10.10.3.
  • Improvements to auto-complete.
  • You can now inline sort query results.
  • Added schema names in the database view. Schema names will appear only for entries
  • which are not in the current users default schema.
  • Added the ability to remove connections via the 'File' -> 'Remove Connection' menu item.
  • Copying text from the query view now includes a RTF and HTML copy, allowing for
  • pretty pasting into emails + other apps.
  • Fixed a crashing issue that could occur when query execution resulted in an error.
  • Fixed an issue where column data types may not appear properly for the database
  • tree, if the type is user defined.
  • Fixed an issue where closing many tabs quickly (cmd+w repeatedly) could cause crashes.
  • Fixed an issue with custom themes which could cause both background selection color
  • and the cursor color to be incorrect.
  • Fixed an issue where the 'Enable auto-closing brackets' preference could not be disabled.
  • Fixed an issue where 'Execute query in cursor range' could sometimes execute a
  • blank query.
  • Fixed an issue where searching via the database tree may not always work.
  • Fixed an issue when updating via result set that could fail due to column names
  • not being properly escaped.
  • Added a toolbar with hide/show sidebar and results options.
  • Fixed an issue where making a connection without specifying a database could sometimes
  • cause a connection failure.
  • Application window size should now be maintained between startups.
  • Materialized views are now visible via autocomplete.
  • Fixed an issue which could cause the systems dock to freeze.

New in SQLPro for MySQL 1.0.9 (Apr 14, 2015)

  • Performance improvements.
  • Improvements & bug fixes to query execution engine.
  • Fixed an issue where hash comments where not being properly handled by syntax highlighter.
  • Added line numbers to query result messages.

New in SQLPro for MySQL 1.0.8 (Mar 12, 2015)

  • Improvements to syntax highlighting and auto-complete.
  • Fixed an issue with typing non-english languages.
  • Fixed an issue in query primary key detection.

New in SQLPro for MySQL 1.0.7 (Feb 26, 2015)

  • Added single cell selection (like a spreadsheet) rather than whole row selection.
  • Connect now uses the current window if there is one, otherwise it uses a new document.
  • Added keyboard shortcut for connect button (Command-Shift-C).
  • Updated logic for the new tab shortcut.
  • Fixed a crashing issue that could happen during query editor undo/redo.
  • Fixed an issue where closing a background tab would prompt to save the current tab.
  • Fixed an issue which could cause crashes on OSX 10.7.
  • Fixed an issue when the database version failed to load.
  • Improved decimal processing.
  • Fixed an issue where connecting to localhost could cause issues.