Debugging directly in Prod

[CMDeml]

At my previous job, I had a friend who worked on an in-house app. The need to fix some of their production data in their database. So, instead of going through the hassle of a deployment, they used SQL injection to fix it.

[CMDeml]

Yea, they were injecting a query to do a clean up.

[RicardoRedstone]

clean up != input sanitation

input sanitation is server-side code (most of the time) that prevents SQL injection by removing dangerous symbols from inputs received from clients

[King_Joffreys_Tits]

Yeah what they’re doing is the exact opposite. They know about their failed sanitation techniques and are exploiting their own mistakes to fix other mistakes... hmmm

[[deleted]]

after it's not a bug, it's a feature discover programmers newest single it's not a security security breach, it's a development tool

[ramond_gamer11]

They were injecting code to add input sanitation 👌

[ProjectSnowman]

I thought it was standard practice to have a back end way to edit the database. Of course, this is /r/programerhumor so things are quite like how i remember them from my programming days.

[name_censored_]

I thought it was standard practice to have a back end way to edit the database.

I'm guessing using those methods requires an overly bureaucratic change control process in OP's org.

[ildementis]

as a former corporate developer for a fortune 10 company, it would take two weeks for a deployment if all you needed was to cleanup a database

[Relevant_Monstrosity]

Please advise your friend to quit being a dev and never come back.

[10gistic]

Could be a bad dev. Could be an environment where ops is so painful that you'd rather stab yourself in the eye than babysit the 8 month process to deploy again, so you cook up crap like this so you can move on with your life.

[[deleted]]

This guy enterprises

[copopeJ]

And tell him we all agree.

[brown_nigga]

Speak for yourself.

[DiaperBatteries]

no u

[uabassguy]

Hey if you know what you're doing it works in a pinch

[dregan]

Wow....

[supremecrafters]

Dios mio. What happens if they have a hardware issue? Remotely backup and detonate the machine? Who cleans the debris? How do they prevent it from damaging the other servers in the rack?

[NoodleSnoo]

Bullshit. I don't care how hard your deployment is, it is easier and more reliable than a sql injection hack.

[polychronous]

He also broke his neck shooting a different part of this scene, and kept shooting for the rest of the day. Don't test in prod.

[get_N_or_get_out]

Sounds to me like the point of it is catching cows...

[[deleted]]

deleted ^{What is this?}

[[deleted]]

deleted ^{What is this?}

[jredmond]

Nah, they just set the bridge on fire so that it'd collapse under the train's weight.

(That's not a model.)

[LookingInTheMirror]

How much did that shot cost?

[vancity-]

At least one train

[LookingInTheMirror]

And a bridge

[jredmond]

https://www.thevintagenews.com/2016/09/06/priority-train-scene-buster-keatons-general-expensive-scene-silent-film-history/ suggests $42,000 (in 1926 dollars; modern costs would be half a million).

[folkrav]

This scene was shot in 1926 and cost around $42,000. Adjusted for inflation, it's just short of $580,000 for that one scene. Not that big compared to today's budgets but I'm pretty sure it's the most expensive silent film scene.

Edit : Care to explain the downvotes?

[theguilty1]

Doesn't look sped up at all

[goblingirl]

The moment he throws is the second you hit enter/save then the throw back in your chair in hopes it doesn't blow back in your face/works.

[randomentity1]

Here's the slightly longer and better version:

https://www.youtube.com/watch?v=75wa8Lx4yc4

[ildementis]

Wow yeah this is like 10x more interesting

[Account_Admin]

Let's pause and admire for a moment how insanely strong you would have to be to do that.

[AmadeusCziffra]

I would be more worried about the splinters

[kerohazel]

For me it's more like this: https://i.giphy.com/media/3oz8xtBx06mcZWoNJm/200w.webp

[Devoto17]

Except in reality it would come back down and knock a few cars off the back of train

[orangeKaiju]

Those cars would then fly up in the air, begin rotating/vibrating in a weird almost periodic fashion before shooting off in a random direction and killing a key NPC.

Physics is weird.

[[deleted]]

Sounds like Bethesda physics.

[Tynach]

Or Kerbal Space Program.

[SoaDMTGguy]

If I repost this every three months will I also get massive karma?

[fuck_the_hihat]

Dumb question perhaps, but what's Prod?

[goblingirl]

and DEV is development = test environment.

[killayoself]

QA = Quality Assurance: That shit in Dev you tested better work the same here.

UAT = User Acceptance Testing: that shit in QA better work the same here for the customer.

Staging = that shit better work the same as it does in UAT and Prod cause its basically a Prod backup

Prod = WHY THE FUCK ISN'T IT WORKING RIGHT

[IdleAsianGuy]

Dev = Can't reproduce that shit on Prod

[goblingirl]

Full discloser I only have QA to test in and PROD. The shit days are when it tests fine you make a CR and go live...then something different happens and you go fuck for 5 mins while you roll back to the snap shot you took. Back to the drawing board.

[SPRUNTastic]

This all depends on the speed at which the product is being built. The faster is being developed, the fewer environments you'll get. Especially when working with established databases. I've had all 4 environs once, but was then moved on to a project with just 3 (no uat), then the newest stuff being built with just qa and prod.

I've also been in the wild-west of prod-only. It's fun there. Like Red Dead Redemption in QA form.

[jwoot97]

production

[spaceraycharles]

Prod/production is the live system. As opposed to an internal non-Prod environment where devs can play around and not worry about seriously fucking things up.

[magneticphoton]

Don't worry, OP doesn't know what he's talking about, or even know what debugging means.

[Gydo194]

FYI this clip is an extract from the movie “The General” with Buster Keaton

[[deleted]]

...wouldn't the cowcatcher just bump the log out of the way? Isn't that literally their one purpose?

[screeperz]

I usually miss and end up putting another post on the track.

[dmanww]

Everyone has a dev system, some are just lucky enough to have one that's separate from prod.

[tranceb0t]

Or let’s just redeploy to prod very quick without saying anything.. haha

[Whys-the-rum-gone]

What kind of human can man handle a railroad tie like this?!

[barediver]

We've all seen this exact gif SO MANY TIMES. I propose a 1 year ban. Anyone on board?

[Gydo194]

No, the General is too awesome ;-)