The .NET CoreCLR is now open source, so I ran the GitHub repo through Microsoft Power BI
The hits keep on coming, Dear Reader. Just as we announced a few months back, .NET Core is open source. We said it would run on Windows, Mac, and Linux, but then the work of doing it has to actually happen. ;)
Go check out the .NET Framework Blog. Today the .NET team put the Core CLR up on GitHub. It's open source and it's under the MIT License. This includes the Core CLR source, the new RyuJIT, the .NET GC, native interop and everything you need to fork, clone, and build your own personal copy of the .NET Core CLR. What a cool day, and what an immense amount of work (both technical and legal) to make it happen. Years in the making, but still lots of work to do.
The GitHub repo has 2.6ish MILLION lines of code. They say when it's all said and done.NET Core will be about 5 MILLION lines of open source code.
The .NET Blog did a nice pie chart, but honestly, I found it to be not enough. It basically was a big grey circle that said "other 2.2M." ;)
I'd like a little more insight, but I don't know if I have the compute power, or the patience, frankly, to analyze this code repository. Or do I?
I decided to import the repository into Microsoft Power BI preview. Power BI (BI means "Business Intelligence") is an amazing service that you can use (usually for FREE, depending on your data source) to pull in huge amounts of data and ask questions of that data. Watch for a great video on this at http://friday.azure.com this week or next.
I logged into http://powerbi.com (It's US only for the preview, sorry) and clicked Get Data. I then selected GitHub as the source of my data and authorized Power BI to talk to GitHub on my behalf. Crazy, AMIRITE?
_4fa2af42-7c1e-465a-8d55-8626ee736588.png "Screenshot (10)")
What does Power BI tell me about the .NET Team's "CoreCLR" GitHub repository?
Here's what Power BI told me.
Let's dig in. Looks like Stephen Toub has worked on a LOT of this code. He's super brilliant and very nice, BTW.
Editing the query and looking at Dates and Times, it seems the .NET Team commits code at ALL hours. They are really feeling "committable" around 3 to 4 pm, but they'll even put code in at 4 in the morning!
Here's a more intense way to look at it.
One of the insanely cool things about Power BI is the ability to ask your data questions in plain English. Given that my SQL abilities have atrophied to "Select * from LittleBobbyTables" this is particularly useful to me.
I asked it "issues that are open sorted by date" and you'll notice that not only did it work, but it showed me what I meant underneath my query.
What about issues closed by a certain person?
I'm running around in this tool just building charts and asking questions of the repo. It's all in HTML5 but it's just like Excel. It's amazing.
Open issues from last year?
Average time to close an issue in hours?
It's amazing to be running queries like this on something as significant as the now open-sourced .NET Core CLR. I didn't need to be an employee to do it. I didn't need special access, I just did it. I'm enjoying this new Microsoft, and very much digging Power BI. Next I'm going to put my Blood Sugar and Diabetes Data in Power PI and encourage others to do the same.
P.S. Check out the code for the Core CLR Hello World app. When was the last time you saw an ASCII Art Linux Penguin in Microsoft Source code? ;)
Sponsor: Big thanks to Infragistics for sponsoring the feed this week! Responsive web design on any browser, any platform and any device with Infragistics jQuery/HTML5 Controls. Get super-charged performance with the world’s fastest HTML5 Grid – Download for free now!
About Scott
Scott Hanselman is a former professor, former Chief Architect in finance, now speaker, consultant, father, diabetic, and Microsoft employee. He is a failed stand-up comic, a cornrower, and a book author.
About Newsletter
Thanks for being such an open source on Microsoft matters.
I noticed that some of the links in your RSS feed don't work properly.
It appears to me that the redirection doesn't support https urls and therefore we end up on feedblitz's "404 Not Found" page. It could also be solved by removing "http://feeds.hanselman.com/~/t/0/0/scotthanselman/~" from the links in the RSS feed.
(you remember RSS feeds? Those xml-ish versions of your blog's content, we raved about in the early 00s?)
Too bad it's US only for now. I'll definitively try PowerBI (desktop version) on an Azure SQL database to see what I can find out :-)
More importantly: Love the XKCD reference!
I would love to run my customer's data through Power BI! I am most definitely going to check it out when it becomes available to the rest of us.
I keep getting the message "Sorry, that didn't work. There's a problem on our end. We're working on it, so try again later."
Is this still in alpha or beta?
"Got a bug?"
"Let me just recompile the CLR.... there you go"
oops, something went wrong
Failed to store data for new tile
Activity Id 138424df-21eb-4185-9e26-73b195f2ba09
Request Id 687eec49-4af4-3664-abcf-e2edbffcec32
Error Code 400
Time Wed Feb 04 2015 18:50:26 GMT-0500 (EST)
Version 11.0.9165.681
Cluster URI https://wabi-us-east2-redirect.analysis.windows.net
PowerBI is much more powerful than what you demoed here I presume, but thanks for the demo!
And Power BI looks dope :)
Screenshot: http://cl.ly/image/2j2k1D133x36/Image%202015-02-08%20at%207.09.22%20PM.png
Comments are closed.
-- Lee