A few days ago, I wanted to add spatial features to my backend. I wanted to store the GPS positions of users and return the closest people to them (like a dating app).

Usually, people use PostgreSQL and PostGIS, an extension that enables spatial capabilities, but that’s not something I want. My backend is using SQLite because I’m not expecting more than 10 users a day.

Fortunately, there is an extension that we can use called Spatialite.

A few days ago, I wanted to add spatial features to my backend. I wanted to store the GPS positions of users and return the closest people to them (like a dating app).

Usually, people use PostgreSQL and PostGIS, an extension that enables spatial capabilities, but that’s not something I want. My backend is using SQLite because I’m not expecting more than 10 users a day.

Fortunately, there is an extension that we can use called Spatialite.