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
>
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
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 :
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 |
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
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|
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
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',
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.
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
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',
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
12 matches
Mail list logo