Schema checkpointing

[bitdivine]

Hello,

I am curious whether there is any demand for schema checkpoints? I've been working alongside a team that uses knexmigrate a lot (good stuff) but sometimes a database ends up in an incorrect state; there are humans involved, what can you do? It struck me that it would help if once every so often they were to make a dump of the schema and insert that in the knexmigrate timeline. The migration should essentially be an assert: At this point the database should look like this. If not, stop and scream so that someone can have a look at the database, and the migrations as the bug might be there, and provide a fix.

Yes? No? Maybe? Straw poll?

Regards, Bit