Best database for a chat application? : Database
SQL versus NoSQL: Pros and Cons
Structure a NoSQL database for a chat application (using FireBase)
Chat schema for PostgreSQL and MongoDB
Cassandra is "eventually consistent" however I think this phrase is often misinterpreted.
With these values you have strong consistancy.