search for: rdmses

...for loading test data or for upgrading DBs schemas, or for porting DBs and other special data mangling outside the well-bevahed application CRUD functionality. So, I was thinking, why is FK contraints good? For one thing, they improve performance by indexing the FK fields (at least in the good RDMSes), but that can be done independently. And then, the most obvious reason and most beneficial, they enforce data integrity, ie, data don''t get lost because you didn''t set the FK the right value. But, as I said before this doesn''t come for free. So, if we use a good rela...