Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Building a notification system based on MySQL

by Illuminatus (Curate)
on Nov 17, 2008 at 23:48 UTC ( [id://724153]=note: print w/replies, xml ) Need Help??


in reply to Building a notification system based on MySQL

Can't you simply store the "OR" statements as actual 'or' regex strings? For each set of rows with matching fgid's, create a hash keyed by slot values. First check if the slot value is defined in the hash. If not, just add it, otherwise append |value to the existing value for that slot key. Then, when an event comes in, use =~ to match slots instead of eq

Does that make sense?

  • Comment on Re: Building a notification system based on MySQL

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://724153]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (4)
As of 2024-05-18 23:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found