News for hackers. Stuff that matters.

A comment on Announcing SQL Server on Linux. Parent comment

Re:Announcing SQL Server on Linux by nailer on Monday March 07, 2016 @06:51PM (#11242647)
> SQL Server <-> PostgreSQL is the closest commercial to open source comparison (core database engine-wise) I can think of.

Can you store / query JSON-like data in SQL server? I'd like to be able to store a structured object and query a keypath.

[ Parent | on HN ]
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.

http://blog.sqlauthority.com/2012/04/27/sql-server-introduct...

[ Parent | on HN ]
Re:Announcing SQL Server on Linux by intrasight on Monday March 07, 2016 @08:11PM (#11242950)
SQL 2016 does JSON https://blogs.msdn.microsoft.com/jocapc/2015/05/16/json-supp...
[ 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 ]
Re:Announcing SQL Server on Linux by jamespo on Tuesday March 08, 2016 @04:44AM (#11244350)
Dumping a load of JSON into an RDBMS makes CJ Date cry
[ Parent | on HN ]
Re:Announcing SQL Server on Linux by balakk on Tuesday March 08, 2016 @06:15AM (#11244644)
And it probably makes Fabian Pascal go postal :)
[ Parent | on HN ]