sqlalchemy compiles a primary key FLOAT column to SERIAL by using a postgres database. This behaviour happens only when there are no foreign key relationships on the column defined and there is no ...

The problem. SQL sensor with uncontrollable number precision floods state_attributes table. When SQL-sensor fetch result it store all data to state_attributes.shared_data JSON, so any new FLOAT value ...