Timeline for How do I prove that the act of removing foreign keys doesn't corrupt existing data?
Current License: CC BY-SA 3.0
22 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 13, 2019 at 10:04 | comment | added | Walter Mitty | I can't help you with MySQL, but in every case where I've seen foreign keys left out on other DBMS products, the overhead saved was minimal compared to the risk of data corruption. And I've run into dozens of database developers who are just plain wrong on this subject, their credentials notwithstanding. | |
| May 13, 2019 at 10:02 | comment | added | Walter Mitty | A little conceptual clarity would help here. Removing the foreign key constraints didn't cause any data corruption. It did fail to prevent data corruption. And if the application programs weren't careful, the programs may have caused data corruption. The same comment goes for interactive SQL users, which typically means the DBA. | |
| Apr 4, 2016 at 11:32 | history | tweeted | twitter.com/StackDBAs/status/716951668206747648 | ||
| Feb 5, 2016 at 6:37 | answer | added | jmoreno | timeline score: 1 | |
| Aug 21, 2014 at 11:01 | vote | accept | Agi Hammerthief | ||
| Aug 21, 2014 at 11:00 | vote | accept | Agi Hammerthief | ||
| Aug 21, 2014 at 11:01 | |||||
| Aug 21, 2014 at 10:29 | history | edited | Agi Hammerthief | CC BY-SA 3.0 |
Add a synopsis of the problem at hand; clarify question
|
| Aug 21, 2014 at 9:49 | answer | added | David Spillett | timeline score: 10 | |
| Aug 20, 2014 at 21:19 | history | edited | RolandoMySQLDBA |
edited tags
|
|
| Aug 20, 2014 at 21:16 | answer | added | RolandoMySQLDBA | timeline score: 2 | |
| Aug 20, 2014 at 16:38 | answer | added | JoseTeixeira | timeline score: 1 | |
| Aug 20, 2014 at 16:11 | answer | added | Vérace | timeline score: 10 | |
| Aug 20, 2014 at 15:52 | history | edited | Agi Hammerthief | CC BY-SA 3.0 |
added 19 characters in body
|
| Aug 20, 2014 at 15:48 | comment | added | Agi Hammerthief | @a_horse_with_no_name MySQL is the only one I have any development experience with, which is why this is about MySQL. I'm still learning SQLite and in some aspects it's deficient for use with a web application without jumping through hoops (such as encrypting the whole DB file because it doesn't have inbuilt user access security). | |
| Aug 20, 2014 at 15:44 | history | edited | Agi Hammerthief | CC BY-SA 3.0 |
Clarification of what I want to achieve
|
| Aug 20, 2014 at 15:43 | comment | added | user1822 | Interesting enough I never see this discussion when people are using Postgres, Oracle, DB2 or SQL Server. It's alyways MySQL where this discussion comes up. | |
| Aug 20, 2014 at 15:41 | comment | added | Agi Hammerthief | @a_horse_with_no_name Either he didn't explain his point properly, I misunderstood it or it's a flawed argument, but that's the impression I got as well. jynus I also refuse to believe that he told me they are bad (more that they are inconvenient), considering he's got more experience as a developer than I do. | |
| Aug 20, 2014 at 15:37 | review | Close votes | |||
| Aug 26, 2014 at 3:01 | |||||
| Aug 20, 2014 at 15:34 | comment | added | jynus | Actually, the people that I have seen not using them for a custom developed application were either poor developers or had to implement them at application side because MySQL implementation was limited (too little constraints or extra locking). | |
| Aug 20, 2014 at 15:30 | comment | added | jynus | While the title question is legitimate, I think the idea behind it (proving you are right) and the way it is presented is a bit unoptimal. Nobody on this site will tell you that referential integrity is wrong and that you shouldn't use foreign keys. Also, it is not difficult to handle them, referential integrity can be disabled at any time in order to perform DMLs. I refuse to believe that your boss told you that they are plainly bad unless he has never used a database. | |
| Aug 20, 2014 at 15:28 | comment | added | user1822 | "He's removed them from existing tables to change things and it's caused data corruption [...] so he'd rather not use them." - I don't get it. The FKs were removed, the inevitable data corruption showed up and that's why he doesn't want to use them? | |
| Aug 20, 2014 at 15:15 | history | asked | Agi Hammerthief | CC BY-SA 3.0 |