Migrate from mysql to postgreSQL

[leonard1thecoder]

Request to migrate the application's database from MySQL to PostgreSQL. This migration aims to improve scalability, compatibility, and potential cost-efficiency. Tasks involved may include:

• Analyzing existing MySQL schema.
• Planning PostgreSQL schema migration.
• Data migration strategy and tooling.
• Testing application compatibility with PostgreSQL.
• Updating deployment/configuration scripts.
• Documenting migration steps and rollback plan.

[leonard1thecoder]

• Created supabase account
• created db
• coonected successful tothe db
  HikariPool-1 - Starting...
  2025-11-26T10:23:09.445+02:00 INFO 13540 --- [AA] [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@2059f785
  2025-11-26T10:23:09.454+02:00 INFO 13540 --- [AA] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
  2025-11-26T10:23:10.950+02:00 INFO 13540 --- [AA] [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
  Database JDBC URL [Connecting through datasource 'HikariDataSource (HikariPool-1)']
  Database driver: undefined/unknown
  Database version: 17.6
  Autocommit mode: undefined/unknown
  Isolation level: undefined/unknown
  Minimum pool size: undefined/unknown