Netduino home hardware projects downloads community

Jump to content


The Netduino forums have been replaced by new forums at community.wildernesslabs.co. This site has been preserved for archival purposes only and the ability to make new accounts or posts has been turned off.
Photo

Connecting Netdruino to MySQL db


  • Please log in to reply
2 replies to this topic

#1 newfierich

newfierich

    Member

  • Members
  • PipPip
  • 15 posts

Posted 17 June 2011 - 11:29 AM

Wondering if anyone has tried or has working code on how to connect netdruino to a MySql db.

#2 Chris Seto

Chris Seto

    Advanced Member

  • Members
  • PipPipPip
  • 405 posts

Posted 17 June 2011 - 12:37 PM

There isn't really a good way to do this directly, as any full MySQL driver would probably take up most of the RAM and flash, however you could write a sort of REST API and tie the Netduino to that. Keep in mind, I would consider such a system to be highly insecure, due to the risk of someone unauthorized getting in to said REST API and either dumping or dropping the tables. A better option would be to expose any functionality you need through such a REST API and then secure upon that. This means that full MySQL queries can not be injected.
  • newfierich likes this

#3 newfierich

newfierich

    Member

  • Members
  • PipPip
  • 15 posts

Posted 17 June 2011 - 01:15 PM

There isn't really a good way to do this directly, as any full MySQL driver would probably take up most of the RAM and flash, however you could write a sort of REST API and tie the Netduino to that. Keep in mind, I would consider such a system to be highly insecure, due to the risk of someone unauthorized getting in to said REST API and either dumping or dropping the tables.

A better option would be to expose any functionality you need through such a REST API and then secure upon that. This means that full MySQL queries can not be injected.


Thanks, Like you said I guess I will have to come up with something on the server side. I didn't know if there were any light weight libs, but I guess not.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

home    hardware    projects    downloads    community    where to buy    contact Copyright © 2016 Wilderness Labs Inc.  |  Legal   |   CC BY-SA
This webpage is licensed under a Creative Commons Attribution-ShareAlike License.