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...rton/index.php

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

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



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings