Skip to content

PostgreSQL/MySQL Database Migration #22

@dmccoystephenson

Description

@dmccoystephenson

Replace H2 in-memory database with PostgreSQL or MySQL for production persistence.

Acceptance Criteria:

  • Add PostgreSQL/MySQL driver dependency
  • Create production database schema
  • Update application.properties with production database config
  • Add Flyway or Liquibase for database migrations
  • Create migration scripts for initial schema
  • Configure connection pooling (HikariCP)
  • Test database connectivity and performance
  • Document database setup instructions
  • Add database backup strategy

Estimated Effort: 2-3 days

Dependencies: None

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions