You could look at Postgres, which has NOTIFY. There also are many, many other methods of doing inter-process communication (IPC). Maybe using the filesystem and inotify works on your OS, or simply writing to a pipe. Using some kind of shared memory as a blackboard is also a good approach if all you care about is whether there are new events.

You could also look at adding a message queue (server) to your setup. This brings another server into your setup. You could also use long polling HTTP ("REST") requests to notify you of a change.

In any case, you will be looking at adding a message queue to your setup, or at least a notification queue. This will bring you additional headaches as you will need to plan on whether receiving a message and acting on it is idempotent or not. It will bring you greater flexibility because you can easily add more subscribers to your infrastructure that way.

In reply to Re: RPC via mysql when running under websocketd? by Corion
in thread RPC via mysql when running under websocketd? by schweini

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.