News for hackers. Stuff that matters.
Re:The Time I Lied to the CTO and Saved the Day by summerlight on Thursday May 09, 2024 @12:07AM (#40305220)
> Each ticket was a column. So if your most active user had 5 tickets in total history, you needed 5 columns.

I was thinking like, "Oh yeah, they have 5 tickets, so need 5 rows. What's wrong?". And I read it again and found it's the word "column". It must be a big fun to write a query for such tables.

Re:The Time I Lied to the CTO and Saved the Day by kubanczyk on Thursday May 09, 2024 @01:28AM (#40305535)
I bet it was SELECT * FROM customers; followed by a for loop. Easy-peasy.
Re:The Time I Lied to the CTO and Saved the Day by j16sdiz on Thursday May 09, 2024 @03:15AM (#40306007)
It would be _slightly_ better if the DBMS have array types. Often they are not scalable, but it is better than thousands lines of copy-and-pasted code.