[omaha] Python inside of SQL Server

[Wes Turner]

How does this compare to PostgreSQL PL/Python?

# PL/Python

- https://www.postgresql.org/docs/9.6/static/plpython.html
- https://hub.docker.com/_/postgres/

$ docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d
postgres
# tcp:5432 (the postgres port)


http://stackoverflow.com/questions/31755130/pl-python-with-anaconda
- $PYTHON/--with-python=condaenv/bin/python


# SQL Server

- Python in T-SQL
- conda installs on all the DB nodes?

https://hub.docker.com/r/microsoft/mssql-server-linux/

$ docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=yourStrong(!)Password' -p
1433:1433 -d microsoft/mssql-server-linux


https://hub.docker.com/r/microsoft/mssql-server-windows/

https://hub.docker.com/r/microsoft/mssql-server-windows-express/



On Tuesday, April 25, 2017, Mike Hostetler via Omaha <omaha at python.org>
wrote:

> I found this interesting:
>
> https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/
> 19/python-in-sql-server-2017-enhanced-in-database-machine-learning/
>
> First they ported SQL Server to Linux and now embedded Python inside  of
> it.
>
> --
>   Mike Hostetler
>   mike at hostetlerhome.com <javascript:;>
> _______________________________________________
> Omaha Python Users Group mailing list
> Omaha at python.org <javascript:;>
> https://mail.python.org/mailman/listinfo/omaha
> http://www.OmahaPython.org
>