SQLite doesn't enforce foreign keys by default, and it cost us three bugs

Our test suite runs on SQLite. Production runs on PostgreSQL. That is a common setup and for a long...