Helllo there! I'm glad that you reply. Firstly, I'm giving the hardware which is beaglebone Black and the Weather cape. Basically, I need to retrieve the sensor value from the Weather Cape therefore I mount the Weather Cape to the BeagleBone Black. That's how i managed to get my sensor value with the code that i type. The code is for sensor in /sys/bus/i2c/devices/i2c-1/*/*_input; do echo -n "$(basename $sensor): "; cat $sensor; done
when i key in the code above , the result display as below : lux1_input: 121 humidity1_input: 58476 temp1_input: 25297 pressure0_input: 99590 temp0_input: 250 Therefore i need to store all this value in a database records and the application i'm using is visual studio ,sql database server. As we know the value of the sensor might keeep changing therefore I need the application to run every 30s and updated the lastest value into the database itself. Do you have the simplest way to do it? Best Regards, Tiffany On Sunday, 4 January 2015 22:47:55 UTC+8, Przemek Klosowski wrote: > > You have to specify more precisely what you need. Do you want to store > individual values every 30 seconds as a separate records, or just > update the 'current record' with the latest value? If you just need > the last one, there's not much point to running the entire SQL setup > to store it, so I assume you want the former. > > How is your BBB connected to your other boxes: USB or Ethernet? > > This list is about beaglebone, so probably you won't get much help for > setting your Windows/SQL box here, but basically there are two ways to > do this system: pushing data from the BBB to Windows, and pulling the > data from Windows. If you are familiar with Windows and/or have access > to people who can help you there, you should try the latter. You got > some good advice on your Google post---use ODBC or other database > connector from MSSQL to BBB and automate the periodic update on > Windows. Actually, the simplest BBB setup would be a tight loop that > waits for a network connection, does a single sensor read and returns > the current value; the Windows code would then periodically connect, > read and store the data into MSSQL. > > Having said that, BBB is capable of running the database itself---have > you considered implementing the whole system on the BBB? > > Start describing your system in more detail: first what you want it to > do, then what parts you have, then how you want to use them for your > purpose. You will help yourself to understand your problem better, and > also help others to answer your questions. > > On Sun, Jan 4, 2015 at 8:30 AM, SHAO MIN <[email protected] <javascript:>> > wrote: > > Hello, > > > > does anyone know how to transfer sensor value that i got from my weather > > cape auto updated to the sql database server (Windows) and also let the > > sensor value run every like 30 seconds and update itself into the sql > > database? > > > > > > > > > > Regards, > > Tiffany > > > > -- > > For more options, visit http://beagleboard.org/discuss > > --- > > You received this message because you are subscribed to the Google > Groups > > "BeagleBoard" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to [email protected] <javascript:>. > > For more options, visit https://groups.google.com/d/optout. > -- For more options, visit http://beagleboard.org/discuss --- You received this message because you are subscribed to the Google Groups "BeagleBoard" 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/d/optout.
