If you use MS-SQL server, would suggest the “tedious” module over the MS one... it’s more portable. You may want to consider PostgreSQL or MySQL if either are an option (I prefer PostreSQL). (based on what your are describing for your data, I would lean towards an SQL database vs a non-relational db... Some use cases are better suited for NoSQL, yours doesn’t seem to be one of them)
You can mount endpoints pretty easily with nodejs, though there are some REST frameworks for getting you going faster. For running the application as a service in windows, you’ll likely want to use NSSM (Non-Sucking Service Manager) to create your service entry in windows. For Linux, depends on your distro & version. As for “exporting” to excel if you only need one worksheet would just output to CSV which excel can open (then re-save) fine... if you need more, there are libraries, but they come with a little more overhead. From: Syed Haani Sent: Wednesday, November 27, 2013 4:55 AM To: [email protected] Subject: [nodejs] Node.js support for Exporting excel and Database I am new to node.js. I am currently in a pre-development phase of an application. The application will be for tracking status of task of employee. The admin will have the right to export excel which will have data of employes for a given date range Currently I am thinking WCF Service and SQL Server for the backend. Few days back, someone told me about node.js and it's capabilities. And yes I was impressed I wanted to know if I write a service with node.js, how will the service be hosted, also if I can write code for exporting data in excel, and lastly which database providers/adapters does node.js support? Apologies if there is typo or this question need to be asked in any other community of stackExchange. Thanks in advance Syed -- -- 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out. -- -- 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
