...
- replace all ElementCollections with Converters (Minimum change with Minimum improvement):
- A lot of small Jsons
- Using longtext, we are be able to maintain compatibility with MariaDB
- Minimum Java code impact
- 50% of tables (as _PROPERTIES, _META ) will be removed
- Unit tests not need to change
- ToscaServiceTemplace as Json String:
- One big Json
- Using jsonb only PostgreSQL, will be supported
- Medium Java code impact: all persistence classes could be removed or have to be equal to original model
- 90% of tables will be removed
- Unit tests need PostgreSQLContainer
- Cassandra
- Document oriented approach , no converters needfull supported by SpringBoot (not needs Converters)
- Huge Java code impact: All repositories and all persistence classes have to change
- No support for MariaDB and PostgreSQL anymore
- Unit tests need an Embedded Cassandra Server (EmbeddedCassandraServerHelper or CassandraContainer)