hankinsoft
Windows Roadmap
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.
My current roadmap is as follows:
If you have anything specific you want added, please let me know, ideally replying to this item for anything Windows specific.
@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 #3 above, I'm guessing it can't use the license I already have)~~
@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~~
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 [email protected] 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 https://github.com/hankinsoft/SQLPro/issues/311#issuecomment-600322115, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAYDTUBALWIPQUWNFPDNMELRH7XOFANCNFSM4JCRJTLA .
@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.
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 Proceduresdatabase 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.
@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 :)
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!
@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 😄
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:
- Is your host an IP address, or hostname?
- Does your hostname contain the port? (ie my host.com:1234)?
- Is your host on the internal network or external somewhere?
Thank you!
@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
@hankinsoft , log file ~~removed~~.
To answer questions:
- IP address
- Host name doesn't contain the port, but I do have a different port other than the default in the "Server port" field.
- External
Was just working in it for a while and had a couple of enhancement ideas / bugs:
- ~~Autocomplete automatically puts table and column names in all caps. Wasn't a huge deal apart from cosmetic for column names, but having incorrect table case caused queries to fail.~~ Fixed for the next build
- ~~It would be awesome to have the history feature. I use that so much in macOS.~~
- It would be great to have the ability to comment along with a shortcut for it (preferably Ctrl + /)
- ~~Sorting numeric columns in the results pane by clicking on the column header doesn't seem to sort correctly (maybe doing string sorting)?~~ Fixed for the next build
FWIW, if I try to hurry and connect to my server as soon as the connections window opens, before it's had a chance to search for each host, it will pop up with "Unable to connect to any of the specified MySQL hosts".
Log file attached. I didn't see anything helpful for sorting, but maybe for that popup and the issue above about not finding a server.
SQLPro Studio 2020.43 Windows 10 1909 MySQL 8.0.19
2020.44 submitted which contains:
- Fix for sorting numeric columns in the results pane.
- Fixed an issue with Postgres not loading tables. #392.
- Extra logging for port tester (MAYBE fixed).
I'm working on adding a preferences screen which will in addition add some of the custom keyboard shortcuts requested along with query formatting options which will fix "Autocomplete automatically ...". I'm adding quite a few preferences and have to re-create some UI (such as the keyboard shortcut selector) so it may be a bit before these are available.
@hankinsoft new log for connecting. The observable UI behavior is the same. SQLPro.log
FWIW, the macOS version detects this same server as "Online" in the connections pane without a problem.
Also, FWIW, the license key checker seems to have a bug. Whenever I enter my license key, it spins for a while, and then tells me that my license expired September 9, 2019 (the date I purchased it). Then if I click Accept and query results still display the activation message. I close the app all the way, restart it, and everything works great. If I go to the activation window, it then shows my correct subscription end / renewal date of September 9, 2020.
Also, each time the app is updated, it erases my license key and I need to re-enter it.
- Numeric sorting seems to be fixed ✅
@hankinsoft another feature request here!
Basic table editing like add row, edit row, etc. IF you want suggestions, I like how TablePlus for Windows does it.
@hankinsoft got the most recent update, which is awesome! Will post more as I find here, but I just was using it with my sister again and she hit the issue of having it crash as soon as she changed her keyboard shortcuts and hit "Apply". This was right after she had entered her license key.
I've attached the log files here. It generated a new log file each time she tried to launch it, but she was never able to open it again. It didn't ever appear in task manager, and a reboot didn't help.
Love that I can change my shortcuts! Very handy. Autocomplete casing also seems to be fixed ✅
Here's another log for the connection issues. Just to re-iterate, it doesn't really affect functionality too much. As long as I wait the few seconds for it to time out when searching for available servers, I can double-click on my server and connect right away. It's just the automatic searching / testing that seems to have an issue.
Hmm. The above (for me) was for 2020.26. Just updated to 2020.47. App launches initially, but crashes right after I double-click to connect to my server. Same for if I try to connect to sample servers.
Logs attached: 1 - Trying to connect to my server 1.log 2.log
2 - Trying to connect to Adventure Works.
I tried connecting immediately and tried waiting for the searching to complete before launching. Seemed to be the same in both cases.
EDIT: I realized those logs said my license was missing. I just went in and re-added it (and it accepted it without reloading the window!), and then tried again. Looks like the same result.
I’ve submitted .48 which will fix that crash. I added ssh tunneling to .47 and unfortunately added an issue where connections without ssh crash. Unfortunate I had a motherboard fail on me in between 2020.46 and 2020.47 and lost some uncommitted code as I don’t have my system up and running yet so my next Windows build after .48 might be delayed.
On Fri, Apr 10, 2020 at 1:28 AM Jared [email protected] wrote:
Hmm. The above (for me) was for 2020.26. Just updated to 2020.47. App launches initially, but crashes right after I double-click to connect to my server. Same for if I try to connect to sample servers.
Logs attached: 1 - Trying to connect to my server 1.log https://github.com/hankinsoft/SQLPro/files/4459863/1.log 2.log https://github.com/hankinsoft/SQLPro/files/4459864/2.log
2 - Trying to connect to Adventure Works.
I tried connecting immediately and tried waiting for the searching to complete before launching. Seemed to be the same in both cases.
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/hankinsoft/SQLPro/issues/311#issuecomment-611872117, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAYDTUADVIAZYCPVF6WYIH3RL2N5VANCNFSM4JCRJTLA .
@hankinsoft so sorry to hear about your motherboard!
Thank you for pushing that last fix. Understood. We'll sit tight for a while
I was able to get a new build posted (2020.50) with the following:
- 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.
If you get the chance, can you confirm that the 'Failed to resolve host' issue has been fixed for you?
Thanks!
@hankinsoft just got 2020.51
Love it! It instantly found my server correctly. The status dot was green the moment the windows popped up. My license key persisted and looks to have no issues, as well.
I decided to randomly test a feature I hadn't used before, and so hit "Export" on some query results. I don't know if this is by design or not, but NULL fields actually exported with the text "NULL" in them.
Glad that seems to be working! History dialog is the next item I'm tackling.
I don't know if this is by design or not, but NULL fields actually exported with the text "NULL" in them.
Yes, this is by design. In the past, I've discussed this with other users and we found NULL to be better than an empty string. That way users who parse the data can differentiate between empty string and nulls and they can treat the NULL string however they want.
@hankinsoft that's exciting to hear! The history feature is so useful.
Got it. Makes sense on the NULLs.
Just noted the updated roadmap. Looks awesome! Thanks for taking the time to document that. It's cool to see where it's already been and where it's headed.
@hankinsoft whoa, you have been busy. This is awesome! I should be doing some testing this evening.