Database Comparison - HU-ICT-LAB/RobotWars GitHub Wiki

Purpose of this article

In this article you'll find information about different database(& storage) solutions, a comparison between them and our pick.

Requirements & Options

Database requirements

We only really have a few requirements. We need to save files and actions & corresponding findings that the RoboMaster collects during it's training period. For the files we need something like a file storage cloud and for the actions & corresponding findings any form of database will satisfy. It's also important that the service is free and not too complicated since we want to keep this part quite simple and clear.

Different solutions we will talk about:

  • Google cloud
  • Azure
  • AWS
  • Heroku
  • Oracle cloud
  • Firebase

We will give some pro's and cons per option and at last our pick.

Azure

  • Azure is a paid service after 12 months of free use. For our project this won't be a problem but since other students will possibly continue with this project it will be a problem.

AWS

  • Database service is free.
  • We have access to the aws academy program via school.
  • One downside is is that we only have 100$ budget per account, this will maybe lead to the issue that we will need to migrate the database to another account to get a new 100$ budget.

Heroku

  • The ready-made service of Heroku is postgresql, should be sufficient for our needs.
  • There is no file storage in the ready-made service. this will be a problem since we will need to create our own solution and that will take unnessecairy time.

Firebase

  • Has it's own free (realtime)database system.
  • Has free file storage which is linkable to the database.
  • Our software developer has worked with this before.
  • Connection with python might be a bit hard.
  • The max limit of data stored is 1Gib, this will be a problem.

Oracle cloud

  • Same functionalities as firebase.
  • Connection with python is hard since oracle is mainly uses for Java.

Google cloud

  • Same functionalities as firebase.
  • Creditcard needs to be added to the account.
  • May be a bit too complex for our needs.

Our pick

Google cloud, Oracle cloud and Firebase are good options for our needs. Our first option would actually be FireBase but since the max storage limit is so low it won't work for us. The next best option will be AWS because we will have 100$ credit per account without needing to use a creditcard.

Sources:

Google. (2021). Firebase Documentation. Firebase Docs. Visited on 10 november 2021, from https://firebase.google.com/docs

Heroku. (2021). Fully Managed Database as a Service - PostgreSQL | Heroku. Visited on 10 november 2021, from https://www.heroku.com/postgres

Microsoft. (2021). No-SQL Database Azure. Microsoft Azure. Visited on 10 november 2021, from https://azure.microsoft.com/nl-nl/free/cosmos-db/search/?&ef_id=Cj0KCQiA-K2MBhC-ARIsAMtLKRvYbGEINoajCo_5rGgeWlKy7Z8PVOl6AqBcCBv62-Lo2onRTqNEknUaAr1gEALw_wcB:G:s&OCID=AID2200221_SEM_Cj0KCQiA-K2MBhC-ARIsAMtLKRvYbGEINoajCo_5rGgeWlKy7Z8PVOl6AqBcCBv62-Lo2onRTqNEknUaAr1gEALw_wcB:G:s&gclid=Cj0KCQiA-K2MBhC-ARIsAMtLKRvYbGEINoajCo_5rGgeWlKy7Z8PVOl6AqBcCBv62-Lo2onRTqNEknUaAr1gEALw_wcB

Google. (2021b). Google Cloud documentation | Documentation. Google Cloud. Visited on 10 november 2021, from https://cloud.google.com/docs

Amazon. (2021). AWS Database. Amazon Web Services, Inc. Visited on 10 november 2021, from https://aws.amazon.com/free/database/?trk=ps_a134p000007ChVwAAK&trkCampaign=acq_paid_search_brand&sc_channel=PS&sc_campaign=acquisition_BEN&sc_publisher=Google&sc_category=Database&sc_country=BEN&sc_geo=EMEA&sc_outcome=acq&sc_detail=amazon%20cloud%20database&sc_content=Cloud%20Database_e&sc_matchtype=e&sc_segment=548919005925&sc_medium=ACQ-P|PS-GO|Brand|Desktop|SU|Database|Solution|BEN|EN|Text&s_kwcid=AL!4422!3!548919005925!e!!g!!amazon%20cloud%20database&ef_id=Cj0KCQiA-K2MBhC-ARIsAMtLKRsLmQ73QTthhgPqNH2EOnc2GAX23AVeLGhBrNKjV1qwU_JU8_JIwwcaAgG5EALw_wcB:G:s&s_kwcid=AL!4422!3!548919005925!e!!g!!amazon%20cloud%20database

Oracle. (2021). Oracle cloud. Oracle cloud. Visited on 2021, from https://www.oracle.com/nl/cloud/

Related Issues:

Issue: 86