News for hackers. Stuff that matters.
Re:Top Reasons I like Postgres Over SQL Server by josteink on Tuesday April 09, 2013 @08:03AM (#5517523)
> I'm promoting SQL here and I still have to point out that SQL handles XML like crap too, try and index an XML blob.

To be fair SQL Server has constructs for this, but they are plenty in types and awful in nature. They are even worse to understand how they work and interact together and how they will optimize your queries.

And I guess maybe that was your point?

Handling XML in SQL was "reasonable" when the option was full fledged, tripple-verbose DOM code in compiled languages. These days though, you have better ways of "shredding" XML into usable data-constructs and the desire to do anything of that sort inside the DB is definitely approaching zero.

There are no comments on this comment yet.