[postgis-users] Vertica Spatial support

[Paragon Corporation]

Greg,
>> Someone mentioned this on IRC because they were trying to use PostGIS
with
>> mindset of eventually porting to Vertica.

> That raises interesting licensing questions (assuming Vertica does not
> have a GPL-compatible license, which seems to be true).


I don't think there is any GPL issue here.  Sorry if I was unclear by the
word "port".  What the guy was interested in knowing was the portability of
his SQL statements and ease of copying data over to Vertica if he were to
choose that over PostGIS.

I think he noticed that Vertica and PostGIS/PostgreSQL  have similar looking
syntax and of course PostGIS being much cheaper to develop on.

The comment about Vertica having an ST_IsValidDetail function and geography
type is an interesting "Standard by defacto" behavior I am seeing a lot of
lately where different databases are copying each other even though the OGC
nor SQL/MM defines such things.

e.g.

SQL Server had a geography -  Paul liked that - PostGIS followed and added
a geography type. I imagine Vertica thought the same and they created a
geography type.  So now we have a pseudo standard geography type thing
sprouting up in many places.

MySQL has massive parallels to PostGIS which I'm pretty sure they did not
get from OGC or SQL/MM like their ST_GeoHash function

https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html

SpatiaLite is so much like PostGIS that I'm tempted to rewrite my book and
call it SpatiaLite (aka PostGISLite)  In Action, with some minor changes
(okay kidding a bit).


Thanks,
Regina
http://www.postgis.us
http://postgis.net






_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users