News for hackers. Stuff that matters.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by hoodoof on Friday April 24, 2015 @01:05AM (#9431523)
It's an interesting technical achievement and serious question without trolling - is there demand for running .NET apps on anything except Windows? If you're in the .NET world why would you want to do anything else?
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by EnderMB on Friday April 24, 2015 @05:59AM (#9432260)
I'm going to offer an anecdote that isn't technical.

Like it or not, but there is a definite stigma associated towards working on Windows. Developers on HN are surprisingly open-minded towards developing on Windows, but in the real world you'll find a lot of developers that look down on those that choose Windows as their development platform.

I've met a range of devs, from those working at startups, to people who work at Google, and many of them have been extremely dismissive of not just .NET, but those that work on Windows. I've worked at a startup using ASP.NET, but I reckon many C# devs would probably rate their chances of getting a job at a big tech company to be slim and none because they favour .NET. I spoke to some ex-Googlers a while back at an event, and I asked about the Google interview process. They asked me what language I coded in, and on hearing that my main language was C# they were less than favourable about my chances. It's a shame really, because I'd quite like to work somewhere like Google, but I wouldn't want to have to hide the fact that my strongest language by far is C#.

In my mind, bringing .NET to Mac and Linux will do something that we rarely see in the development world. The Windows world will be bringing something valuable to the Linux world. The best part about this for me isn't being able to use .NET on an OS that I'd love to learn more about, but not having that niggling doubt in my head about my choice of language/framework, and I reckon a lot of .NET developers, especially younger ones will feel exactly the same.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by kstrauser on Friday April 24, 2015 @10:37AM (#9433586)
I think the perception is that you learn Windows in your university business school's IT classes and C/Python/Unix/etc. in the computer science department. It goes beyond "eww a Microsoft language" and into "just another b-school pseudoprogrammer who's going to write awful code I'll have to maintain forever". And up until very recently, choosing an MS stack meant voluntarily locking yourself into a single-vendor platform, something that horrifies most Unix hackers. C# isn't alone in this; notice that approximately 0% of F/OSS code in a typical Linux distro is in Objective-C.

I don't claim that's an accurate perception, but I've heard quite a few comments to that effect from this side of the aisle.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by stuaxo on Friday April 24, 2015 @08:09AM (#9432720)
There are basic some things that make using open tools not work very well... the following 3 seem to bubble up and stop making lots of unix dev + python tools not work:

No fork

No ansi in terminal

Seperate Select for files and Sockets on Windows..

Fix those and I bet loads of the open source tools would start working, making Windows much more attractive to X platform devs.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by EnderMB on Friday April 24, 2015 @09:36AM (#9433163)
In my eyes the problem is no longer technical, but cultural. There are a million things Microsoft could do to please developers on other platforms, but I just think that there's no changing some peoples minds. When people think of .NET developers, they think of a middle-aged man that works for a big company writing corporate code, and this is not the kind of developer that start-ups or companies like Google want in their ranks.

The moves that Microsoft are making will help validate those .NET developers that enjoy working on the framework AND want to feel like a part of the larger developer community. Technically, things will continue to improve under this direction, but what I really hope is that the per-conceived notions about .NET developers are laid to rest.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by elektronjunge on Friday April 24, 2015 @10:04AM (#9433331)
> Seperate Select for files and Sockets on Windows..

And linux has the epoll/posix aio split for sockets and files.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ohitsdom on Friday April 24, 2015 @02:42PM (#9435267)
> "Developers on HN are surprisingly open-minded towards developing on Windows"

OT, but I have not found this to be the case. Most comments on HN that mention developing on Windows are usually followed up with "Windows? Ugh", "OP must not have a choice", and other comments about how rough Windows development is.

Back on topic, as a C#/.NET developer I completely agree with your points.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by tracker1 on Friday April 24, 2015 @04:48PM (#9435919)
Imagine a decade ago telling people your favorite language was JavaScript... I've been a fan since long before "The Good Parts" was published, and still am. There are still a lot of people that are completely dismissive of it.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ghuntley on Friday April 24, 2015 @06:09AM (#9432285)
Exactly. I could not have said it better myself, matches my experiences as well.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by karmakaze on Friday April 24, 2015 @01:11AM (#9431540)
Actually being multiplatform (not just variants of Windows) has real value. From my perspective, that means being able to use F# (a sort of OCaml.NET) anywhere. That, and true competition.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by hoodoof on Friday April 24, 2015 @01:16AM (#9431554)
Feels risky, like something Microsoft might pull the plug on. Like Internet Explorer for Mac.

Microsoft has always been very stop/start about supporting other platforms - projects come and get cancelled and go.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by phaed on Friday April 24, 2015 @01:19AM (#9431564)
Your feelings couldn't be more wrong on this. Making .NET cross-platform is one of their major initiatives towards creating a more open and future-proof Microsoft and part of the foundation for the next generation of their ecosystem. It's the very reason why Core was split off of .NET. They are betting the barn on this, its not some flimsy side project.

http://blogs.msdn.com/b/dotnet/archive/2014/11/12/net-core-i...

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by BenTheElder on Friday April 24, 2015 @01:20AM (#9431565)
Well coreclr at least has 778 forks on github currently, so it will be a bit harder to pull the plug on hopefully. It's also mit licensed and has a patent promise. IANAL but it looks pretty safe, especially with the mono project picking up the code and integrating it (in theory).
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by khellang on Friday April 24, 2015 @04:08AM (#9431986)
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ghuntley on Friday April 24, 2015 @06:11AM (#9432290)
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by learc83 on Friday April 24, 2015 @02:22AM (#9431712)
A community is rapidly building around CoreCLR, and there are several companies that have a huge interest in running .Net languages on platforms other than windows (Xamarin, and Unity come to mind).
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by Moto7451 on Friday April 24, 2015 @01:15AM (#9431552)
My current project at work is .Net based and I would love to have it run on *nix, as would the rest of the tech team. All of our infrastructure is based around Linux and I've had to spend quite a bit of time porting stuff over for use on Windows. The major holdup keeping us from using Mono or CoreCLR is that the tech we've licensed is .Net based but links against the Win32 API (for silly reasons like reading XML files to boot). Hopefully the vendor will move away from that in the future.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by toomuchtodo on Friday April 24, 2015 @01:21AM (#9431569)
Wouldn't running .Net on Unix/Linux natively no longer be necessary with your .Net apps Dockerized?
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ghuntley on Friday April 24, 2015 @01:29AM (#9431592)
Develop F# (or C#) with Visual Studio and deploy into Docker on CoreOS is the bright, bright future that is rapidly becoming a reality. See you later IIS, I've hated every moment dealing with you.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ed_blackburn on Friday April 24, 2015 @03:06AM (#9431810)
Absolutely. 100% looking forward to nginx CoreClr being trivial too.

Would also be interested too tighter integration between node and CoreClr. So I can write node modules in C# / F# on deployed to posix or windows.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ghuntley on Friday April 24, 2015 @06:17AM (#9432311)
Heck, no need for nginx - just self-host using OWIN and push the web-hosting concern up a layer to be mainly one about load balancing and handling deployments.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by politician on Friday April 24, 2015 @04:06AM (#9431983)
I think we need a reddit for people interested in running the CoreCLR/CoreOS stack. And an acronym. CoreCore? 2Core? Core2Core? CLROS? Dual Core?
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ghuntley on Friday April 24, 2015 @06:12AM (#9432295)
Come up with something and I'll (and many others) will join. There's a pretty active community over at /r/fsharp already.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by Moto7451 on Friday April 24, 2015 @12:16PM (#9434292)
Yes and no. There are other little things that crop up. For example, I just built a GlusterFS based file share but Windows does not have a GlusterFS driver so I've had to settle for NFS with failover. The Gluster driver is faster in my use case and allows for simpler administration.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by WDCDev on Friday April 24, 2015 @09:53AM (#9433255)
Speaking personally, yes I am very excited about .NET on *nix platforms. I am currently working on architecting a decent sized cloud application using .NET, Django and ElasticSearch. The entire platform will be built on Linux (CentOS or Ubuntu) to control costs.

Why are we using .NET? My company's experience is primarily in .NET and we need to carefully manage discovery costs across all the platforms we are going to working on. I am going to blog about the experience when the project is set to get underway later this year, so stay tuned.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by voltagex_ on Friday April 24, 2015 @01:06AM (#9431531)
Sure - Linux VMs can be cheaper.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by jmspring on Friday April 24, 2015 @01:11AM (#9431539)
There is an interest, examine prior threads re: CLR and open source on HN.

That said, as a FreeBSD fan (my own domain runs it, I've been running servers on FreeBSD for 14+ years), I'm a bit embarrassed I didn't know about this project -- work at MSFT in an evangelism role.

Glad I learned something new to explore tonight.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by josteink on Friday April 24, 2015 @03:07AM (#9431811)
This project was (very) briefly mentioned on HN one time earlier[1], but quickly disappeared from the front-page without too much constructive attention.

In reddits /r/freebsd, there was a also some slight noise, which predated the HN-post.[2]

Apart from that, I think it's just all been happening on Github. All in all, for the little attention it managed to attract, I think we've made some good progress so far.

[1] https://news.ycombinator.com/item?id=9031570

[2] http://www.reddit.com/r/freebsd/comments/2vikrs/freebsd_buil...

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by hoodoof on Friday April 24, 2015 @01:09AM (#9431537)
What's the upside for Microsoft in that?
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by felixg on Friday April 24, 2015 @05:30AM (#9432177)
Microsoft began to suffer when they forgot that they are a software company. They were believing that they are a Windows/Office company. Those cash cows were milked to death, additionally killing everything else along the way. At some point (way later than they should have) they understood what was happening and where it leads. The solution is going back to software (and its cloud form). Sell anything, target everything. Develop for widest possible audience, but also pursue niche markets. Like Microsoft did in the '80. Another point is developer attraction. They need "cool", and this kind of hardcore hacking is cool. The new Microsoft wants to sell any software/service, no matter the hardware nor the OS. To transform from the old Microsoft to the new version, they need cool software. And who can make this happen? Cool developers.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by nbevans on Friday April 24, 2015 @01:12AM (#9431544)
The bigger picture for MS now is building out Azure. They don't care what OS you are running on Azure as long as you aren't using AWS. You know Azure is forecast to exceed the revenues of Windows and Office by 2020, right?
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by phaed on Friday April 24, 2015 @01:48AM (#9431642)
They are shifting away on their reliance of selling the OS to make their money. Putting "Windows" first was part of what was tearing Microsoft apart from the inside and was looking to leave it in the past. They no longer put that much weight on selling Windows licenses. I hear Windows 10 is even going to be a free upgrade, a la OSX.

So what they gain from all of this is getting back into the ring. It also polarizes Windows to a desktop OS (where it belongs) vs Server OS.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by xenadu02 on Friday April 24, 2015 @01:44AM (#9431626)
There is no more growth (as in ever) in the desktop PC space. It's a mature market as far as the eye can see. Upgrade cycles continue to slow.

Mobile and Cloud are where everything is happening. Amazon own(ed?) Cloud, Apple & Google own Mobile. Whole generations are growing up without using Microsoft tech even in developed countries. Which of the major tech companies to arise in the past 10 years use a Microsoft tech stack? (hint: none)

Microsoft tried to take on mobile with Windows Phone 7 and Windows 8 (Surface, Windows ARM, etc). They were all duds more or less and Microsoft was at risk of becoming completely irrelevant.

I think Microsoft's leadership (including Bill & Balmer) took a long, hard look and realized that Mobile has already past the hockey stick growth phase. At that point only the one or two competitors seen as leaders survive; Apple and Google have already won.

They were also at risk of Amazon and other hosting providers eating away at their server business by making it easier to deploy servers at the infrastructure level. Microsoft also critically lost developer mindshare; despite C# being a much better language than Java (and Oracle's mis-steps creating enormous opportunity) no one gave a shit.

There's a thing that happens in large organizations where a leader can become boxed in and unable to change direction. Balmer was clearly in that position and as someone who deeply cared about Microsoft he stepped down and gave Nadela the reigns. You can also bet Bill is backing him or he'd never be able to get away with making such drastic changes.

So what does Microsoft gain? Getting people to use their software. They'll never own the Mobile OS, so may as well accept it and move on.

People don't want to run Windows Servers? fine, run Linux on Azure. They might as well take your money since they sure aren't going to get you to switch. Why did they push Mobile Services so heavily for iOS? Why do they have Android SDKs? Because if they can't own the Mobile OS, they can at least grab a piece by being a really easy to use back-end for the app ecosystems.

And why open-source C# (Roslyn) and the CLR stack? Capitalize on Oracle's lawsuits over Java and Sun/Oracle's mismanagement of Java (and the years of stagnation Java suffered, though that has changed recently). They'd rather sell you developer tools, or make sure that cool new open-source projects start using C# so it makes it more natural to support Windows in addition to *nix/Mac.

Now that it's all MIT licensed and contains full patent promises I consider Mono a completely legit fork. That means even if Microsoft dropped it all tomorrow, Mono could still continue unfazed.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by pjmlp on Friday April 24, 2015 @03:05AM (#9431808)
> Which of the major tech companies to arise in the past 10 years use a Microsoft tech stack? (hint: none)

Game studios.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by berdario on Friday April 24, 2015 @02:42AM (#9431754)
> Which of the major tech companies to arise in the past 10 years use a Microsoft tech stack? (hint: none)

I think that maybe StackExchange qualifies

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by dikaiosune on Friday April 24, 2015 @02:56AM (#9431782)
One of the StackExchange co-founders was an ex-Microsofter.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by cmdkeen on Friday April 24, 2015 @07:51AM (#9432631)
Which links with one of the previous posts about Microsoft wanting to be "cool" to developers again. The bright sparks who will go on to found massive tech firms might join a big tech firm first for a few years - odds are they will keep a good relationship with them in their new venture. If all the startups are being founded by ex-Google, ex-Apple, ex-Facebook folk then that will only further harm Microsoft.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by mistermann on Friday April 24, 2015 @03:07AM (#9431816)
I think this comment is spot on. MS is a loooong way from losing the enterprise, but that isn't where the money (or growth as you pointed out) is anymore. They really have nothing to lose from going open, so they're best bet is to get in bed everywhere they can so they have a position to work from later if they happen to develop some advantage.

Apple is killing it on all fronts it competes on, but I wonder, will people continue to pay $800 for a new phone every 2 years, $2500 for a new laptop every 3 years? My intuition says no, but from what I read, Apple is taking more and more market share where it matters, in 1st world countries where there are actually profits to be had. I used to slag on iOs because it was so limited and primitive, but the reality is, they're probably strategically releasing features when they choose to, it's not like they're not smart enough to figure it out. If they're lazy, they could just let Google do all the expensive proving out of features, and then release a better version constantly a year behind and make a killing. Kind of like what Microsoft did for so long, except Apple has much higher volumes.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by hoodoof on Friday April 24, 2015 @01:14AM (#9431548)
To answer my own question, I guess it injects life into C# and perhaps enables them to sell more Visual Studio and maybe brings developers back into the Windows platform ecosystem. Even so, it does so at the cost of Windows server licences and potentially starts to erode the need to run Windows servers at all.

Leads me to think back to when Steve Jobs came back to Apple and one of the first things he did was kill all the Apple-licensed Mac clones.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by noelherrick on Friday April 24, 2015 @03:07AM (#9431812)
My guess is that they want to sell two things: Azure and Windows Phone via Xamarin.

Say open-sourcing .NET convinces a team or a startup to write their new app in C#. When it comes time to deploy to production, maybe they'll use Azure. VS has some Azure integrations to make it easy.

Now the team needs to write a mobile app. They have the option of using C# with Xamarin. Conveniently, you write Windows Phone apps in C# too, so maybe the team decides to target all three platforms instead of just the major two since they can get so much code reuse. A phone platform is really about the amount and quality of applications.

Sun was never able to monetize Java very well, but MS is in a little different circumstance since it has a cloud service and a mobile OS and hardware.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by cmdkeen on Friday April 24, 2015 @07:58AM (#9432665)
This. It also applies to the enterprise, all those in house data centres that are ripe to be migrated over to Azure.

Microsoft care an awful lot less that you migrated your Oracle server to Linux if you run that server on Azure...

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by tracker1 on Friday April 24, 2015 @05:03PM (#9435993)
That I my speculation as well.. when the company I work for migrated from rented hosting to cloud for easier growth, they went Azure because the existing software is all in .Net on windows... Even though new software is targetting Linux, we're staying on Azure mainly for entropy.

It's a valid strategy for keeping their corporate customers.. they have that developer mindshare, and can reduce the systems employees (SysAdmins, DBAs, etc) to boot... Too many corporate environments have dev and admin groups that are combative to eachother... "The Cloud" offers advantages in many of those environments.

I'm not saying it's for everyone, but I can see the appeal on several levels. Though working with some of the azure tools via node, it's not as bright as MS makes it out to be.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by hobs on Friday April 24, 2015 @02:10AM (#9431680)
Visual Studio 2013 Community Edition is a 100% free 100% fully featured VS.

They are definitely not trying to sell windows or vs licenses with these types of moves, give away the platform and good tools and they will make it popular and make you a lot of money in other ways.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by petecox on Friday April 24, 2015 @04:47AM (#9432085)
Unless it works flawlessly under Wine, you still need to run it within a Windows desktop.

A Windows 8.1 Pro OEM license costs around $150, which if you're building a FreeBSD desktop from scratch won't come included in the purchase price.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by hobs on Wednesday April 29, 2015 @12:37AM (#9456500)
Sure, and that is a fair point, I was just responding to the "sell more visual studio", but of course driving the windows ecosystem in some ways (online, os, whatever) is their stated goal.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by evilduck on Friday April 24, 2015 @01:24PM (#9434727)
I think MS is responding to an existential crisis.

MS seemingly got blindsided by mobile. When it comes to a consumer who is personally engaging with a computing device nowadays and not just doing it for a job, a huge number of eyes are now glued to a device that doesn't use a Microsoft operating system, apps not written in a Microsoft language, utilizing backend services not running Microsoft servers. They own a good part of the boring corporate world people mostly dislike and a decent share of gaming, but consoles are fairly evenly split and their desktop gaming monopoly is only riding on a continually dwindling amount of momentum (a large chunk of games are multi-platform releases, desktop Windows and the Xbox are popular but not necessary for gaming to continue).

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by tonyedgecombe on Friday April 24, 2015 @01:15AM (#9431551)
They are hoping to sell more Azure services on the back of all this.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by curiousDog on Friday April 24, 2015 @01:27AM (#9431583)
I think this is great because other apps like SQL Server, VS etc will now come onto the *nix stack. And there is a ton of demand for that. I for one love SQL Server.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by Alupis on Friday April 24, 2015 @02:02AM (#9431663)
> SQL Server, VS etc will now come onto the *nix stack. And there is a ton of demand for that

Doubtful SQL Server on the 'nix stack has much demand nor will it gain traction. In all OS' not Windows... Oracle, PostgreSQL and MySQL/MariaDB dominate. Not because SQL Server isn't available, but because they are all very solid very good SQL servers.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by noelherrick on Friday April 24, 2015 @02:53AM (#9431776)
I've seen a surprising amount of companies with a stack of Java/Linux for the application and SQL Server/Windows for the database. Just look at Indeed.com's job posting if you don't believe me[1]. If SQL Server was on Linux, they'd switch in a minute.

RDBMSes that you pay for are still able to out perform free, community-developed systems [2]. I've done work on both the DBA and the developer side on Postgres, MySQL, and SQL Server, and I can tell you that if platform and cost were never an issue, I'd choose the latter every time.

[1] http://www.indeed.com/jobs?q=Java+SQL+Server [2] https://www.periscope.io/blog/count-distinct-in-mysql-postgr...

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by olavgg on Friday April 24, 2015 @08:10AM (#9432727)
I've been involved in several projects with SQL Server on Windows and Java on Linux. The reason for choosing SQL Server is because that is the tool(+ Oracle) most DB administrators are familiar with.

If I could, I would choose PostgreSQL every time. But my clients do not have a person who is willing to learn to use Linux and PostgreSQL. Even fancy things like ultra fast backups with ZFS snapshots and PostgreSQL doesn't sell.

Anyway, working with SQL Server is fine, it's solid DB. But Microsoft should really invest time in a proper CLI tool that work on Linux.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by Alupis on Friday April 24, 2015 @10:43AM (#9433641)
Oracle seems to be the defacto DB at big installations, where SQL Server is common at shops that just want or already have Windows Admins.

The tools SQL Server provides are just GUI'fied versions of cmd line tools available on the other DB's mentioned here... so just saying "it's better because you can click on things" is not really a valid argument.

Not even mentioned above, but IBM's DB2 has a lot of GUI'fied admin tools as well as very robust terminal tools and a huge toolset available in the jtopen library. It's a good choice as well, although not as common in stand-alone installations (you'll encounter it more often bundled with things like as the backing db for AS/400 systems, etc)

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by WorldWideWayne on Friday April 24, 2015 @02:34AM (#9431738)
The tools for working with those are nowhere near as easy to use or comprehensive and streamlined as the SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT) / Visual Studio. I doubt they're as robust either. PostgreSQL doesn't even support returning multiple heterogeneous result-sets at the driver level.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by mistermann on Friday April 24, 2015 @02:52AM (#9431774)
Maybe I'm just not doing anything interesting (on SQL Server), but I'd appreciate you expanding on why you think it's superior. "PostgreSQL doesn't even support returning multiple heterogeneous result-sets at the driver level." - I'm not even sure what that means exactly.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by philliphaydon on Friday April 24, 2015 @03:37AM (#9431900)
SQL Server supports returning multiple result sets, i.e

select * from Product select * from Category

Then in C# you can pull out 2 different result sets and get two different collections. With 1 call to the database. So no round trips.

PostgreSQL supports multiple result sets if they contain the same columns. But the drivers don't support them. :(

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by Alupis on Friday April 24, 2015 @10:40AM (#9433605)
Seems like you ought to be doing a JOIN here, otherwise your're returning completely un-related result sets and crunching them in your app logic. It's usually best to let the DB do the data crunching and just return out what you need.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by entitycontext on Friday April 24, 2015 @03:12PM (#9435441)
Beyond retrieving the contents of several unrelated enum-like tables in one roundtrip, multiple result sets are also super-useful for grabbing a deep relationship tree of joined tables in one roundtrip.

Writing a single projected SELECT with a deep list of JOINs causes the single result set wire size to explode as you include more and more to-many relations. However, breaking up the joins into separate SELECT roundtrips to reduce wire size will increase latency.

With multiple result sets, you can take all the separate selects, stuff them up in a stored procedure, connect them with insert joins through temp tables, then return multiple result sets from the temp table contents. This gives the best of both worlds: low latency from one roundtrip and a small wire footprint.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by WorldWideWayne on Friday April 24, 2015 @11:06AM (#9433819)
It was a trivial example. Are you saying that you never write code that needs multiple un-related, un-joinable sets of data out of the database?

Even with this example - I need a list of all products and I need a list of all categories... Joining them means I have to write client code to split them up again for display.

In any case, I use this tactic a lot for CRUD apps and it makes everything quicker when I can call one stored procedure and get back 7 lists of stuff that I need to display on my page.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by Alupis on Friday April 24, 2015 @11:21AM (#9433940)
> Are you saying that you never write code that needs multiple un-related, un-joinable sets of data out of the database?

Well, I''m not going to say never, but I will say very rarely. The entire point of a RDBMS is to have related data.

> I need a list of all products and I need a list of all categories

Sure maybe, but in our ecommerce platform products have a field which is an id of a category and is linked via FOREIGN KEY. Each category has another id which is it's parent category... so you traverse upwards until you build the entire category path.

I can see wanting to eliminate a round-trip, but one could also just do two separate queries and then cache the results...

I can see why this feature might be a nice-to-have, but I don't think that single case is enough to justify using that DB exclusively (if it were that much af a demanded feature, I'd wager other DB's would have implemented it by now, especially heavy-weights like Oracle).

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by WorldWideWayne on Friday April 24, 2015 @11:38AM (#9434060)
Let the search results speak for themselves. Try doing a search for: <database-type> multiple result-sets and you will see a lot of requests on how to do it.

For instance - https://www.google.com/search?q=oracle+return+multiple+resul...

Also, have you considered that you don't really know how useful this technique can be since this features doesn't exist in the databases that you use? In any case, availability of features ultimately dictates style. (And I bet money that if you looked in your code, you'd find a lot of places with multiple trips to the database.)

When you look at the search results, you'll find that there are some kludgy ways for people to work around this limitation in Oracle, PostgreSQL and MySQL. (Actually MySQL might have this feature now.) So I'm sure plenty of people are settling for the kludge and moving on instead of complaining.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by WorldWideWayne on Friday April 24, 2015 @11:29AM (#9434001)
Another responder explained the multiple heterogeneous result-sets comment. As for the tools...they are superior in the fact that they exist because no comparable tools exists for the competing database servers as far as I can see.

For instance - SSDT is basically an IDE for creating a SQL Server Project. You use it to create your tables, procedures, functions, etc. Every object's DDL is stored in it's own file. You store that in your source repo. SSDT will diff one server-database with another server-database and generate an update script. It will diff the project's DDL with a server-database and generate an update script (or update your project's DDL from the server). It also performs data diffs so that you can make two different server-databases contain the same data (or generate an UPDATE/INSERT script).

SSMS is not an IDE, it just lets you run ad-hoc queries and provides a GUI to manage most configuration element of SQL Server. It's got a GUI to create users, roles, permissions, etc. You can start the SQL Profiler from SSMS. It's got syntax highlighting and intellisense/autocomplete for database objects.

Other databases have some of these tools, but they don't come in one unified package - you pretty much have to cobble together your own kit for other databases.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by darklajid on Friday April 24, 2015 @03:36AM (#9431896)
I'm confused. How's SQL Server related to .Net? Put differently: What does the SQL Server gain by .Net being available for other platforms?

Are there any announcements to port SQL Server?

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by politician on Friday April 24, 2015 @04:11AM (#9431996)
At the very least, CoreCLR could bring robust SQL Server client drivers to Linux/OSX.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by curiousDog on Friday April 24, 2015 @03:46AM (#9431930)
SQL Server is actually a CLR host and this functionality is heavily used by existing apps (http://en.wikipedia.org/wiki/SQL_CLR). And no, I don't think an announcement has been made. However, this shows that it might be possible!
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ximeng on Friday April 24, 2015 @03:58AM (#9431963)
I asked an MS dev evangelist about that and he said SQL Server was likely to be the slowest to move across and open up as it's practically its own operating system and the team are isolated and conservative.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by MichaelGG on Friday April 24, 2015 @01:32PM (#9434775)
Deployment on Windows is a pain. The images are big, they have a lot of reboots (once a month usually). PowerShell is yet another thing to learn/deal with (despite being nice) but the simplicity of being able to SSH/SFTP doesn't seem to be totally there - scripting is still a second-class citizen. (Try setting up IIS as a reverse proxy with no GUI.)

IIS is ... meh, a pain compared to nginx, and nginx is gimped on Windows. I'd prefer to have nginx FastCGI to an ASP.NET server than use IIS.

Windows is fantastic if you've only got a handful of machines and buy into their other management systems that tie into AD. I'm guessing for companies running Exchange and so on, it makes a ton of sense.

But deploying custom apps I've written in F# or C#, Windows only gets in the way. If the CLR ran fine on Linux, that'd remove the only real barrier (Mono's great, but it doesn't fully support ASP.NET, and has other weird edges (but I've used it in production at high volume for years.))

No doubt this was Microsoft's concern all along. But now with Azure, they figure they can make money on Linux. And at the prices they charge for VMs, they could resell Google Cloud and make a great profit. Azure's compute prices are double Google's.

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by BenTheElder on Friday April 24, 2015 @01:08AM (#9431534)
Not in the .NET world but I found it to be rather pleasent to work with in the past and I certainly wouldn't mind another option on Unixes.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by ghuntley on Friday April 24, 2015 @01:28AM (#9431587)
F# running on Unix :-)
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by hobarrera on Friday April 24, 2015 @04:52AM (#9432096)
It seems pretty obvious that this makes porting existing windows applications to nix a lot easier.

It also opens up the playing fields for .NET developers to now target nix as well (without learning a new language).

Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by skrebbel on Friday April 24, 2015 @01:21AM (#9431568)
To develop in a great language with great tools and deploy to a great OS.
Re:Microsoft .NET CoreCLR is now running on FreeBSD 10.1 (am... by Gibbon1 on Friday April 24, 2015 @06:10AM (#9432288)
Oddly enough I'm looking at the source for a command line tool, written in C# that runs under windows, but I need it to run under linux.