Okay. Thank you for your insight. On Thu, Aug 23, 2018 at 3:06 PM Christian Ledermann < christian.lederm...@gmail.com> wrote:
> Go with geo django, postgis will accelerate these kind of lookups with > indices. > > https://stackoverflow.com/questions/19703975/django-sort-by-distance/35896358#35896358 > > On Thu, 23 Aug 2018 at 09:04, Benjamin Smith <benjaminsmith5...@gmail.com> > wrote: > >> I would like to create a market place like app with Djano as the backend >> server, where users can buy/sell items. In the app I would like have to a >> feature related to geographic region of a user. Such as, to filter out >> items in a given specific miles of radius. >> >> Example use case: >> >> - User uploads an item, get the gps cordinates from their mobile and >> store in db. >> - User can search item, also filter to only get items in X miles >> radius. >> >> >> For this feature >> >> 1. I have looked at GeoDjango. But it seems like I need to extend the >> postgresql database to use it, also by using the postgis engine. >> 2. I have also looked at the Haversine formula for nearby queries. >> 3. There is also an option for multiple database support. >> >> >> But I have some initial doubts before proceeding and your insights would >> really help me alot. Could you please help me with this queries: >> >> 1. I will have to store user data and some other data including the >> geo location. Will there be any difference/side effects between >> postgresql_psycopg2 and postgis, to store all the data in one single db? >> 2. For my simple use case would you rather prefer to go with the >> Haversine formula? Or integrating GeoDjango will help me lot in the >> future? >> 3. Or having a multiple database support be better for me or it will >> be an over head? >> >> -- >> 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+unsubscr...@googlegroups.com. >> To post to this group, send email to django-users@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/CAM4YLW%2B%2BOS%2B6JqJW5Bs211FHAHo3n6F9sHW0B%2BeN%3DPE4OEGR9g%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CAM4YLW%2B%2BOS%2B6JqJW5Bs211FHAHo3n6F9sHW0B%2BeN%3DPE4OEGR9g%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > Best Regards, > > Christian Ledermann > > Newark-on-Trent - UK > Mobile : +44 7474997517 > > https://uk.linkedin.com/in/christianledermann > https://github.com/cleder/ > > > <*)))>{ > > If you save the living environment, the biodiversity that we have left, > you will also automatically save the physical environment, too. But If > you only save the physical environment, you will ultimately lose both. > > 1) Don’t drive species to extinction > > 2) Don’t destroy a habitat that species rely on. > > 3) Don’t change the climate in ways that will result in the above. > > }<(((*> > > -- > 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+unsubscr...@googlegroups.com. > To post to this group, send email to django-users@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/CABCjzWp8hxN0JbdSqk8-c18ZaV_7GCSukOpt-31MeZBK5DhgGA%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CABCjzWp8hxN0JbdSqk8-c18ZaV_7GCSukOpt-31MeZBK5DhgGA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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+unsubscr...@googlegroups.com. To post to this group, send email to django-users@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/CAM4YLWL3JoSAd87Do6OTkiDPtCoy7Xxja2M0A9NwY9dRvf93Yw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
