Re: [HACKERS] NOTIFY with tuples

2011-12-14 Thread Thomas Munro
On 14 December 2011 15:10, Merlin Moncure wrote: > As to the wider point I'm wondering why you can't layer your API on > top of existing facilities (tables, notifications, etc). PGQ (have you > seen that?) does this and it's an absolute marvel.  Meaning, I bet you > could do this with an 'all sql

Re: [HACKERS] NOTIFY with tuples

2011-12-14 Thread Merlin Moncure
On Tue, Dec 13, 2011 at 11:27 PM, Thomas Munro wrote: >> Actually, what I'd suggest is just some code to serialize and >> deserialize tuples and transmit 'em via the existing NOTIFY payload >> facility.  I agree that presenting it as some functions would be a lot >> less work than inventing bespok

Re: [HACKERS] NOTIFY with tuples

2011-12-14 Thread David E. Wheeler
On Dec 13, 2011, at 8:21 PM, Tom Lane wrote: >> I'm not sure whether we'd want something like this in core, so for a >> first go-around, you might want to consider building it as an >> extension. ... I'm not sure you >> need NOTIFY for anything anywhere in here. > > Actually, what I'd suggest is

Re: [HACKERS] NOTIFY with tuples

2011-12-13 Thread Thomas Munro
On 14 December 2011 04:21, Tom Lane wrote: > Robert Haas writes: >> On Tue, Dec 13, 2011 at 6:30 PM, Thomas Munro wrote: >>> I imagine a very simple system like this, somehow built on top of >>> the existing NOTIFY infrastructure: > >> I'm not sure whether we'd want something like this in core,

Re: [HACKERS] NOTIFY with tuples

2011-12-13 Thread Tom Lane
Robert Haas writes: > On Tue, Dec 13, 2011 at 6:30 PM, Thomas Munro wrote: >> I imagine a very simple system like this, somehow built on top of >> the existing NOTIFY infrastructure: > I'm not sure whether we'd want something like this in core, so for a > first go-around, you might want to consi

Re: [HACKERS] NOTIFY with tuples

2011-12-13 Thread Robert Haas
On Tue, Dec 13, 2011 at 6:30 PM, Thomas Munro wrote: > It seems there are number of academic and commercial > systems (StreamSQL [1], CQL [2], ...)  which provide powerful > queryable streams of tuples, including windowing, grouping, > joining and pipelining facilities, all of which are far beyond

[HACKERS] NOTIFY with tuples

2011-12-13 Thread Thomas Munro
Hi, I've used LISTEN/NOTIFY in a few apps with great success (both the new and the old implementation) but I've found myself wondering why I couldn't use a richer payload, and wondered if anyone already had plans in this direction. It seems there are number of academic and commercial systems (Str