Microsoft Will Support Python In SQL Server 2017 (infoworld.com)

There was a surprise in the latest Community Technology Preview release of SQL Server 2017. An anonymous reader quotes InfoWorld: Python can now be used within SQL Server to perform analytics, run machine learning models, or handle most any kind of data-powered work. This integration isn't limited to enterprise editions of SQL Server 2017, either -- it'll also be available in the free-to-use Express edition... Microsoft has also made it possible to embed Python code directly in SQL Server databases by including the code as a T-SQL stored procedure. This allows Python code to be deployed in production along with the data it'll be processing. These behaviors, and the RevoScalePy package, are essentially Python versions of features Microsoft built for SQL Server back when it integrated the R language into the database...

An existing Python installation isn't required. During the setup process, SQL Server 2017 can pull down and install its own edition of CPython 3.5, the stock Python interpreter available from the Python.org website. Users can install their own Python packages as well or use Cython to generate C code from Python modules for additional speed.
Except it's not yet available for Linux users, according to the article. "Microsoft has previously announced SQL Server would be available for Linux, but right now, only the Windows version of SQL Server 2017 supports Python."

Comments

Always catching up to PostgreSQL!

[Anonymous Coward]

PostgreSQL has had Python support for years. It also has R support.

But to be fair to SQL Server, it is a very good RDBMS. Both SQL Server and PostgreSQL make MySQL look really, really, really bad. Even SQLite is making MySQL look pathetic these days!

a little late to the party

[ooloorie]

You've been able to use Python for a while in Postgres, MySQL, SQLite, and even DB2.

I can't quite figure out why anybody would want to use Microsoft SQL Server.

Re:a little late to the party

[DogDude]

I can't quite figure out why anybody would want to use Microsoft SQL Server.

Easy to use. Works well. Tons of features. Free to a point. After that, inexpensive.