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

Ranter

Comments

1

Jumpshot44

11047

7y

Bravo!
4

kamen

7009

7y

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

davejlong

437

7y

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

rantymcrantface

461

7y

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

ptrotter

399

7y

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

zzguy

604

7y

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

tomabolt

1782

7y

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

gggggggggg

1225

7y

@Nifled Are you talking from experience?
0

ScribeOfGoD

7470

7y

Gotta love backups
1

DanijelH

1772

7y

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

Nifled

2924

7y

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

Mentalbrake

67

7y

Yes just use DROP
1

damjangkae

27

7y

Also do LIMIT just in case.
1

thecritic

2086

7y

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

7y

@damjangkae always limit!!!! :)
0

Shago

303

7y

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

vectormike

4

7y

@Shago maybe because you typed wehre :)
2

Shago

303

7y

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

uxmedic

215

7y

Here, have the 300th ++. :)

Related Rants

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