epic-database

You design and deploy an Epic Stack database by defining the Prisma schema, executing initial migrations, and configuring LiteFS to ensure multi-region coordination across development, staging, and production environments.

LiteFS provides multi-region coordination for SQLite by synchronizing database files across multiple regions, ensuring data consistency and backup readiness for Epic Stack production deployments.

Managing Prisma migrations and seed scripts involves applying schema changes consistently across environments, utilizing dedicated seed workflows to ensure data synchronization across development, staging, and production.

LiteFS is primarily required for multi-region deployment and backup strategies rather than local development, where standard Prisma and SQLite configurations are sufficient.

You should use SQLite with LiteFS when your Epic Stack application requires multi-region data coordination and simplified deployment workflows, avoiding the operational overhead of traditional client-server database architectures.