I am trying to build a simple Hub and Spoke system.
The main system is “H”
What I am trying to do is read power meters and create a transaction group that will write to a database a record that will look like this.
“MeterName”, MW,MVAR,EngeryIn,EnergyOut,MVarsIn, MvarsOut, Volt-a, Volt,-b Volt-c, Amps-a, Amps-b, Amps-c
Site A sql bridge would read a meter and write these records every 5 minutes.
Site B same
Site C same
Two question will SQL Lite Allow me to do this. And will it store and forward to allow for com failures.