how to perform an action at a set frequency?

[Reza Razavipour]

I have a node application and I need to ensure a database connection stays open and operational. I want to do lets say every 30 seconds.

What is the customary approach in node?

Thanks

[Martin Gonzalez]

Hi, Check setInterval() here http://nodejs.org/api/timers.html

--
--
Job Board: http://jobs.nodejs.org/
Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to nod...@googlegroups.com
To unsubscribe from this group, send email to
nodejs+un...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
 
---
You received this message because you are subscribed to the Google Groups "nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nodejs+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Martin

[// ravi]

On Feb 19, 2014, at 11:45 AM, Reza Razavipour <reza.ra...@gmail.com> wrote:

I have a node application and I need to ensure a database connection stays open and operational. I want to do lets say every 30 seconds. What is the customary approach in node?

You can use a setTimeout/setInterval timer to send a periodic dummy query to the database to keep the connection alive, but I’d suggest trying to perform reconnection gracefully (or report an error if not possible) using whatever mechanism your database API/driver provides. For instance, with MySQL you could use node-mysql’s connection pool mechanism and obtain connections from the pool when you have queries to perform.

—ravi

[Reza Razavipour]

this a soap server connection and I do not see a way to do what you are recommending? Am i missing it?

[Raymond Feng]

Do you access a database via the SOAP/WS API? If so, what SOAP Node.js library do you use?

Thanks,

Raymond

[Reza Razavipour]

i use soap... npm install soap and then for postgres database I use pg package.

Regards,
Reza

--
--
Job Board: http://jobs.nodejs.org/
Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to nod...@googlegroups.com
To unsubscribe from this group, send email to
nodejs+un...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
 
---

You received this message because you are subscribed to a topic in the Google Groups "nodejs" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nodejs/vWM1wlEXYy8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nodejs+un...@googlegroups.com.