Re: [HACKERS] PG-MQ?

2007-06-20 Thread Chris Browne
[EMAIL PROTECTED] (Steve Atkins) writes: Is there any existing work out there on this? Or should I maybe be looking at prototyping something? The skype tools have some sort of decent-looking publish/subscribe thing, PgQ, then they layer their replication on top of. It's multi consumer and

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Jeroen T. Vermeulen
On Wed, June 20, 2007 04:45, Chris Browne wrote: I'm seeing some applications where it appears that there would be value in introducing asynchronous messaging, ala message queueing. http://en.wikipedia.org/wiki/Message_queue The granddaddy of message queuing systems is IBM's MQ-Series, and I

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Markus Schiltknecht
Hi Chris, Chris Browne wrote: I'm seeing some applications where it appears that there would be value in introducing asynchronous messaging, ala message queueing. http://en.wikipedia.org/wiki/Message_queue ISTM that 'message queue' is a way too general term. There are hundreds of different

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Marko Kreen
On 6/20/07, Jeroen T. Vermeulen [EMAIL PROTECTED] wrote: On Wed, June 20, 2007 04:45, Chris Browne wrote: - Sometimes you have the semantics where: - messages need to be delivered at least once - messages need to be delivered no more than once - messages need to be delivered exactly

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Heikki Linnakangas
Marko Kreen wrote: As I understand, JMS does not have a concept of transactions, probably also other solutions mentioned before, so to use PgQ as backend for them should be much simpler... JMS certainly does have the concept of transactions. Both distributed ones through XA and two-phase

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Marko Kreen
On 6/20/07, Heikki Linnakangas [EMAIL PROTECTED] wrote: Marko Kreen wrote: As I understand, JMS does not have a concept of transactions, probably also other solutions mentioned before, so to use PgQ as backend for them should be much simpler... JMS certainly does have the concept of

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Jeroen T. Vermeulen
On Wed, June 20, 2007 18:18, Heikki Linnakangas wrote: Marko Kreen wrote: As I understand, JMS does not have a concept of transactions, probably also other solutions mentioned before, so to use PgQ as backend for them should be much simpler... JMS certainly does have the concept of

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Heikki Linnakangas
Jeroen T. Vermeulen wrote: On Wed, June 20, 2007 18:18, Heikki Linnakangas wrote: Marko Kreen wrote: As I understand, JMS does not have a concept of transactions, probably also other solutions mentioned before, so to use PgQ as backend for them should be much simpler... JMS certainly does

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Rob Butler
Do you guys need something PG specific or built into PG? ActiveMQ is very nice, speaks multiple languages, protocols and supports a ton of features. Could you simply use that? http://activemq.apache.org/ Rob

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Jeroen T. Vermeulen
On Wed, June 20, 2007 19:42, Rob Butler wrote: Do you guys need something PG specific or built into PG? ActiveMQ is very nice, speaks multiple languages, protocols and supports a ton of features. Could you simply use that? http://activemq.apache.org/ Looks very nice indeed! Jeroen

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Marko Kreen
On 6/20/07, Rob Butler [EMAIL PROTECTED] wrote: Do you guys need something PG specific or built into PG? Yes, we need it usable from inside the DB, thus the PgQ. That means the events are also transactional with other things happening in the DB. ActiveMQ is very nice, speaks multiple

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Chris Browne
[EMAIL PROTECTED] (Marko Kreen) writes: To Chris: you should like PgQ, its just stored procs in database, plus it's basically just generalized Slony-I, with some optimizations, so should be familiar territory ;) Looks interesting... Random ideas - insert_event in C (way to get

Re: [HACKERS] PG-MQ?

2007-06-20 Thread Marko Kreen
On 6/20/07, Chris Browne [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] (Marko Kreen) writes: To Chris: you should like PgQ, its just stored procs in database, plus it's basically just generalized Slony-I, with some optimizations, so should be familiar territory ;) Looks interesting... Thanks

[HACKERS] PG-MQ?

2007-06-19 Thread Chris Browne
I'm seeing some applications where it appears that there would be value in introducing asynchronous messaging, ala message queueing. http://en.wikipedia.org/wiki/Message_queue The granddaddy of message queuing systems is IBM's MQ-Series, and I don't see particular value in replicating its

Re: [HACKERS] PG-MQ?

2007-06-19 Thread Steve Atkins
On Jun 19, 2007, at 2:45 PM, Chris Browne wrote: I'm seeing some applications where it appears that there would be value in introducing asynchronous messaging, ala message queueing. http://en.wikipedia.org/wiki/Message_queue Me too. My bias would be to have something that can basically run