Skip to content


migrate' does not compare table structure #63

sguy opened this Issue · 1 comment

4 participants


I've run into an issue when trying to map an existing data store (sqlite3) to persistent entities. migrate' tells me that the existing structure does not match the structure implied by the persistent entity. It wants to drop my tables and recreate them. It looks like what is happening (at least in the sqlite3 implementation) is that is just dumps the create statement from the existing schema and compares that with the create statement generated from the entity definition. I think it would be more correct to parse the existing schema and compare that to the proposed schema to see if they are compatible.

Yesod Web Framework member

AFAIK persistent-sqlite does that because it's not meant to be used in production code anyways. This doesn't mean that this issue won't be fixed, however it's a low priority bug IMHO. Having written persistent-mysql's migration code I know that it's a terribly delicate and complicated beast. Pull requests are more than welcome =).

@gregwebs gregwebs added the Sqlite label
@snoyberg snoyberg closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.