Databases
StackOverflow2013
Postsdbo
POWhich clustered NoSQL DB for a Message Storing purpose?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhich clustered NoSQL DB for a Message Storing purpose?
    primarykey
    data
    text
    <p>Yet another question about which NoSQL to choose. However, I haven't found yet someone asking for this type of purpose, message storing...</p> <p>I have an Erlang Chat Server made, I'm already using MySQL for storing friend list, and "JOIN needed" informations.</p> <p>I would like to store Messages (That user has not receive because he was offline...) and retrieve them.</p> <p>I have made a pre-selection of NoSQL, I can't use things like MongoDB due to it's RAM oriented paradigm, and fail to cluster like others. I have down my list to 3 choices I guess :</p> <ul> <li>Hbase</li> <li>Riak</li> <li>Cassandra</li> </ul> <p>I know that their model are quit different, one using key/value, the other using SuperColumns and co.</p> <p>Until now I had a preference for Riak due to it's stable client library for Erlang.</p> <p>I know that I can use Cassandra with Thrift, but it seems not very stable with Erlang (I haven't got good returns about it)</p> <p>I don't really know anything about HBase right now, just know it exist and is based on Dynamo like Cassandra and Riak.</p> <p>So Here's what I need to do :</p> <ul> <li>Store from 1 to X messages per registered user.</li> <li>Get the number of stored messages per user.</li> <li>retrieve all messages from an user at once.</li> <li>delete all messages from an user at once.</li> <li>delete all messages that are older than X months</li> </ul> <p>Right now, I'm really new to those NoSQL DB, I always been a MySQL aficionados, This is why I ask you this question, as a Newbie, would someone who has more experience than I could Help me to choose which one is better, and would let me do everything I want to without to much hassle...</p> <p>Thanks !</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USTheSquad
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhich clustered NoSQL DB for a Message Storing purpose?
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POWhich clustered NoSQL DB for a Message Storing purpose?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhich clustered NoSQL DB for a Message Storing purpose?
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO@BrianRoach: They do not seems to think so on this question http://stackoverflow.com/questions/2892729/mongodb-vs-cassandra this is the same kind of question.
      singulars
      1. POWhich clustered NoSQL DB for a Message Storing purpose?
      1. USTheSquad
    2. COthe fact that one question wasn't downvoted and closed as it should have been doesn't affect the fact that ... it's not appropriate as per the FAQ and meta. In addition, that was 2 years ago - things have evolved since then with the addition of the other sites.
      singulars
      1. POWhich clustered NoSQL DB for a Message Storing purpose?
      1. USBrian Roach
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload