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

O

Oklick2016-12-23 02:05:16

How to get records where params ->> 'price' is greater than a given number in PostgreSQL(jsonb)? 2Reply

A

Alexander2021-01-19 10:36:53

What's wrong with the request, error: "error: syntax error at end of input"? 2Reply

S

shushpanio2019-05-22 12:43:30

Is it possible to implement the launch of bash on the fact of an insert in the database? 1Reply

O

orbit0702019-05-25 10:20:39

Why are there so few database connections on 1GB of RAM? 1Reply

S

Sergey2021-01-21 15:54:53

What is the algorithm for developing a client-server application? 3Reply

Didn't find what you were looking for?

Ask your question