database-implementation

Database schema design, migrations, and query optimization using SQL, Exposed ORM, and Flyway.

• Design database schemas and migrations
• Optimize SQL queries with indexes and constraints
• Use Flyway for versioned schema changes
• Manage ORM entity mappings and relationships

• Supports schema design and migration patterns
• Includes validation and rollback strategies
• Provides migration examples (create, add column, FK, junction)
• Offers query optimization techniques (indexes, JOINs, EXPLAIN)
• Includes test cases for migration and constraint validation
• Addresses common blockers like data type mismatches and FK cycles

1. 1.Check task tags: database, migration, schema, sql, flyway, exposed, orm, query, index, constraint
2. 2.Run flyway commands: migrate, clean, validate, info
3. 3.Verify schema matches design with tests and constraints
4. 4.Apply migration patterns (create table, add column, FK, junction)
5. 5.Test migrations with Kotlin unit tests and constraint checks