my current task is to enhance an already active web application with Permissions. for doing so I need to persist multiple tables:
Users groups Roles Products
I will have small amounts of data, (a few dozen lines) but multiple tables. the question is, what is the best database to use in such a scenario? thought about h2 since its in-memory and can save images in case the server is down not all of the data is getting lost.