Avoiding large daq files about fuxa HOT 4 OPEN

@unocelli and I have been working on the ODBC driver for database in the odbc branch. I'm using postgreSQL and PGadmin. Currently writing to the DB from the scripting works fine, so you can also logs your tags to the DB with any logic/filtering you want from within the script. The Table has not been done yet to read back from the DB. I can provide some example code to get you going and the docker-compose to setup postgreSQL etc

another option is to use InfluxDB which is faster and compresses the stored data better, but you are still limited to the Fuxa default logging options

from fuxa.

Hi, I think you mean a feature to set a 'deadband' on the tags for DAQ registration.
Sending the data to the client is the search for the compromise, you cannot have a detailed history if you want to look at a month's data.

from fuxa.

I think you mean hysteresis. Yes, it is necessary especially for analog signals. For example, tracking a level that must reach a certain threshold can lead to the unwanted triggering of an action such as archiving many times around the set threshold value.

from fuxa.

Thanks Robsori and Matthew. These improvements in the server/db side looks fine, i will take in account in the next project. Anyway is the also browser who gets out of memory, and then may be matter of send very large json sets also or something related (I'm not a full stack dev, only a PLC programmer). What I mean is, irrespective of the server side improvements, it should be advisable to avoid large db files with techniques as thresholding, set limits on parametrization.

from fuxa.