Hacker News new | past | comments | ask | show | jobs | submit login
Drawbridge: What SQL Server on Linux is built on (threedots.ovh)
59 points by tech234a 3 days ago | hide | past | favorite | 15 comments





A little background info:

For the last couple of decades, Microsoft SQL Server only ran on Windows.

Microsoft aspires to take licensing money from shops that run Oracle (which is much more expensive), and those shops often prefer to run Linux on their servers. To help win over those customers, they needed to run SQL Server on Linux.

Drawbridge is the layer that enables that to happen.

There hasn't been a lot of public material about it, and SQL Server on Linux didn't get much of an adoption rate, so there hasn't been much incentive for the community to dig into it, either.

Adoption's probably going up on developer workstations now that SQL Server runs in containers and now that Microsoft's put a lot of work into Azure Data Studio, a database development tool that runs on Linux & Mac & Windows.


From the Drawbridge link of the article:

> Drawbridge is a research prototype of a new form of virtualization for application sandboxing. Drawbridge combines two core technologies: First, a picoprocess, which is a process-based isolation container with a minimal kernel API surface. Second, a library OS, which is a version of Windows enlightened to run efficiently within a picoprocess.

So does this mean that the 'library OS' translates WinAPI to Linux?


The slide deck provides the answer. (and that page too)

I'll take that as a yes. TL;DR

I for one hope that Azure Data Studio becomes the VSCode of SQL Editors and supports more database servers.

The plugability is there. And contributors have been working on that as well.


> I for one hope that Azure Data Studio becomes the VSCode of SQL Editors and supports more database servers.

It already supports MySQL, PostgreSQL, and Microsoft SQL Server.


Cool! How do I enable MySQL support?

This issue led me to believe it's not implemented yet: https://github.com/Microsoft/azuredatastudio/issues/4904

And search for MySQL or MariaDB on extensions marketplace gives me zero results.


Regarding licensing, I’ve wondered why AWS RDS for SQL server is more expensive than Oracle RDS (this surprised me).

Any ideas why that is?


I assume because AWS has to run SQL Server on real Windows machines and Amazon couldn't negotiate a good licensing rate from MS.

That's what AWS claims. Supposedly you can reduce SQL Server costs on AWS with bring your own license (BYOL) deals with Microsoft.

On the other side too: Oracle has been extremely vocally defensive against Azure (it's a giant competitor with nearly as good a salesforce, and it's a possible slippery slope to companies finding out Microsoft Dynamics offers a lot of direct competitors to the corporate management dog and pony shows that gets Oracle's foot in the door [accounting, CRM, etc]). There's been rumors that Oracle has made sweetheart licensing deals with AWS as an attempt at bulwarking against Azure dominance.


> Drawbridge is a research prototype of a new form of virtualization for application sandboxing.

I had trouble grokking the headline. For others: Microsoft SQL Server on Linux runs on Drawbridge virtualization. This is about Drawbridge.


Odd since SQLServer was Sybase, which ran on Unix.

Yeah, but that was 25 something years ago. When they stopped collab, they stopped needing to have code that ran on Unix.

True indeed! MS SQL Server is derived from Sybase, but the fork occurred decades ago. I don't know exactly when, but probably in 1990's?

Here's the actual slide deck that the short blog posts links to: https://threedots.ovh/slides/Drawbridge.pdf



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: