Mysql GeoDjango Distance search

42 views
Skip to first unread message

Karesh Arunakirinathan

unread,
Nov 25, 2016, 9:08:09 AM11/25/16
to Django users

Is there any pure Django/faster way to get the distances less than x km. I have the model

class Products(models.Model):
    title = models.CharField(max_length=10)
    point = models.PointField(srid=32140, null=True, blank=True)

So I want to search the products less than x km from the persons view in mysql.? Because distance less than is only supported in postgresql. I want to do in mysql database. Thanks

Could anyone help please ?

Sergiy Khohlov

unread,
Nov 27, 2016, 2:58:16 PM11/27/16
to django-users
MySQL  does not have  this support. I've tested few  potential solution but most of them have a hige problem with performance.

Many thanks,

Serge


+380 636150445
skype: skhohlov

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b914da61-bffc-4591-98d3-84d919420764%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

bart

unread,
Nov 28, 2016, 9:14:36 AM11/28/16
to django...@googlegroups.com
Het ip adres vertelt ongeveer waar iemand woont. 

Groet,
Bart



Wysłano z telefonu Samsung

-------- Oorspronkelijk bericht --------
Van: Sergiy Khohlov <skho...@gmail.com>
Datum: 27-11-16 20:57 (GMT+01:00)
Aan: django-users <django...@googlegroups.com>
Onderwerp: Re: Mysql GeoDjango Distance search

To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.

To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
Reply all
Reply to author
Forward
0 new messages