[katello-devel] The importance of foreign keys

[Ivan Necas]

Hey,

I know this topic appeared here several times but still it doesn't seem
to be considered important. Here is an issue that I've hit today [1]: see
it's description for more details.

This kind of issues is really dangerous because there is generally a time
span between the error that uses sees and the moment when the cause happens.
(in this case promoting a changeset vs. deleting an environment). We already
hit this kind of issues in the past and it's not fun debugging it, especially
on the customer side.

Therefore, I would like to open this topic again and ask for reconsideration
of the priority and ideally make introducing of foreign keys for associations
in our db one of the high-priority tasks for next sprint.

[1] - https://github.com/Katello/katello/pull/1743

-- Ivan