3 ms·
> 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
by josteink 14y ago
> 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.