Hello! I am very new to Mongo and so I’m not at all familiar with it’s capabilities. I may be interested in switching over a project from SQL to NoSQL, but before I delve too deeply I wanted to get some opinions.
My goal is to be able to store an entire Google Maps route in a database. This would consist of an array of LatLng objects. Several thousand LatLng objects. Is Mongo capable of storing an array of this size? Is it advisable? Should I find another path forward?
A little background on what I am trying to accomplish. I am working on a ride share app. A user would be entering their departure point, destination point, and date. The database then returns all routes that match the date (as well as some other search criteria such as passenger number, etc). At this point, I need to determine which of the routes are within a particular distance to the departure and end points that the user entered.
What I am doing currently is making an Google API call for each returned route, using the route’s start and end point. I then compute the distance to this route from the API result. The problem is that the API calls are slow. On average, about 0.2 seconds per call. If I could simply get the route returned with the database query, I can reduce the processing time quite a bit.
So, is this possible using Mongo?? I should also add, that I am building the project using Laravel. Does anyone have experience running Mongo with Laravel? Is it easy to integrate? Are there other NoSQL options that might be better?
Many thanks for any input.