How to make a selection from places that are 10 km away?

I

Ivan Huk2020-07-27 18:49:46

PostgreSQL

Ivan Huk, 2020-07-27 18:49:46

There is a table with restaurants with longitute, latitude columns. And a mobile application that receives the geolocation of the client. The task is to sort the list of restaurants by separation from it.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

ky0, 2020-07-27
@ky0

Take PostGIS - and write.

Similar questions

A

Alexander Vtyurin2015-11-17 13:48:21

Optimizing objects.all() for a huge database. How to get everything and not freeze for N minutes? 3Reply

I

Ivan Ivanov2018-03-26 16:07:24

Which database will be larger, mysql or postgresql? 0Reply

S

Stanislav Gordienko2015-11-22 01:31:22

How to create database and user in Postgresql from script? 0Reply

Z

Z0nd0R2015-11-24 00:47:45

How to make a sorted selection by TTL? 1Reply

F

furyon2015-11-25 10:31:40

Why FOREIGN KEY without CONSTRAINT? 1Reply

Didn't find what you were looking for?

Ask your question