i'm also thinking the POSTGIS route tbh, but a very good alternative i have found is in memory geo querying with redis geo spatial, since this is for more real time notifications - https://redis.io/docs/latest/develop/interact/search-and-que...
what do you think about this.