PoorSQL

With the newest version of Git 2.37.0, you can run just "git push" to push new branches. No more "--set-upstream origin". Enable with: git config --global --add --bool push.autoSetupRemote true

Hopefully last in the recent round of VS and SSMS extension updates now available: github.com/TaoK/PoorMansT… and marketplace.visualstudio.com/items?itemName…. VS2015 is again supported in the standard/current version, and SSMS compatibility issues hopefully addressed.

@mkristensen @spottedmahn Aaand, once again, never mind, Shell.Immutable.14.0 was actually resolving to v15.0.0.0 and I somehow missed it, even while I was typing the message above. All set again with the 14.0.0.0 reference.

@mkristensen @spottedmahn Thought it was working, but stuck. With Shell.14.0 (v14), Shell.Immutable.10.0 (v10), and Shell.Immutable.14.0 (v14), can't find symbol ServiceProgressData, and VS only offers Shell.Framework (v15) to fix it. Docs say Shell.Immutable.14.0 should have it... docs.microsoft.com/en-us/dotnet/a…

Hi @mkristensen - is creating two extensions the best option for supporting older versions of VS/SSMS w/o async support? Seems like a pain, no? Extension Not Loaded b/c of Deprecated Synchronous Autoload APIs · Issue #229 · TaoK/PoorMansTSqlFormatter #issuecomment-517041371" target="_blank" rel="nofollow noopener">github.com/TaoK/PoorMansT…

@mkristensen @spottedmahn Hmm, using Microsoft.VisualStudio.Shell.14.0 the async/await / base.InitializeAsync stuff seemed to get a whole lot more complicated, so I used Microsoft.VisualStudio.Shell.15.0 instead... Any advice as to how to do github.com/TaoK/PoorMansT… cleanly with Microsoft.VisualStudio.Shell.14.0?

@spottedmahn AsyncPackage was introduced in VS2015, so a split there is what I'd recommend. That means your extension supports 2015, 2017, and 2019. That currently covers over 95% of extension users and rising.

One release, and two fatal issues so far for SSMS. Manual release pipelines suck, especially when only exercised once every couple of years. SSMS Package Installer fixed, available for download as 1.6.13b. My apologies (again!) to the 200 or so ppl with bad downloads.

@jwk6 Sorry about that, fixed, and thanks for the fast feedback!

@PoorSQL The link to the Extension for CURRENT VERSIONS of SSMS (2014-18) is broken.

Finally released SSMS 18 and VS 2019 support for Poor Man's T-SQL Formatter. Sorry about the wait: architectshack.com/PoorMansTSqlFo… / github.com/TaoK/PoorMansT…

If you're stuck in PoorSql.com v1.6.10 with chrome bug bugs.chromium.org/p/chromium/iss…, There's a workaround: Settings -> Advanced Settings (bottom of page) -> Content Settings -> Cookies -> See All Cookies and Site Data -> search "poorsql" -> hit the trash icon. You're free!

PoorSql.com update: now available on HTTPS, eg poorsql.com! This also happens to be a workaround for the Chrome bug that gets you stuck on v1.6.10 of the site forever... Current version is v1.6.10b.

"Fun" Chrome bug: If you were using AppCache on an insecure origin, users your site can be stuck the version of the site they had at time of Chrome Upgrade - unrecoverable, by the looks of it! Workarounds wanted! bugs.chromium.org/p/chromium/iss…. This impacts poorsql.com

PoorSql.com bug: As AppCache is no longer supported for insecure origins in recent versions of Chrome, offline mode does not work anymore. github.com/TaoK/PoorMansT…

@databoffin Good question! Yes, in the sense that I'm hosting, checking twitter, and occasionally answering email. Yes, in the sense that I occasionally make changes to support ongoing availability eg in NPP7.6.4 and VSCode. No, in the sense that I've made no attempt to add features in years

@jonjaaay Hi @jonjaaay, you shouldn't need to download the package manually anymore since Notepad++ 7.6.4 (released today), the formatter is finally included in the Plugin Admin list. That said, the error you got is not uncommon in windows 10, you really do need to install .Net 3.5(/2).

@PoorSQL just downloaded Notepad++ 7.6.3 (64-bit) and downloaded the 64-bit zip file. Created C:\Program Files\Notepad++\plugins\PoorMansTSqlFormatterNppPlugin and placed the DLL and the folder in there. got this error as well as a Windows 0x800F0954 error.

@jahnavi_patel2 Hi, I don't have a Mac handy to test, but should be just like any other extensions. In Windows that's File -> Preferences -> Settings -> Extensions -> Poor Man's SQL Formatting. For keyboard mappings, File -> Preferences -> Keyboard Shortcuts and type "Format" in the filter.

@PoorSQL Hi. How do I configure the properties for poor SQL extension for Visual Code in MAC?

Atom plugin finally fixed after more than a year broken. Obviously I'm embarassed, but a also a little confused and relieved about how few people noticed...

@dirt_kael Sorry, the parser's all confused... I'm surprised you don't get an error highlight in fact. I would argue that a more "standard" and legible way to write this SQL would be to move the "ON B.key2 = A.KEY" bit to just after "INNER JOIN B". Existing Issue: github.com/TaoK/PoorMansT…

@PoorSQL Hi, I'm a huge fan of your sql formating tool. I use it everyday. I think I missed an option somewhere. Could you tell me if there's a way to format multiple join better ? (see picture below) Thank you very much !

@taufikshaikh @KC_College Oops, clearly I misunderstood, that was not an individual's twitter handle. Anyway, also reported by email. :)

@taufikshaikh @KC_College also just reported the same issue by email, two days ago. I had never noticed it before, but I now see that an issue had been opened back in January, that I never saw: github.com/TaoK/PoorMansT… . Don't know what the problem is, but sounds like it needs some attention.

@poorsql Not working in Sql Server 2014, shows Format T Sql code option disabled. Please help.