Hi all,
My future setup will consist of 50+ teensy 4.1 boards that will be connected via ethernet switches to a single raspberry pi and each of them will transmit ~40 byte of sensor data on average twice a second. However it could be that all transmit at once.
Data integrity is very important for this project, so as I understand it, the UDP protocol is not as well suited for the task as packages could be dropped.
TCP should correct this as it is able to retransmit if data gets lost. When the data is transmitted/received is not important.
Now on the receiving side, I would like to use a raspi that collects the data from all 50+ boards and saves it "somewhere". As this will be an isolated network, I would like to be able to connect a laptop and just copy the current database. (which as I understand all support)
Since the timing on the teensy boards is critical I would like to avoid any code that is blocking for more than ~10ms (ideally <= 5ms) (a full SQL implementation could take that long?)
Some research turned out influxDB and SQlite or very primitively 50 csv files.
Simplicity on the raspberry pi side is also highly appreciated.
I'd be glad for any advice or recommendations!
Cheers!