spbolton
commented
8 months ago Database setup and configuration can tack onto the existing flyway db management within quarkus and the configurator app. The current initial db script is set up here. db/migration/V1.0.0__InitSchemas.sql. By adding new scripts using the flyway naming convention we can update the existing database table but also create and update our new table we need.
Rather than manually create and update the SQL we need to add here, we can make use of the automatic creation during development by setting the database generation mode e.g.
quarkus.hibernate-orm.database.generation = drop-and-create
Before deployment the ddl for the schema of the new table can be extracted and added to a flyway migration script. Therefore this task does not need to be done until the entity has been defined and tested by the developer and ready to commit.
github-actions[bot]
Parent Issue
https://github.com/dotCMS/core/issues/27130
Task
The metrics data will be stored in a Postgres DB separate from the Experiments data and DB. The metrics DB will be set up using Aurora
Proposed Objective
Core Features
Proposed Priority
Priority 2 - Important
Acceptance Criteria
Have the new DB configured, up & running to store the Metrics data.
External Links... Slack Conversations, Support Tickets, Figma Designs, etc.
No response
Assumptions & Initiation Needs
No response
Quality Assurance Notes & Workarounds
No response
Sub-Tasks & Estimates
No response