I've done work on NRT data, but I'm not the one who's responsible for generating alerts on the matter.

A few things that you might want to consider:

• I don't know how the entries get into your database, but rather than query against a growing table, you may be able to set up a trigger that logs to a second table that you can grab everything from every 3 minutes and then clear in that same transaction.
• Depending on the database, the trigger itself might be able to generate e-mail or send some other signal for the e-mail to go out. (if using Postgres, there's PL/pgSQL, but there's something you have to do first to allow access to all perl functions). But if you can get it to export anything to an external file, you can have a daemon sit and poll for that file so you don't beat on the database.
• The astronomy community has the Gamma-ray Coordinates Network to distribute even information in (near?) real time.
• In Earth science, there's the Volcano Notification Service. I suspect that there would be other warning systems for critical weather events that are more push-like. (all that I know about is the NWS, which is a pull)
• Distributing NRT solar data just came up yesterday on the code4solar mailing list. (because I brought it up), but it's for the data for re-analysis so lags by a good 15 minutes. The event detection info gets pumped into the Heliophysics Event Knowledgebase.

---

---

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! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

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:
	&		&
	<		&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.