News for hackers. Stuff that matters.
Re:Databases in 2024: A Year in Review by somat on Wednesday January 01, 2025 @09:46PM (#42571143)
Now I have never used redis in this capacity but these sorted sets(a data structure that maintains it's sort as data is entered I assume) how is that different from "create index on player_score (score)"? that is, an index on the score column. which will create a data structure that maintains it's sorted nature as data is entered.

My naive view is that you create a sorted set every time you define an index. that is, the opposite of "super hard to model with SQL"

Re:Databases in 2024: A Year in Review by mistrial9 on Wednesday January 01, 2025 @11:53PM (#42571736)
maybe it was a reference to two or three or N level deep nested tree structures. Those dont map as naturally using simple SQL relations.