andioop@programming.dev to Programmer Humor@programming.devEnglish · 5 months agoLittle Timmy Tablesprogramming.devimagemessage-square22linkfedilinkarrow-up121arrow-down10
arrow-up121arrow-down1imageLittle Timmy Tablesprogramming.devandioop@programming.dev to Programmer Humor@programming.devEnglish · 5 months agomessage-square22linkfedilink
minus-squareKairuByte@lemmy.dbzer0.comlinkfedilinkarrow-up0·5 months agoWhy are we using magic strings for behavior?
minus-squareThe Octonaut@mander.xyzlinkfedilinkarrow-up1·5 months agoIt’s an ENUM and other people have to read this fucking codebase too, Brian!
minus-squareOlap@lemmy.worldlinkfedilinkarrow-up1·5 months agoI’ve a DBA who would insist on this being in a dimension table and using a foreign key constraint instead of just a fucking string
minus-squareluciferofastora@feddit.orglinkfedilinkarrow-up1·5 months agoI like your DBA! Users probably don’t.
minus-squareuranibaba@lemmy.worldlinkfedilinkarrow-up2·5 months agoCREATE VIEW NiceList AS SELECT * FROM Children WHERE behavior > 2000 AND parent.income > 40000; CREATE VIEW NaughtyList AS SELECT * FROM Children WHERE behavior <= 2000;
Why are we using magic strings for behavior?
It’s an ENUM and other people have to read this fucking codebase too, Brian!
I’ve a DBA who would insist on this being in a dimension table and using a foreign key constraint instead of just a fucking string
I like your DBA!
Users probably don’t.
Feel free to fork my comment.
CREATE VIEW NiceList AS SELECT * FROM Children WHERE behavior > 2000 AND parent.income > 40000; CREATE VIEW NaughtyList AS SELECT * FROM Children WHERE behavior <= 2000;Does Santa accept PRs?