[postgis-users] Compare SQL Server 2008 Spatial, PostGIS, MySQL functionality

[Chris Hermansen]

Martin, so polite!!!

"...do not require any magic configuration parameters"

to which the temptation to add "that no one ever gets right" is far, far
too great to pass up.

Martin Davis wrote:
> A couple of comments:
>
> Web Mapping Toolkits - the latest release of MapServer claims to
> support SQLServer (although with what actual functionality I don't know)
>
> Spatial Indexes - SQLServer does use a multi-level grid hierarchy as
> stated, but Oracle and IBM do not.  Oracle supports an R-tree index,
> and recommends using it for spatial indexing.  IBM I think uses the
> somewhat bizarre Hipparchus index (although they may also support
> something more orthodox).  A key difference between R-trees and grid
> indexes is that R-trees are self-tuning and do not require any magic
> configuration parameters.
>
>
> Paragon wrote:
>> As part of our due diligence work, we are formulating a comparison of
>> the
>> spatial functionality offered by SQL Server 2008 Spatial, PostGIS and
>> MySQL.
>> Its currently in draft, but we hope to release within the next week.
>>
>> We would appreciate if people could take a quick look at it and let
>> us know
>> if you see any gross errors or important things we left out.  Most of
>> this
>> information we curled from reading the help docs of each product and
>> from
>> our general familiarity with the databases and GIS products out
>> there.  We
>> tried to be as fair as possible.
>>
>>
>> http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_pos
>>
>> tgis_mysql_compare
>>
>> Thanks,
>> Regina and Leo
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>   
>


-- 
Regards,

Chris Hermansen         mailto:chris.hermansen at timberline.ca
tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.232.0644
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue  · Vancouver BC · Canada · V5Z 1E5