Setup Database - Githubissues

rdsaliba / notorious-eng

2 stars 5 forks source link

Setup Database #51

Closed PaulMicu closed 3 years ago

PaulMicu commented 4 years ago

As a dev, I need a place to store all the system and sensor information in a secure database.

Setup an internal database and connect it into the application.

Acceptance Criteria:

[x] Setup internal database
[x] Document which database is implemented and why

Notes; H2, Derby, HSQLDB are possible solutions.

JayChouteau commented 3 years ago

DBMS work session summary (all assignees present):

H2, Derby, MariaDb, HyperSQL, MySQL all seem very similar and all connect to a Java application through JDBC
blocking: is there any limitations to the pool of SQL DBMS we can choose from ?
blocking: is there any limitation to using a NoSQL DMBS?

DBMS comparator

najimgh commented 3 years ago

Able to test and connect a dummy java project to MySQL.
Will try and connect MySQL to the project

PaulMicu commented 3 years ago

As discussed in our meetings, MySQL will not work for our project we need an embedded database, MySQL is cannot be embedded into our java application, please choose one from the 3 mentioned in the ticket

najimgh commented 3 years ago

Able to implement and test H2 as well as HSQLDB as an embedded in-memory database.
H2 is preferred over HSQLDB due to its ease of implementation and better documentation.
Documentation on both databases and why we chose H2 is on confluence

Shirwarsame commented 3 years ago

Link to documentation: https://notorious-eng.atlassian.net/wiki/spaces/DOCUMENTAT/pages/136249345/H2+or+HSQLDB+using+JDBC+API

najimgh commented 3 years ago

Changed to MariaDB as per Product owner's request