MySQL anemic GIS support

2011-10-07 Thread René Fournier
Anyone have any idea on if/when MySQL will get real GIS support?

http://mysqldbnews.blogspot.com/2007/10/does-mysql-gis-make-grade.html

…is what I'm referring to. Specifically, the factor that many functions are 
quietly replaced with MBRContains(). This makes it, for example, not possible 
to determine with certainty (in SQL) if a point lies within a non-rectangular 
polygon.

I ask because I'm looking at moving a big part of our applications to 
Postgresql, and, well, I'd rather not have to.

…Rene
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: MySQL anemic GIS support

2011-10-07 Thread Michael Dykman
Somebody feel to jump in and contradict me here, but I have never had any
love from the MySQL GIS stack.  For the very few functions it does support,
the performance has been abysmal and I generally find myself hacking
together UDFs against columns of FLOAT and avoiding POINT altogether.

 - md

On Fri, Oct 7, 2011 at 10:41 PM, René Fournier  wrote:

> Anyone have any idea on if/when MySQL will get real GIS support?
>
>
> http://mysqldbnews.blogspot.com/2007/10/does-mysql-gis-make-grade.html
>
> …is what I'm referring to. Specifically, the factor that many functions are
> quietly replaced with MBRContains(). This makes it, for example, not
> possible to determine with certainty (in SQL) if a point lies within a
> non-rectangular polygon.
>
> I ask because I'm looking at moving a big part of our applications to
> Postgresql, and, well, I'd rather not have to.
>
> …Rene
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>
>


-- 
 - michael dykman
 - mdyk...@gmail.com

 May the Source be with you.