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 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.
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.