Windows Roadmap

[jim256]

I absolutely love SQLPro Studio and have already had a few others get it based on my strong recommendation. I also really love how responsive you are and how you are always striving to make fast, significant improvements.

I use a Mac at work and Windows at home for side projects / businesses. I'd really love to be able to use SQLPro Studio for both. But, as you've said, the Windows version is behind the Mac version.

I'd love to hear about your plans for the Windows version so I can get a good idea of what to expect! Trying to decide what client to settle into on Windows for at least the next little while.

[hankinsoft]

My current roadmap is as follows:

See comment below

If you have anything specific you want added, please let me know, ideally replying to this item for anything Windows specific.

[jim256]

@hankinsoft Really looking forward to future releases here! Been trying to get by with other substitutes for SQL clients every time I use Windows (which is a LOT) and there really just aren't any that compare with SQLPro Studio.

Since you asked, I'll just throw out a few key things I'd love to see first:

• Autocomplete
• Was going to find a few more, but looks like I can't use it because I initially downloaded it a long time ago and it's wanting a license (and from your point Shift + Cmd + Left arrow should select start of line without whitespace. #3 above, I'm guessing it can't use the license I already have)

[jim256]

@hankinsoft I was recommending SQLPro Studio to my sister the other day, and she only has Windows. It made me realize that 2 other key features I'd love to see to get some basics in place and switch over to using it on my Windows machine would be:

• a few basic shortcuts (like to toggle the results pane)
• the ability to beautify / format

[hankinsoft]

Thanks! FYI I’ve almost got license key support finished and (basic) autocomplete working. License keys will work as they do on iOS/macOS - subscriptions are multi-platform and lifetime is single platform. Im hoping I’ll have those ready for next week. The two items you mentioned should be easy enough too add as well.

…

On Tue, Mar 17, 2020 at 7:02 PM Jared ***@***.***> wrote: @hankinsoft <https://github.com/hankinsoft> I was recommending SQLPro Studio to my sister the other day, and she only has Windows. It made me realize that 2 other key features I'd love to see to get some basics in place and switch over to using it on my Windows machine would be: - a few basic shortcuts (like to toggle the results pane) - the ability to beautify / format — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#311 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAYDTUBALWIPQUWNFPDNMELRH7XOFANCNFSM4JCRJTLA> .

[jim256]

@hankinsoft that really is such awesome news! Thanks so much. Very excited to try that out. Really stinks to have to use basically any other client now that I’m used to SQLPro Studio. Such a solid product.

[hankinsoft]

Sorry for the spam. I'm going to use this post a temporary 'release notes' so I don't forget what I've added for the next windows release.

Todo:

• Import for CSV/JSON files.
• Comment/uncomment (along with keyboard shortcut).
• Edit themes/fonts (preferences).
• Add additional context menu on tab bar items.
• Add missing nodes to the database tree (each database server has different nodes and in generally currently only Table and Views are available).
• Display true/false in results grid.

2020.44

• Fix for sorting numeric columns in the results pane.
• Fixed an issue with Postgres not loading tables. #392.
• Extra logging for port tester.

2020.47

• SSH tunneling.
• Preferences Window (Customize shortcuts, General Preferences, Query Formatter options).

2020.48

• Fixed crash with non ssh connections.

2020.50

• Fixed crash that could occur when copy results from the data grid.
• SSH tunnel should ping ssh server on connection window rather than actual host.
• Fixed an issue where if a connection was using an IP address rather than hostname the connection window would display 'Failed to resolve host'.
• Selecting a query in the query editor and running it, will now only run the selected text.
• Newlines in result grids will now be displayed with a ¶ symbol.
• Cells in the results data grid can now be expanded.
• Results data grid now has tooltips for cells.

2020.51

• Added some size limitations on DataGrid tooltips.
• Added word wrapping on DataGrid tooltips.
• Added word wrapping on 'expand cell details'.
• Added line numbers for 'expand cell details'.
• Improvements for initial column width's on data grids.
• Fixed SSH tunnels. (Last build broke them).

2020.52

• Fixed an issue where some valid license keys were not being consider valid.
• Added 'Dark Mode' theme.

2020.53

• Fixed an issue where maximizing the app was not quite maximized (a ~20 pixel gap was around the app).
• Fixed Bug: Switching tabs resizes results data grid columns.

2020.54

• Query History.
• Started support for additional database tree context menu items. First added is 'Drop table'.

2020.55

• Primary keys are now highlighted.
• Foreign keys are detected in results grid and can be clicked to expand into a new tab.
• Fixed an issue with the MSSQL creation dialog where the 'Save' button would not be enabled when choosing Windows Authentication.
• Added a 'close' context menu item to tabs.

2020.56

• Added Stored Procedures database tree node for MSSQL server.
• Added 'Appearance' preferences tab. It includes App Theme and Query Editor Font Size.
• Added 'Line wrap' preference.

2020.57

• Added row count to bottom of results grid.
• Added new tab button in tab bar.

[jim256]

@hankinsoft, emails from this issue are definitely the polar opposition of spam for me. I exhibited an audible “wahoo” when I saw this.

I’ll go get it now on my Windows machine and let my sister know so she can learn SQL using a solid tool :)

