How to get/Maintain history

[pa...@excellenceinfonet.com]

I am working on chat application

I have been working on getting started tutorials of RabbitMQ and till now I am able to send the message.
Now once I receive the message,the message is removed from the queue, now I want to keep history of the messages, so when user again logs in, I want to show him his already received messages, so how can I handle this?

a) Should this be done using RabbitMQ server ?
b) Or Should I create another sql server to push data there ?
c) or If I use Rabbit MQ with Google cloud engine it will help me doing this ?

[Michael Klishin]

On 7 November 2014 at 12:27:51, pa...@excellenceinfonet.com (pa...@excellenceinfonet.com) wrote:
> I have been working on getting started tutorials of RabbitMQ
> and till now I am able to send the message.
> Now once I receive the message,the message is removed from the
> queue, now I want to keep history of the messages, so when user
> again logs in, I want to show him his already received messages,
> so how can I handle this?
>
> a) Should this be done using RabbitMQ server ?
> b) Or Should I create another sql server to push data there ?

RabbitMQ is not a data store in the traditional sense. I'd definitely store chat history
in a data store designed for long term storage, be it SQL Server, ElasticSearch or Cassandra.

In addition, data stores such as SQL Server and ElasticSearch provide you rich querying
capabilities, which RabbitMQ does not provide (it only has FIFO queues).

> c) or If I use Rabbit MQ with Google cloud engine it will help me
> doing this ?

RabbitMQ on GCE is just a pre-provisioned RabbitMQ cluster. It does not change
what RabbitMQ is good (and not good) at, and how it is intended to be used
(as a message distribution mechanism and a short term storage).

So use RabbitMQ for message/notification distribution and another data store
for chat history and search (ElasticSearch is a good option to investigate for both
of these if you ask me). 
--
MK

Staff Software Engineer, Pivotal/RabbitMQ

[Parag Bhayani]

Thanks a lot for information :)

Thanks :)

Regards,
Parag

[Parag Bhayani]

Would you please guide me on this?

Regarding RabbitMQ on GCE with History and search feature, what should be the ideal case you would recommend to use

A) Use RabbitMQ GCE and use cloud Datastore

B) Use RabbitMQ GCE and use MongoDB with infrastructure provided by google cloud platform

C) Use RabbitMQ GCE and use Apache Cassandra with infrastructure provided by google cloud platform
D) Use RabbitMQ GCE and use cloud sql
E) Use RabbitMQ GCE and use SQL server on my personal server
F) Use RabbitMQ GCE and use elastic search/cassandra server on my personal server

G) Rather using GCE have both(RabbitMQ and SQL) Server on my personal server

Amongst above which would be descent choice and which will be disastrous for me?

Thanks a ton :)

Regards,
Parag

On Fri, Nov 7, 2014 at 3:05 PM, Michael Klishin <mkli...@pivotal.io> wrote:

[Michael Klishin]

On 7 November 2014 at 14:41:28, Parag Bhayani (pa...@excellenceinfonet.com) wrote:
> Regarding RabbitMQ on GCE with History and search feature,
> what should be the ideal case you would recommend to use
> A) Use RabbitMQ GCE and use cloud Datastore
> B) Use RabbitMQ GCE and use MongoDB with infrastructure provided
> by google cloud platform
> C) Use RabbitMQ GCE and use Apache Cassandra with infrastructure
> provided by google cloud platform
> D) Use RabbitMQ GCE and use cloud sql
> E) Use RabbitMQ GCE and use SQL server on my personal server
> F) Use RabbitMQ GCE and use elastic search/cassandra server
> on my personal server
> G) Rather using GCE have both(RabbitMQ and SQL) Server on my personal
> server
>
> Amongst above which would be descent choice and which will be
> disastrous for me?

Just about any data store will work fine for storing chat history. Use what you are more
familiar with.

Sorry, I would refrain from making definitive recommendations because I have no
information about your project. It is also not very wise to outsource such decisions to
a public mailing list.

[Parag Bhayani]

Yah, it's okey I just wanted to make sure that I don't choose any disastrous way of doing this...

Thanks :)

Regards,
Parag