Messaging System in Omnis
malkishtini at gmail.com
Thu Jan 5 19:07:56 EST 2017
Yes and we are using the notify object/mechanism that you are referring to in our app and that is one of the options I'm considering, but as you mentioned this is only supported in postgres 9+ and we do have many clients on 8.4.
Thank you very much for your feedback, it confirms that I'm looking in the right direction. :).
I'm thinking to use a timer and query the db (to replace the notify feature) for clients running postgres 8.4, but not sure how stable that will be.
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Doug Easterbrook
Sent: Thursday, January 05, 2017 6:57 PM
To: OmnisDev List - English
Subject: Re: Messaging System in Omnis
there is the listen notify xcomp for postgres.
it requires a db connection, but it will fire off a message to whomever is listening for that message immediately — so no polling required.
This is something we’ve shown for the past few years at euromnis.
needs postgres 9 and up, I think
Arts Management Systems Ltd.
mailto:doug at artsman.com
Phone (403) 650-1978
> On Jan 5, 2017, at 3:23 PM, Mayada Al-Kishtini <malkishtini at gmail.com> wrote:
> Hi $all,
> Happy New Year!
> I'm in the process of adding a new internal messaging system to our
> app (Omnis 6.1.3/ PostgreSQL 8.4 and 9.1+) and I'm researching options.
> But before proceeding further, I wanted to check with the list to see
> if anyone has done any messaging system before using Omnis/ PostgreSQL
> combo or not.
> Any comment or advice in this regard is welcomed!
> Thank you in advance for any feedback, Mayada
> Manage your list subscriptions at http://lists.omnis-dev.com
Manage your list subscriptions at http://lists.omnis-dev.com
More information about the omnisdev-en