Database/schema compare

[8zero7]

During the churn of early development, database schemas being altered by multiple developers in rapid succession can easily cause conflicts. Additionally, when experimenting with db design or prototyping, it is customary to have multiple branches containing slightly different db schemas. A nice feature of Prisma is the ability to compare different schemas or live databases and output the differences between them: https://www.prisma.io/docs/orm/reference/prisma-cli-reference#migrate-diff

I use this frequently and adding this to drizzle would be fantastic.

[Greenheart]

I want this too, and found a workaround for the time being :)

It uses drizzle-kit push to automatically try to migrate the dev database, and prevents the app startup with an error if there are changes that cause any data loss.

I've only tested with SQLite so far, but it should work for other databases supporting drizzle-kit push too. Let me know if it does :)

https://samuelplumppu.se/blog/live-reloading-db-schema-with-drizzle-sqlite