4 ms·
> 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 dat
by nailer 11y ago
> 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.
- johnlbevan2 11y agoMS 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-introduction-to-discovering-xml-data-type-methods-a-primer/ http://blog.sqlauthority.com/2012/04/27/sql-server-introduct...
- sqldba 11y ago2016 supports JSON.
- philliphaydon 11y agoIt has terrible support.
- intrasight 11y agoSQL 2016 does JSON https://blogs.msdn.microsoft.com/jocapc/2015/05/16/json-support-in-sql-server-2016/ https://blogs.msdn.microsoft.com/jocapc/2015/05/16/json-supp...
- tracker1 11y agoNice to know, they query syntax is, unfortunately only slightly nicer than the XML options... at least at first glance.
- philliphaydon 11y agoI wish people would stop saying this. The JSON support in SQL Server 2016 is far from being comparable to the JSON support in pgsql.
- mmmBacon 11y agoWell actually it "supports" JSON as NVARCHAR. There is no JSON type and no JSONB type that supports indexing like in Postgres.
- jimmcslim 11y agoAs 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.
- jamespo 11y agoDumping a load of JSON into an RDBMS makes CJ Date cry
- balakk 11y agoAnd it probably makes Fabian Pascal go postal :)