Re: [GENERAL] time series data

2017-10-16 Thread Khalil Khamlichi
Thanks a lot Jeremy, we ended up integrating the code you provided into our software (just before you patent it) :) Best regards, Kkh On Tue, Oct 3, 2017 at 7:58 PM, Schneider wrote: > On Mon, Oct 2, 2017 at 10:27 AM, Khalil Khamlichi >

Re: [GENERAL] time series data

2017-10-14 Thread Khalil Khamlichi
Thanks, I'll check it out. Sent via mobile, please forgive typos and brevity On Oct 14, 2017 3:23 PM, "Joshua D. Drake" wrote: > On 10/01/2017 01:17 AM, Khalil Khamlichi wrote: > >> Hi everyone, >> > > Take a look at TimescaleDB they have an extension to Postgres that

Re: [GENERAL] time series data

2017-10-14 Thread Joshua D. Drake
On 10/01/2017 01:17 AM, Khalil Khamlichi wrote: Hi everyone, Take a look at TimescaleDB they have an extension to Postgres that makes this awesome (and yes its free and open source). jD I have a data stream of a call center application coming in  to postgres in this format :

Re: [GENERAL] time series data

2017-10-03 Thread Schneider
On Mon, Oct 2, 2017 at 10:27 AM, Khalil Khamlichi wrote: > we have records like this > > ccdb1=# select user_name, agent_status, event_time from cc_events ; > > user_name | agent_status | event_time > ---+--+- > user1 |

Re: [GENERAL] time series data

2017-10-02 Thread Nico Williams
You have these choices: - turn events into INSERTs and UPDATES on a table that represents a single call You might have an events VIEW with INSTED OF insert/update triggers so you can insert events as the interface for updating calls. - store the events and have a VIEW on the events

Re: [GENERAL] time series data

2017-10-02 Thread Khalil Khamlichi
Hi Melvin, Thanks a lot for your help, let me explain to you my problem. we have records like this ccdb1=# select user_name, agent_status, event_time from cc_events ; user_name | agent_status | event_time ---+--+- user1 | ready|

Re: [GENERAL] time series data

2017-10-02 Thread Khalil Khamlichi
interesting proposition, I am reading the docs. On Mon, Oct 2, 2017 at 6:08 PM, Scott Marlowe wrote: > On Sun, Oct 1, 2017 at 2:17 AM, Khalil Khamlichi > wrote: > > Hi everyone, > > > > I have a data stream of a call center application

Re: [GENERAL] time series data

2017-10-02 Thread Scott Marlowe
On Sun, Oct 1, 2017 at 2:17 AM, Khalil Khamlichi wrote: > Hi everyone, > > I have a data stream of a call center application coming in to postgres in > this format : > > user_name, user_status, event_time > > 'user1', 'ready', '2017-01-01 10:00:00' > 'user1',

Re: [GENERAL] time series data

2017-10-02 Thread Melvin Davidson
On Sun, Oct 1, 2017 at 6:20 PM, Clifford Snow wrote: > I have a stream that updates every minute with a trigger that updates > another table with information from the stream. That way I'm constantly > updated with no need to run a script to update before I want a report.

Re: [GENERAL] time series data

2017-10-01 Thread Clifford Snow
I have a stream that updates every minute with a trigger that updates another table with information from the stream. That way I'm constantly updated with no need to run a script to update before I want a report. Clifford On Sun, Oct 1, 2017 at 10:08 AM, Melvin Davidson

Re: [GENERAL] time series data

2017-10-01 Thread Melvin Davidson
On Sun, Oct 1, 2017 at 4:17 AM, Khalil Khamlichi wrote: > Hi everyone, > > I have a data stream of a call center application coming in to postgres > in this format : > > user_name, user_status, event_time > > 'user1', 'ready', '2017-01-01 10:00:00' > 'user1',

[GENERAL] time series data

2017-10-01 Thread Khalil Khamlichi
Hi everyone, I have a data stream of a call center application coming in to postgres in this format : user_name, user_status, event_time 'user1', 'ready', '2017-01-01 10:00:00' 'user1', 'talking', '2017-01-01 10:02:00' 'user1', 'after_call', '2017-01-01 10:07:00' 'user1', 'ready', '2017-01-01