These Two Will Be Married In 100 Days - Ch. 75 - Day 75
- Thread starter MangaDex
- Start date
- Joined
- Apr 21, 2018
- Messages
- 176
Yay for spaghetti code, this shit is getting too relatable now.
- Joined
- Jun 10, 2019
- Messages
- 1,100
@Midoriha
it's more likely that he may have run that line.
if he ran it, and it was on a live server, he just deleted an entire database of customer information.
even with backups, there's information lost.
alternatively, if that line was part of regular code and he removed it, it may have caused an information overflow.
think of it like a glass of water.
information is poured in, and every now and then some is poured out (deleting an old copy of the database to make room for the new copy)
if info keeps coming in and none is deleted, the glass overflows, and systems crash.
it's more likely that he may have run that line.
if he ran it, and it was on a live server, he just deleted an entire database of customer information.
even with backups, there's information lost.
alternatively, if that line was part of regular code and he removed it, it may have caused an information overflow.
think of it like a glass of water.
information is poured in, and every now and then some is poured out (deleting an old copy of the database to make room for the new copy)
if info keeps coming in and none is deleted, the glass overflows, and systems crash.
- Joined
- Mar 4, 2018
- Messages
- 31
@Midoriha
Because that's how a table work in a database. When you delete from it (and commit the deletion) then the data simply ceases to exist. And you cannot rewrite, say, 10k customers with potentially personal data such as address, phone number, mail address, card information, ... (well, depending on the model, it's not necessarily in the same table, but that's another story ^^; ). Besides, said data is linked to other table in the model, which were not wiped. Is "new customer id 1" linked to "old customer id 1" ? Did we type customers in the same order ? The situation depicted in the manga is a nightmare to live.
That's why any company has (or should have at least ^^; ) backups. These backups are usually a copy of the base at a given date, so some data loss is still in effect (mainly any modification you did between the backup and the deletion).
When the guy says he'll "do something about it", he most likely is going to get the backup and restore the base.
Because that's how a table work in a database. When you delete from it (and commit the deletion) then the data simply ceases to exist. And you cannot rewrite, say, 10k customers with potentially personal data such as address, phone number, mail address, card information, ... (well, depending on the model, it's not necessarily in the same table, but that's another story ^^; ). Besides, said data is linked to other table in the model, which were not wiped. Is "new customer id 1" linked to "old customer id 1" ? Did we type customers in the same order ? The situation depicted in the manga is a nightmare to live.
That's why any company has (or should have at least ^^; ) backups. These backups are usually a copy of the base at a given date, so some data loss is still in effect (mainly any modification you did between the backup and the deletion).
When the guy says he'll "do something about it", he most likely is going to get the backup and restore the base.
- Joined
- Oct 21, 2019
- Messages
- 1
@Midoriha Last chapter, he ran a command to delete data from the "tbl_Customer" database. Usually, you'd write
to specify which data to delete, but he just ran
, which erases the entire database. If they don't have a backup somewhere, this company is in big trouble.
Code:
DELETE FROM table WHERE <some condition>
Code:
DELETE FROM tbl_Customer- Joined
- Apr 22, 2019
- Messages
- 25
- Joined
- Jul 20, 2019
- Messages
- 803
Newly wed engineer it's NASA lolll, is he gonna do some forensic computer science thing that I'm not aware about? I personally don't know any way to restore the data from the table
- Joined
- Sep 8, 2019
- Messages
- 136
Nasa comes to save the day!
- Joined
- Jul 15, 2018
- Messages
- 34
Okay, but like... there's no backups?
