2023.40
2023-11-07
+ Autocomplete improvements.
+ Fixed a crash some users were seeing.
2023.39
2023-05-05
+ Added SQLite support.
+ Added the legacy 'enable compression' option for mysql connections.
2023.15
2023-02-15
+ Editing now provides custom keyboard for numbers and floating values. [#677](https://github.com/hankinsoft/SQLPro/issues/677)
2022.60
2022-08-17
+ Fixed an issue with Setapp support.
2022.25
2022-04-06
+ Improvements to ssh tunnelling.
2022.18
2022-03-31
+ Improvements for automatic reconnections.
2022.16
2022-03-21
+ Fix for Setapp accounts not working properly.
2022.15
2022-03-15
+ Updated internal frameworks.
2021.81
2021-10-08
+ iOS 15 improvements.
2021.80
2021-09-21
+ iOS 15 improvements.
2021.01
2021-01-08
+ Adding a favourite will now default to the query entered in the query editor.
2020.91
2020-10-28
iOS 12.0 or higher is now required
+ Added Cmd+O as an open file shortcut.
+ Fixed a display issue with iPhone 12 devices.
+ Added support for handling expired passwords in MSSQL and MySQL.
2020.76
2020-09-30
+ Fixed a crash some users would see on launch.
2020.75
2020-09-01
+ Some improvements with the autocomplete cache.
+ Fixed an issue where the 'export' popup may not be fully visible.
2020.72
2020-08-15
+ MSSQL improvements.
+ Extra logging.
2020.69
2020-08-12
+ Resolving an issue with autocomplete.
2020.68
2020-08-09
+ Fixed a few crashing issues.
+ Fixed an issue where autocomplete could sometimes remove newlines. [#481](https://github.com/hankinsoft/SQLPro/issues/481)
+ Fixed an issue with postgres object names beginning with a number were not properly escaped.
2020.65
2020-07-29
+ Fixed an issue with object names beginning with a number that were not properly escaped (in Postgres).
+ Fixed an issue where updating MySQL tables with keywords for the table name would fail.
+ Added COALESCE keyword for Snowflake. [#469](https://github.com/hankinsoft/SQLPro/issues/469)
+ Improvement with SSH tunneling. Previously, every connection created a new tunnel. Now tunnels can be reused.
+ Performance improvements for autocomplete cache (was causing slowdowns on startup for some users). [#468](https://github.com/hankinsoft/SQLPro/issues/468)
2020.62
2020-07-10
+ Improvements with syntax highlighting.
+ Autocomplete now supports multiple databases.
2020.61
2020-07-09
+ Snowflake will now display // as single line comments.
+ Fixed a crash some MSSQL users would see.
+ Fixed insertion text for CTEs and aliases.
2020.60
2020-06-24
+ Improved support for Setapp.
+ 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)
+ MSSQL - Fixed an issue where 'Modify' or 'Script as Alter' may display CREATE rather than alter for Stored Procedures. [#432](https://github.com/hankinsoft/SQLPro/issues/432)
+ Snowflake - Improvements with cancelling snowflake queries.
+ Snowflake - Fix for Snowflake not displaying proper affected rows. [#407](https://github.com/hankinsoft/SQLPro/issues/407)
+ Snowflake - Fixed an issue with signed integers being treated as unsigned. [#410](https://github.com/hankinsoft/SQLPro/issues/410)
+ 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.
+ Alias improvements. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
+ Improvements for ipv6 addresses. [#380](https://github.com/hankinsoft/SQLPro/issues/380)
+ Result messages now uses the same font size as the query text editor.
+ Result messages are now monospaced.
+ Result error messages are now more of a 'whiteish-pink' when using a dark theme (a bit easier on the eyes).
2020.24
2020-03-06
+ Improvements with intelligence.
+ Improvements with MySQL table designer.
2020.10
2020-02-15
Autocomplete improvements:
+ Autocomplete is now context sensitive (suggestions will be based on the tables entered).
+ Autocomplete now includes partial match suggestions (previously online included begins with). iPad only.
+ Fixed an issue where the autocomplete window could 'twitch' when using the Smart Keyboard to navigate between items (iPad).
Snowflake:
+ Fixed an issue where the Warehouse specified was not always being used.
+ Role can now be specified.
2019.65
2019-12-04
+ Support for properly displaying Zerofill attributes in MySQL.
+ Support for editing Zerofill in MySQL.
+ Booleans can now be forced to display as bool/false via preferences.
+ Booleans now display as colourful (green/blue) with a preference too disable.
2019.46
2019-10-22
+ Improvements for connecting to Postgres 12 servers.
+ Fixed an issue which could cause a crash when editing rows.
+ [MSSQL] Fixed an issue where datetime(2) fields were not properly displaying milliseconds.
2019.09.16
2019-09-17
+ Support for iOS 13.
2019.09.12
2019-09-12
+ Support for iOS 13.
2019.09.06
2019-09-07
+ Fixed an issue where expanding columns would sometimes fail for Postgres databases.
2019.09.03
2019-09-05
+ Fixed an issue that could occur with some MSSQL connections.
+ Fixed an issue with Snowflake not properly displaying NULLs.
+ Fixed an issue with Snowflake connections displaying an SSL error.
2019.08.28
2019-08-29
+ Fixed an issue with displaying bitfields in MySQL.
2019.08.13
2019-08-14
+ Fix a crash that could occur with Handoff.
+ Improved compatibility for future versions of iOS.
+ Fixed an issue where empty mysql string results could display NULL instead of a blank.
2019.07.19
2019-07-20
+ Fixed a crash that could occur when getting list of MySQL databases from the server.
2019.07.18
2019-07-18
+ Handoff support (you will need the latest macOS version of the app as well).
2019.07.08
2019-07-09
PostgreSQL related:
+ Fixed a bug which could cause crashes when tapping on a foreign key.
+ Notices are now available in the query message results tab.
+ Fixed an issue where functions list may be blank.
2019.05.15
2019-05-17
+ Added Snowflake database support.
+ You can now duplicate connections.
+ MySQL column defaults can now be altered via the table designer.
+ MySQL column unsigned can now be altered via the table designer.
+ Fixed an issue with editing MSSQL column defaults.
2019.05.10
2019-05-11
+ Fixed an issue where the progress spinner may remain active on the database tree.
+ MSSQL now has a table designer - You can edit & create new tables.
+ Improvements for table alias autocomplete support when writing queries.
1.0.405
2017-11-09
+ Added a format query option. To format a query tap '...' when a query is visible and choose 'Format query'.
1.0.404
2017-11-09
+ Fixed a security issue with the password settings.
1.0.403
2017-11-09
+ Added a browse option when creating /editing servers. Selection this option will scan your local network for Postgres & MySQL servers (browse already exists for MSSQL), making a quick and easy way to find your database servers.
+ Fixed an issue where autocomplete would not trigger after an 'INSERT INTO' statement.
1.0.402
2017-11-09
+ Fixed an issue with the results grid font size. It was being saving it as a bool rather than integer, causing it be 0 or 1 upon app startup.
1.0.401
2017-11-09
+ The default 'SELECT FROM' limit has been raised from 100 to 1,000.
+ Improvements to syntax highlighting (better performance + larger text handling).
+ Fixed a bug with 'delete rows'.
Many display options have been added in the 'Settings' -> 'Display' section.
+ Query editor font size can now be customized.
+ Query editor line numbers can now be disabled/enabled.
+ Results can now be resized (font size + padding).