Announcing SQL Server on Linux

Re:Announcing SQL Server on Linux by johnlbevan2 on Monday March 07, 2016 @07:11PM (#11242726)

MS SQL does support XML types / allow you to use XPath in your queries. To my knowledge it doesn't do JSON; but its easy to convert between the two.

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by intrasight on Monday March 07, 2016 @08:11PM (#11242950)

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by philliphaydon on Tuesday March 08, 2016 @03:56AM (#11244190)

I wish people would stop saying this. The JSON support in SQL Server 2016 is far from being comparable to the JSON support in pgsql.

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by mmmBacon on Tuesday March 08, 2016 @09:46AM (#11245495)

Well actually it "supports" JSON as NVARCHAR. There is no JSON type and no JSONB type that supports indexing like in Postgres.

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by tracker1 on Tuesday March 08, 2016 @01:32AM (#11243842)

Nice to know, they query syntax is, unfortunately only slightly nicer than the XML options... at least at first glance.

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by jimmcslim on Monday March 07, 2016 @08:35PM (#11243039)

As the two other comments note, SQL Server 2016 will support JSON, however the extent of the support is significantly less compared to Postgresql.

This is unfortunate as I'd love to have better document-db style functionality in SQL Server.

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by sqldba on Monday March 07, 2016 @08:10PM (#11242945)

2016 supports JSON.

[ Parent | on HN ]

Re:Announcing SQL Server on Linux by philliphaydon on Tuesday March 08, 2016 @03:56AM (#11244191)

It has terrible support.

[ Parent | on HN ]