Top advice you'd give to a new dev? - devRant

Ranter

Comments

1

Jumpshot44

11019

8y

Bravo!
4

kamen

6917

8y

I know almost nothing about DBs, but I smell that this can have unforeseen consequences.
30

davejlong

419

8y

Better yet: Always write DELETE and UPDATE statements as SELECT statements first.
11

rantymcrantface

459

8y

Duh. Just add WHERE 1, especially on prod.
2

ptrotter

396

8y

Getting in the habit of using BEGIN TRAN is a good idea too.
2

zzguy

602

8y

And start everything with begin; so you can always rollback; when you deleted a million rows instead of 2.
2

tomabolt

1776

8y

@zzguy I'm confident, I always check the auto commit option.
0

gggggggggg

1222

8y

@Nifled Are you talking from experience?
0

ScribeOfGoD

7271

8y

Gotta love backups
1

DanijelH

1743

8y

I always wrap statements in begin and roll back transaction block while I'm on production. Just in case xD
1

Nifled

2912

8y

@gggggggggg Yes, but luckily I always keep a backup. 😊
2

Mentalbrake

67

8y

Yes just use DROP
1

damjangkae

27

8y

Also do LIMIT just in case.
1

thecritic

2074

8y

I tried it on the toilet, in the garden and even in the park! No matter WHERE I try it, the result is still the same.
0

vectormike

4

8y

@damjangkae always limit!!!! :)
0

Shago

302

8y

But there was an error on the WEHRE so I removed it. Works every time. ✌
1

vectormike

4

8y

@Shago maybe because you typed wehre :)
2

Shago

302

8y

@vectormike your liyng my SLQ are foolproff!!!
2

uxmedic

215

8y

Here, have the 300th ++. :)

Related Rants

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service