Just looking for general advice here.
We currently have a system of data recorders, recording pressure and environmental data with particle electrons in the field and we are switching to blues. We originally used MySQL and then migrated to PostgresDB. The database is currently hitting 40GB for 250 devices and growing.
I don’t necessarily need to migrate the data, but as we move to 1,000s of devices, I am sure there are better databases out there.
Besides time series data, we also need to store customer service and configuration data.
Any ideas or experiences would be helpful