I'm new to the forum, did some searching but was unable to find an answer..
Is it possible to have the hw write/post to an online sql server database?
Archived Forum |
|
SQL ServerSubmitted by Guest on Wed, 17/07/2013 - 13:32I'm new to the forum, did some searching but was unable to find an answer.. Is it possible to have the hw write/post to an online sql server database? » |
Re: SQL Server
Yes, there's a MySQL database at the heart of emonCMS.org. If you have another in mind, you would need to rewrite the part of the base sketch to format and send the data as your new database requires it.
Re: SQL Server
Does the system write directly to the db or via some sort of post methods to http?
Re: SQL Server
The latter. Take a look at the sketches for the NanodeRF or OKG base and you'll see exactly how it's done. You can if you wish also download emonCMS, which is the PHP page(!) that handles those posts as well as providing the user interface
Re: SQL Server
There are several available emonBases. If you chose to use the RaspberryPi, I guess you can adapt it to write into your DB server. (I could even give a hand, at least a few hints.)
Note that the OpenEnergyMonitor philosophy is to let emoncms (the php interface) do a good part of the post processing, so by choosing not to use it, you may be limited in terms of processing, or you may have to recreate the equivalent operation in emonBase.