Summary

Transition the current database migration system from Alembic (SQLAlchemy) to a TypeScript-based ORM (Prisma or Drizzle) to align with a potential unification of the backend under the Svelte frontend framework.

Background

Currently, the project uses Alembic for managing schema migrations within the Python-based backend. However, if the backend moves towards a full SvelteKit-based architecture, using a TypeScript ORMfor database interactions would simplify development and reduce cross-language dependencies.

Objectives

• Assess Prisma and Drizzle and others as potential replacements.
• Plan a structured migration from Alembic to the selected ORM.
• Integrate migration checks into the frontend container (instead of as an external manual process)
• Add seed scripts and tests for migration
• Update relevant documentation and setup guides. Fill in missing policies in documentation, especially around db schema branching.
• Include fix for Remove unused columns from user table #70