What is the chat logging database?

Question

I am using a chat system.

What database should I use to register chat messages?

I need to make some requests to it. For example, "give me all the links from user x between these dates"

I have heard some good things about MongoDB for this kind of thing. What about other NoSQL solutions? Redis? Cassandra?

What about old SQL solutions? Although I’m very interested in having experience with NoSQL databases, I’m not going to do this just for the sake of it :)

I need to be able to handle hundreds of active users.

Answer 1

Ok. , NoSQL . NoSQL, .

mongodb. ? mongodb , SQL, . Mongodb .

, facebook twitter, cassandra .

Answer 2

SQLite , .

Answer 3

, Google Twitter;) mysql, sqlite . , , nosql, .

Answer 4

, CouchDB. NoSQL .

Answer 5

. , MySQL, . - MYSQL, IMO.

Answer 6

redis (+ node). .

Answer 7

:

, SQLite, -, , .

http://www.sqlite.org/

If the data is large, consider NOSQL databases , for example

MongoDB http://www.mongodb.org/

or

HBase https://hbase.apache.org/

If you are familiar with windows and consider MYSQL or MSSQL