SQL Server

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?

Robert Wall's picture

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.

freq's picture

Re: SQL Server

Does the system write directly to the db or via some sort of post methods to http?

Robert Wall's picture

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

Jérôme's picture

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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.