SQLPro Studio 2020.08

A simple, powerful database manager for macOS – SQLPro Studio is the premium database management tool for Postgres, MySQL, Microsoft Management Studio and Oracle databases.

Multiple database support
SQLPro supports many database types including MySQL, MariaDB, Postgres, Microsoft SQL Server (2005 and above) and Oracle (8i and above).

BEST AT THE BASICS
Table creation, custom queries, auto-complete and syntax highlighting are just some of the features you can expect. Updating or designing a table? We can help you out.

INTUITIVE INTERFACE
SQLPro boasts an intuitive interface, where the most basic to advanced database needs are easily accessible.

CLOUD SUPPORT
Working with cloud providers such as Amazon relational database service, Microsoft Azure or Heroku? No problem, SQLPro Studio supports most cloud based instances.

MULTIPLE RESULT SETS
Need to see the results for multiple tables at once? You can execute multiple queries and have the results for each displayed at the same time, including any errors and messages.

NO JAVA REQUIRED
SQLPro is a 100% native Mac app. This means it can and will outperform any of the other Java based database management interfaces.

SINGLE CELL SELECTION
Work with results using single (or multi) cell selection, similar as a spreadsheet. Rather than requiring full-row selection as many other tools use, SQLPro allows you to select one or more cells at a time.

What’s New:

Version 2020.08

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)