Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-29 Thread Misa Simic
Thanks Janes... I am not a C developer - was not aware about select()... I was read it as some kind of sleep... Than Clemens explained to me what select() does... However - to me it is just implementation detail... Which is possible in one language, but not in another... But technically, is

Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-29 Thread Daniel Verite
Misa Simic wrote: I am not a C developer - was not aware about select()... I was read it as some kind of sleep... php provides socket_select() as an equivalent to C's select(). See http://php.net/manual/en/function.socket-select.php But it takes socket resources as arguments and the

Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-28 Thread Jasen Betts
On 2013-03-27, Misa Simic misa.si...@gmail.com wrote: --20cf3074d6a0c370ce04d8ef50c1 Content-Type: text/plain; charset=UTF-8 Hi Clemens, Well, I am not sure what you mean by polling... But Example shows - that C app - actually asks all the time to get notify... when gets something more

[GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-27 Thread Clemens Eisserer
Hi, Sorry for asking such a newbie-question, I've used a search engine - however I haven't found what I am searching for. Is there any way to listen to NOTIFY in php without polling using a callback or blocking call? I've only found pg_get_notify(), however it requires polling as far as I

Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-27 Thread Bill Moran
In response to Clemens Eisserer linuxhi...@gmail.com: Is there any way to listen to NOTIFY in php without polling using a callback or blocking call? Not at this time. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general

Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-27 Thread Clemens Eisserer
Hi Bill, Is there any way to listen to NOTIFY in php without polling using a callback or blocking call? Not at this time. Too bad ... Thanks for the confirmation. I'll try to invoke a native libpg binary which stays alive until a NOTIFY is received, should do the trick in case

Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-27 Thread Misa Simic
Hi, What is the main goal? even using libpg - you need to call pg notify... Doc says, just using libpgtcl would be possible to get Notify event - without checking from time to time... Kind Regards, Misa 2013/3/27 Clemens Eisserer linuxhi...@gmail.com Hi Bill, Is there any way to listen

Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-27 Thread Clemens Eisserer
Hi Misa What is the main goal? The main goal is to perform some inter-system communication in the case some rows in one table are updated (very seldom event). even using libpg - you need to call pg notify... Doc says, just using libpgtcl would be possible to get Notify event - without

Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-27 Thread Misa Simic
Hi Clemens, Well, I am not sure what you mean by polling... But Example shows - that C app - actually asks all the time to get notify... when gets something more then 4 times - exit... until 4 times loops... The same you can achieve with PHP... But I am not sure that is the main goal... My

Re: [GENERAL] Is there any way to listen to NOTIFY in php without polling?

2013-03-27 Thread Clemens Eisserer
Hi Misa But Example shows - that C app - actually asks all the time to get notify... when gets something more then 4 times - exit... until 4 times loops... The same you can achieve with PHP... As far as I understood, with php I have to query the server again and again, and pg_get_notify will