4 ms·
Even today I'm not sure I'd recommend Cassandra for his use case. A stated requirement he needed was: >Support asking for N number of Pins in a board in a dete
by nemothekid 11y ago
Even today I'm not sure I'd recommend Cassandra for his use case. A stated requirement he needed was:
>Support asking for N number of Pins in a board in a deterministic order (such as reverse creation time or user specified ordering). Same for Pinner to likes, Pinner to Pins, etc.
This can be a pain to model in Cassandra. It would require denormalizing for every key you wanted to order on, and it generally makes updating data a pain.
- jlongtine 11y agoI don't think that the schema here allows you to do this kind of query even in MySQL. They are throwing everything in that blob, which makes it pretty difficult to sort on anything that's in the blob. So, I think they would have to do what you are describing, denormalize everything... or get all the data and do the sort in the app. Which is precisely what would be required with Cassandra or another NoSQL system. Am I missing anything that would invalidate what I've just said?
- brianwawok 11y agoIf you only need 1 ordering, not too hard in cassandra. If you need a few different orderings, you would need a side table - which seems to be what you need here with mysql.