Whow, this is VERY nice! I’m using Tryton for storing data about sensors and systems. The “realtime” sensor data is stored on different intervals and to minimize extra rows, I’m storing the data of the different sensor into a Dict als “sensorname” -> “value”.
To get the values out of the database I had to write my own SQL-query, but this is becoming more Tryton like
<“offtopic”>
The only thing missing now is getting the date from a datetime stamp in the database. E.g. you have a datetime column called “storedate” with the value 2018-12-04 23:00:10. In PostgreSQL you can get only the date by calling storedate::date or only the time bij calling storedate::time. But I think this is something for the python-sql module.
<"/offtopic">