CREATE VIEW NiceList AS
 SELECT * FROM Children
  WHERE behavior > 2000
   AND parent.income > 40000; 
CREATE VIEW NaughtyList AS
 SELECT * FROM Children
  WHERE behavior <= 2000;

[–] Tja@programming.dev 11 points 2 weeks ago

Does Santa accept PRs?

[–] TheOctonaut@mander.xyz 15 points 2 weeks ago (1 children)

It's an ENUM and other people have to read this fucking codebase too, Brian!

[–] Olap@lemmy.world 5 points 2 weeks ago (1 children)

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

[–] luciferofastora@feddit.org 5 points 2 weeks ago

I like your DBA!

Users probably don't.

[–] djmikeale@feddit.dk 10 points 2 weeks ago

He used to have an is_nice bool but consultants convinced Santa it isn't future proof enough to capture the nuances of kids behaviour in today's world, such as "nice but always is really smug about it". But the consultants kept making PowerPoints instead of updating the backend, so now Santa also has added a new value to behaviour: "consultant-like"