Re: [GENERAL] Log Data Analytics : Confused about the choice of Database

2014-05-13 Thread Peeyush Agarwal
queries so I would like to partially index over it. Peeyush Agarwal On Tue, May 13, 2014 at 3:13 PM, Dorian Hoxha wrote: > Why not store session as integer? > > And timestamp as timesamp(z?) ? > > If you know the types of events, also store them as integer , and save a > map of

[GENERAL] Log Data Analytics : Confused about the choice of Database

2014-05-13 Thread Peeyush Agarwal
r that, I can use SQL queries to compute the synthetic (or additional) data, store it temporarily in variables in a Rails Application (which will interact with PostgreSQL database and act as interface for the person who wants the JSON blob) and create JSON blob from it. However I am not sure if PostgreSQL is the best choice for this use case. I have put the detailed question on SO at http://stackoverflow.com/questions/23544604/log-data-analytics Looking for some help from the community. Peeyush Agarwal

[GENERAL] Log Data Analytics : Confused about the choice of Database

2014-05-12 Thread Peeyush Agarwal
r that, I can use SQL queries to compute the synthetic (or additional) data, store it temporarily in variables in a Rails Application (which will interact with PostgreSQL database and act as interface for the person who wants the JSON blob) and create JSON blob from it. However I am not sure if PostgreSQL is the best choice for this use case. I have put the detailed question on SO at http://stackoverflow.com/questions/23544604/log-data-analytics Looking for some help from the community. Peeyush Agarwal