Category: Dart
Add Spatial Capabilities in SQLite
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.
Category: Sqlite
Add Spatial Capabilities in SQLite
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.