Skip to content

RaBa64/OpenDTU-Database

 
 

Repository files navigation

OpenDTU-Database-Database

OpenDTU-Database

One year OpenDTU-Database Image

OpenDTU Build cpplint Yarn Linting

OpenDTU-Database adds an ESP32 LittleFS Database and two energy charts, a column chart of the last 25 hours and a full calendar chart.

Screenshot

OpenDTU-Database adds an ESP32 LittleFS Database and two energy charts, a column chart of the last 25 hours and a full calendar chart.

There are 3 new APIs available, returning JSON strings:

API returned values
/api/database returns all recored data points from the database with total energy value
/api/databaseHour returns the energy per hour for the last 25 hours
/api/databaseDay returns the energy for each day

Each data point has the following format: [ year (00-99), month (1-12), day (1-31), hour (0-23), energy (Wh) ]

Example: [23,6,30,15,132.995605]

The 192KB LittleFS in OpenDTU can store around 6 years of data, because each data point needs only 8 bytes of memory.

Screenshot

Background

This project was started from this discussion (Mikrocontroller.net). It was the goal to replace the original Hoymiles DTU (Telemetry Gateway) with their cloud access. With a lot of reverse engineering the Hoymiles protocol was decrypted and analyzed.

Documentation

The documentation can be found here. Please feel free to support and create a PR in this repository to make the documentation even better.

Breaking changes

Generated using: git log --date=short --pretty=format:"* %h%x09%ad%x09%s" | grep BREAKING

* 1b637f08      2024-01-30      BREAKING CHANGE: Web API Endpoint /api/livedata/status and /api/prometheus/metrics
* e1564780      2024-01-30      BREAKING CHANGE: Web API Endpoint /api/livedata/status and /api/prometheus/metrics
* f0b5542c      2024-01-30      BREAKING CHANGE: Web API Endpoint /api/livedata/status and /api/prometheus/metrics
* c27ecc36      2024-01-29      BREAKING CHANGE: Web API Endpoint /api/livedata/status
* 71d1b3b       2023-11-07      BREAKING CHANGE: Home Assistant Auto Discovery to new naming scheme
* 04f62e0       2023-04-20      BREAKING CHANGE: Web API Endpoint /api/eventlog/status no nested serial object
* 59f43a8       2023-04-17      BREAKING CHANGE: Web API Endpoint /api/devinfo/status requires GET parameter inv=
* 318136d       2023-03-15      BREAKING CHANGE: Updated partition table: Make sure you have a configuration backup and completly reflash the device!
* 3b7aef6       2023-02-13      BREAKING CHANGE: Web API!
* d4c838a       2023-02-06      BREAKING CHANGE: Prometheus API!
* daf847e       2022-11-14      BREAKING CHANGE: Removed deprecated config parsing method
* 69b675b       2022-11-01      BREAKING CHANGE: Structure WebAPI /api/livedata/status changed
* 27ed4e3       2022-10-31      BREAKING: Change power factor from percent value to value between 0 and 1

Currently supported Inverters

A list of all currently supported inverters can be found here

About

Software for ESP32 to talk to Hoymiles Inverters with Database

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C++ 63.1%
  • Vue 26.1%
  • C 7.1%
  • TypeScript 2.4%
  • Python 1.0%
  • SCSS 0.1%
  • Other 0.2%