[hankinsoft]

The updates not out yet - will hopefully be early next week.

[hankinsoft]

The latest version of SQLPro Studio should now be available via the Windows App Store . Please leave any feedback requests, both suggestions and bug on this post for the time being. Thank you!

[jim256]

@hankinsoft Awesome! Will check it out today

[jim256]

@hankinsoft , love it! Thank you so much.

To keep things this thread, I'll put here:

• I just noticed that horizontal scrolling with the touchpad isn't working for me. When I try to pan to the left or right using two fingers on my trackpad, nothing happens. Vertical scrolling with the touchpad works fine. I'm also unable to scroll horizontally / pan using the horizontal-scroll wheel on my mouse. Up until this point, I've mostly been using TablePlus on Windows while I waited for further developments. FWIW, I remember that they hit up against the same issue. Fixed for the next build.
• I'd love to be able to customize the shortcuts or to have the results one defaulted to Ctrl + R. Added for the next build
• I tried to get a log file for you to attach in case it was useful, but when I clicked View -> Logs, Windows Explorer popped up with a "Location is not available" message, saying that the folder C:\Users[user_name]\AppData\Local\SQLPro Studio\Logs was unavailable. I navigated to AppData\Local and indeed there was no SQLPro Studio folder. Same for the AppData\LocalLow and AppData\Roaming folders. I tried creating the folder myself, but after app restart and performing a few actions, it didn't put any files inside. Fixed for the next build.
• It looks like underscore characters are being removed from column headers in the query results window. Could those be retained / displayed? Fixed for the next build.
• FWIW, in the connections window, it will display "Failed to resolve host" beneath my server, but I'm able to connect just fine by double-clicking and can run queries. Fixed

Again, thank you! Exciting to see these developments 😄

[hankinsoft]

If you get the chance, can you please update to 2020.24 via the windows App Store? This should fix:

• Horizontal scrolling in the results grid.
• Underscore characters in the results grid headers.
• The log file should now work.

Please send the log file for 'Failed to resolve host' if you get the chance, along with the following questions:

1. Is your host an IP address, or hostname?
2. Does your hostname contain the port? (ie my host.com:1234)?
3. Is your host on the internal network or external somewhere?

Thank you!

[jim256]

@hankinsoft Awesome! Absolutely; will do.
Also, I removed "Question: " from the issue title given how we're using it now in case others want to check it out

[jim256]

@hankinsoft , log file removed.

To answer questions:

1. IP address
2. Host name doesn't contain the port, but I do have a different port other than the default in the "Server port" field.
3. External