How PostGIS can help SQL Server users?

I may be a gonzo or it’s just that today I didn’t have my notorious 4th coffee in my favourite Winnie The Pooh cup I got from Pantera on our 14th (or 15th?) anniversary we celebrated a month ago, so…

Apparently, there are situations in which PostGIS could be an affordable anti-GML vaccine jab. It seems there is a potential market for PostGIS to conquer. Perhaps it wouldn’t be estimated as profitable as the H1N1 but who knows what will happen if no one takes a brave stand and stop GML designers! Here I’d eagerly conclude with one of the famous Scottish sentences :-)

Back to the subject matter. Today, I spotted an interesting question on the StackOverflow archives: Is it possible to export spatial data from Sql Server 2008 in gml2 format?. Natively? No, there is no such solution. Presumably, Microsoft thinks forward and thinks GML 2 is a legacy standard. Fair enough, someone has to draw a line between prehistoric and modern, somewhere. Why Microsoft? Again?

Facing such a tremendous suffer Microsoft exposed SQL Server users to, I suggested to visit the “underworld” for a while and hire PostGIS to do the dirty job.

Paraphrasing Andrei Alexan­dres­cu‘s, hysterically famous recently, sentence: SQL Server should go!.

My first question to StackOverflow

Recently, I’ve got a bit sucked in by the StackOverflow and related communities. Even if I don’t completely understand how it is supposed to be different to my favourite old-school-but-still-the-best communication channels to share knowledge, meaning Usenet and mailing lists. Web X.Y generally sucks! I never liked the idea of Web discussion boards – doesn’t feel user-friendly for me at all and it’s way more time consuming to participate in discussions on such boards than in mailing lists. The idea of StackOverflow works for me, somehow. A couple of times I got sucked quite deeply and stole two or three ours of my sleep to take the challenge, to benchmark my brain a bit.

After lurking and kicking my own axons, it’s time to nudge stackoverflowers with my first question. Here we go:

Which macro to wrap Mac OS X specific code in C/C++