drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: Stable migration SQL file name

Open
#5,421 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Feature hasn't been suggested before.

- [x] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

https://github.com/drizzle-team/drizzle-orm/blob/e8e6edfef5ca69c6188d320388ad440265911057/drizzle-kit/src/cli/commands/migrate.ts#L1402

Use the `sqlStatements` as the seed for `prepareMigrationMetadata` to generate random name, so that for the same change, the generated migration name will always be identical. This ensures idempotency when generating migrations across different environments or team members, prevents duplicate migration files for the same database change, and helps maintain a consistent migration history.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.