30 ms·
So basically what this does is avoid locking the database while migrating? Obviously (and the README mentions this) the two releases have to be backwards- and f
by StavrosK 8y ago
So basically what this does is avoid locking the database while migrating? Obviously (and the README mentions this) the two releases have to be backwards- and forwards-compatible, so with this backend you avoid locking for other processes while migrating.
Very useful, especially for long migrations, but I would like to see a bit more detail about how this library achieves this, what the caveats are, etc.
EDIT: Never mind, there's a comprehensive "how it works" section farther down, I just needed to scroll far enough. This is very useful.
- tbicr 8y agoI found only two caveats: - it doesn't use transactions, so if migration will down, then you will need to fix state manually (one point of improvement), however you cannot run `CREATE INDEX CONCURRENTLY` in transaction. - it can use `CHECK (column IS NOT NULL)` constraint for safe `NOT NULL` replacement for huge tables, that isn't compatible with standard django behavior. So all this cases highlighted in README.