Adding or modifying data structures that change the SQL is really tricky

[mvsjober]

The current procedure:

• add the new code according to these complicated rules - don't add any tests at this point
• compile it with make to see that it compiles
• make updateSchema
• check that the schema changes looks reasonable with e.g. git diff src/main/resources/db/changelog/db.changelog-master.xml
• run e.g. make test to generate the actual new SQL schema in the database
• now you can write your tests
• make test

We moved to SQL in order to be able to have a simple embedded database. Using mongodb was much easier for the developer. We could move back to mongodb if we e.g. standardised on using Docker for easy installations?