Ideas

[ankane]

Please create a new issue to discuss any ideas or share your own.

Ideas

• Add check for creating a foreign key without an index
• Show friendly message for lock timeout - lock_timeout_message branch
• Change default lock timeout to 5 seconds in generator
• Improve pattern for lock timeout retries - statement_retries branch (would also be good to record/replay statements for transactions instead of re-running code)
• Condense add_check_constraint, add_foreign_key, and change_column_null suggestions into a single migration (downside: failed migration can result in db state that needs manually reconciled) - safe to do since can detect locks

See #95 for ideas that were decided against.