Evaluate different databases

[KonsumGandalf]

Ticket

Title: Evaluate database options for our project

Description:

We need to evaluate different database options for our project. We need to consider the following factors:

• Performance requirements
• Scalability
• Reliability

We have identified the following top popular databases according to Stack Overflow:

• PostgreSQL
• MySQL
• SQLite
• MongoDB
• Microsoft SQL Server
• Redis

Based on the following performance benchmark, MongoDB and PostgreSQL seem to be faster than the other options:

[https://arangodb.com/2018/02/nosql-performance-benchmark-2018-mongodb-postgresql-orientdb-neo4j-arangodb/]

We would also like to test SQLite, as it is a lightweight and fast database that may be a good option for our project.

Tasks:

• Test the performance of Redis, SQLite, MongoDB, and PostgreSQL for our project's use cases.
• Evaluate the scalability of each database option.
• Evaluate the reliability of each database option.

Evaluation Criteria:

• Performance: The database should be able to handle the expected workload of our project.
• Scalability: The database should be able to scale to meet the future needs of our project.
• Reliability: The database should be reliable and have a high uptime.

Deliverables:

• [ ] A report that summarizes the results of the evaluation.
• [ ] A recommendation for which database option to use for our project

[valentin-carl]

I recommend this driver + sqlx for sqlite3 + golang