Обсуждение: Re: PG-MQ?

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


      
____________________________________________________________________________________
Get the free Yahoo! toolbar and rest assured with the added security of spyware protection.
http://new.toolbar.yahoo.com/toolbar/features/norton/index.php

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

On 6/20/07, Rob Butler <crodster2k@yahoo.com> 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 languages, protocols and supports a ton of features.  Could you simply use
that?

I guess that if you need standalone message broker, the
ActiveMQ may be good choice.  At least, any solution that
avoids the database when passing messages should outperform
solutions that pipe stuff thru (general-purpose) database.

OTOH, if you _do_ need to transport the events via database
it should be very hard to outperform PgQ. :)  As it uses the
user-level xid/snapshot trick introduced by rserv/erserver/slony,
which is not possible with other databases other than PostgreSQL.

-- 
marko