HN user

philefstat

79 karma
Posts7
Comments14
View on HN

yes you can add jobs with sql in a transaction, e.g.

SELECT graphile_worker.add_job( 'send_email', json_build_object( 'to', 'someone@example.com', 'subject', 'graphile-worker test' ) );

(can also use the PERFORM statement instead of SELECT)

have also used/introduced this to several places I've worked and it's been great each time. My only qualm is it's not particularly easy to modify the exponential back off timing without hacky solutions. Have you ever found a good way to do that?

[dead] 12 years ago

Note: We created in 20 hours at the TechCrunch Disrupt hackathon, where we were 1st runners up. -- Appilepsy is a mobile app that detects if you are having a convulsive epileptic seizure through an intelligent algorithm which analyses accelerometer data in real-time in your phone's background. Following the detection of a seizure, the app runs a countdown for an adjustable amount of time in which the alarm can be deactivated, in case of a false positive. If the alarm is not deactivated, the app automatically sends your emergency contacts both a text message and a computer-generated voice message utilizing the Nexmo API. The text message contains a link to our web app, which is a responsive site that works on any screen-size. This site displays the location of the phone at the time of the seizure on a map generated by esri's arcGIS API, as well as a link to citymapper for directions to that location. While the app sends these messages, it provides real-time updates of whether the emergency contacts have seen the message/received the call. It also provides a map to the nearest medical facilities and instructions for people aiding the person seizing via computer generated voice commands. http://appilepsy.phil.bio/