Flisk vs Prisma, Drizzle, Atlas and dbmate
These define and run migrations. Flisk runs them in a migrator resource before the API starts.
| Task | Flisk Local dev stack | Prisma Schema and migrations (v8 RC) | Drizzle TypeScript ORM | Atlas Schema as code | dbmate SQL migrations |
|---|---|---|---|---|---|
| Add an ORM to a service | flisk resource api --type backend --feature prismaflisk resource api --type backend --feature drizzlePrisma also adds a migrator resource |
No equivalent
Install drizzle-orm and drizzle-kit, then add drizzle.config.ts |
Not needed
Atlas is not an ORM, so there is nothing to add |
Not needed
dbmate is not an ORM, so there is nothing to add |
|
| Create a migration from schema changes | No equivalent
Flisk runs migrations, it does not write them |
prisma contract emitprisma migration planIn Prisma 7: prisma migrate dev, which also applies it |
drizzle-kit generate |
atlas migrate diffNeeds --to and --dev-url, or --env |
Different job, closest command.
dbmate newCreates an empty file; you write the SQL |
| Apply migrations | drizzle-kit migrate |
atlas migrate apply |
|||
| See migration status | Different job, closest command.
flisk statusShows the migrator resource, not each migration |
prisma migration statusIn Prisma 7: prisma migrate status |
No equivalent
|
atlas migrate status |
dbmate status |
| Reset the database | No equivalent
|
No equivalent
Not in Prisma 8. In Prisma 7: prisma migrate reset |
No equivalent
|
atlas schema cleanRemoves every object; run migrate apply to rebuild |
dbmate dropdbmate upNo reset command: drop the database, then recreate it |
| Browse the data | No equivalent
|
drizzle-kit studio |
No equivalent
|
No equivalent
|
|
| Read the schema from a database | No equivalent
|
prisma contract inferIn Prisma 7: prisma db pull |
drizzle-kit pull |
atlas schema inspect |
dbmate dumpWrites the schema to db/schema.sql |
| Check migrations | No equivalent
|
prisma migration checkDetects hand-edited or deleted migration files |
drizzle-kit checkChecks generated migrations for collisions |
atlas migrate lintatlas migrate validatelint analyzes changes; validate checks checksum and SQL |
No equivalent
|
| Seed data | No equivalent
|
No equivalent
|
No equivalent
|
No task matches. Try a shorter search.
- Same job
- Different job: closest command, not a swap
- Blank: no equivalent
- Hover a cell for ↗︎ source and i note. Click a command to copy it.