Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
what would happen if they found out? besides getting fired would you be charged a lot of money to pay for the damage? any lawsuits etc? since you didn't do it on purpose, what happens if its an accident?
-
@SukMikeHok, firing was on my mind, since the pay is quite good. I doubt there would be a lawsuit, but since a lot of people know each other, that would mess up my reputation. Most likely I would have to switch cities or change my line of work.
-
piehole8106yWhy hide it? Say this happened, say you resolved it. Done. You've stress tested their backup system. You can now design an automated backup restore function, or file a ticket for the IT guys ('don't know where's the backup' is a serious issue). Never understood this need to be so secretive. It's human to fuck up, hence the need for backups.
Edit: If this got you fired, you switched to the wrong place I'm afraid, and I'd immediately start looking for something else if I were you. -
@piehole. I know it's human to mess up. But starting this early and messing up during trial period, where it's noobish to do so, makes me worry about losing the position. I already started implementing the automatic restore, midway there. Since the company is quite small, we outsource the IT. It seems we used a lot of different companies to maintain the infrastructure. This is just a mess...
-
3 lines to save your ass:
begin transaction
[YOUR QUERY]
--commit transaction
rollback transaction
when you are happy with the reported results (as in they fall within the expected range of number of row changes) then uncomment the 3rd line and comment the last one and run again. -
That nail biting situation. I once ran rm -rf on production and when I realised what I have done, I switched off my system thinking it won’t affect anything
-
Fradow9086yFriendly tip I mentioned in another rant a few days ago: always write the "where" clause before the table name.
Also, who the hell gives a fresh junior dev a production DB access? -
@Fradow I might not have been clear with it, but I'm the only Developer here. So working in production environment is a thing here. I have my development environment, but before that everything was production first here. No idea how the last developer decided it's the correct approach.
-
@gruff can you give me a link, so I could read about it? Never heard of as of operator before.
Related Rants
Never in my life I was scared as today.
I recently left a big company to work for a small one as the first internal developer.
Had a small issue in the production server. The fix was easy, just remove a single table entry. And... *drum roll*... I forgot to add a where clause. All orders were lost.
No idea if we had backups or anything, I quickly called the one other IT dude in the company.
He had no clue where are the backups and how to find them.
Having some experience with Nmap, I quickly scanned our network and found a Nas device.
There was a backup, whole VHD backup. 300GB of it, the download speed is around 512kb/s. No way I can fix it before management finds out, but then an idea came to mind. Old glorious 7zip. Managed to extract only the database files, sent them to the server and quickly swapped them. Everything was fine... The manager connected 5 minutes later. Scariest 45 minutes of my life...
rant
thank you 7zip
messed up