pirateup / tasks

0 stars 0 forks source link

reaserch of search engine #17

Open maxkokocom opened 7 years ago

4fuss commented 7 years ago

What is the purpose of this task?

allgreed commented 6 years ago

@4fuss To find suitable solution for searching the db.

I've stumbled across this: https://github.com/elastic/elasticsearch-py

Looks like fun, huh? :D

4fuss commented 6 years ago

At the moment I think we are done with this task. We are using postgis extension which gives possibility to use spatial functions in sql queries. We can run queries like: select id from store where st_distance(x, store.position) <= z, which reads as find stores which distance from point x is lower or equal to z. More about postgis: http://postgis.net/