andioop@programming.dev to Programmer Humor@programming.devEnglish · 3 months agoLittle Timmy Tablesprogramming.devimagemessage-square54fedilinkarrow-up11.2Karrow-down110
arrow-up11.19Karrow-down1imageLittle Timmy Tablesprogramming.devandioop@programming.dev to Programmer Humor@programming.devEnglish · 3 months agomessage-square54fedilink
minus-squareKairuByte@lemmy.dbzer0.comlinkfedilinkarrow-up7·3 months agoWhy are we using magic strings for behavior?
minus-squareuranibaba@lemmy.worldlinkfedilinkarrow-up2·2 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;
minus-squareThe Octonaut@mander.xyzlinkfedilinkarrow-up15·3 months agoIt’s an ENUM and other people have to read this fucking codebase too, Brian!
minus-squareOlap@lemmy.worldlinkfedilinkarrow-up6·3 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-up6·3 months agoI like your DBA! Users probably don’t.
Why are we using magic strings for behavior?
Feel free to fork my comment.
Does Santa accept PRs?
CREATE VIEW NiceList AS SELECT * FROM Children WHERE behavior > 2000 AND parent.income > 40000; CREATE VIEW NaughtyList AS SELECT * FROM Children WHERE behavior <= 2000;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.