Analyze options for managing migrations

[nanotaboada]

Description

Evaluate different tools for managing database migrations in the FastAPI project. The primary options to explore are Alembic and Prisma Client. Each tool should be analyzed for its ease of use, compatibility with SQLAlchemy, and feature set.

Acceptance Criteria

• Research and compare Alembic and Prisma Client for managing migrations.
• Document key differences, advantages, and drawbacks of each.
• Propose a recommended migration tool based on findings.
• If a migration tool is chosen, create a follow-up issue for implementation.

Resources

• 🔗 Alembic Documentation
• 🔗 Prisma Client Documentation

[SachinPrasanth777]

Why alembic and not prisma-client-py?

[nanotaboada]

Hi @SachinPrasanth777! That's a great question :)
Would you mind elaborating pros/cons of prisma-client-py?