epic-database

Do as little as possible - Only fetch the data you actually need. Use select to fetch specific fields instead of entire models. Avoid over-fetching data "just in case" - fetch what you need, when you need it.

Pragmatism over purity - Optimize queries when there's a measurable benefit, but don't over-optimize prematurely. Simple, readable queries are often better than complex optimized ones. Add indexes when queries are slow, not before.

Automatic migrations: Migrations are automatically applied on deploy via litefs.yml.

Guide on Prisma, SQLite, and LiteFS for Epic Stack Source: epicweb-dev/epic-stack.