Research: Compare DB alternatives: MongoDB & MySQL

[OrAbramovich]

Following the discussion we had on the weekly meeting (06.11.2017) and the research about MongoDB and ElasticSearch we have to decide between two candidates: MongoDB and MySQL so we have to read about MongoDB & MySQL and make a comparison between them in order to answer the question what is the best DB for our purposes. All information has to be documented here. (Note - there is an issue about MongoDB - #16 ).

The comparison should include the following criteria:

• The ability & ease of storing geo-location data.
• Performance & scalability.
• Dependencies & minimal system requirements - does it meet the server side delivered product (see Design: Choose the delivered product #4 )?.
• Integration with the selected programming language (see Design: Choose programming language & framework to be used in the project #6 ).
• Does it meet the must have features as defined in Design: determine DB engine must-have features #20

[OrAbramovich]

I collected the information I read and wrote a ~20 pages tutorial about: MongoDB and the integration of it with Java - see the relevant comment in #16

[alonttal]

thanks @OrAbramovich.
i close this issue since we all agreed we're going to use Mongo.