drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: integrate with pgroll for migrations

Open
#1,563 2 comments 7 reactions 0 assignees View on GitHub
db/postgres drizzle/kit enhancement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Describe what you want

[`pgroll`](https://github.com/xataio/pgroll) is a tool that:
> * Zero-downtime migrations (no database locking, no breaking changes).
> * Keep old and new schema versions working simultaneously.
> * Automatic columns backfilling when needed.
> * Instant rollback in case of issues during migration.
> * Works against existing schemas, no need to start from scratch.

I think their JSON "Operations" is a bespoke set and I couldn't find any easy/obvious way to create it: https://github.com/xataio/pgroll/blob/main/docs/README.md#operations-reference

Seems like a match made in heaven if drizzle could generate the change spec similar to the existing migrations feature.

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.