incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Drew Kutcharian <d...@venarc.com>
Subject Data Modeling: Comments with Voting
Date Wed, 26 Sep 2012 23:28:27 GMT
Hi Guys,

Wondering what would be the best way to model a flat (no sub comments, i.e. twitter) comments
list with support for voting (where I can sort by create time or votes) in Cassandra?

To demonstrate:

Sorted by create time:
- comment 1 (5 votes)
- comment 2 (1 votes)
- comment 3 (no votes)
- comment 4 (10 votes)

Sorted by votes:
- comment 4 (10 votes)
- comment 1 (5 votes)
- comment 2 (1 votes)
- comment 3 (no votes)

It's the sorted-by-votes that I'm having a bit of a trouble with. I'm looking for a roll-your-own
approach and prefer not to use secondary indexes and CQL sorting.

Thanks,

Drew


Mime
View raw message