Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

/proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas

Links

XODOX
Impressum

#1: MySQL anemic GIS support

Posted on 2011-10-08 04:41:20 by m5

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

=85is 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.

=85Rene=

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Report this message

#2: Re: MySQL anemic GIS support

Posted on 2011-10-08 05:17:39 by Michael Dykman

--00151773e4220fc7fb04aec1007b
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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=E9 Fournier <m5@renefournier.com> wrot=
e:

> 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
>
> =85is 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.
>
> =85Rene
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail.com
>
>


--=20
- michael dykman
- mdykman@gmail.com

May the Source be with you.

--00151773e4220fc7fb04aec1007b--

Report this message