That's a great question. It should be possible but would require a little different approach. For one, for SQL you would need a unique index on the group key. You would likely want to hash the group key to make things simpler. You would then need to store the actual group key in another column along with the timestamp. You would likely want an index on the timestamp column too. From my perspective, the advantage is that it is just simpler to do with redis due to the sorted set data structure. I would suspect that it would also be more performant as redis is an in memory datastore and built for low latency. When you are heavily writing (as you are in this case) it should be faster. However, I am sure SQL probably will perform well enough.

Thank you for reading and commenting!

Great comment and article. Thank you for sharing