0

Saving sensor data to external SQL server.
Moderators: adafruit_support_bill, adafruit

Please be positive and constructive with your questions and comments.

Saving sensor data to external SQL server.

by pcborges on Sun Aug 18, 2019 5:38 pm

Hi, I have been looking around and it is rare for an IoT service to offer the possibility to save sensor data to a permanent storage like an external SQL server.
I have sensor data that only makes sense when examined comparing monthly totals, it has been very difficult to find a service, even paid, to store a whole year or more of sensor data.
Thanks

pcborges
 
Posts: 10
Joined: Thu Aug 15, 2019 6:18 am

Re: Saving sensor data to external SQL server.

by brubell on Mon Aug 19, 2019 9:52 am

Adafruit IO Plus (the paid version of Adafruit IO) can provide up to 60 days of data storage. While you can download your feeds as CSV data, we don't currently offer integration with external SQL servers.

Seeing as this is not enough for your use case, possibly using Google IoT Cloud Core along with GCP Databases (https://cloud.google.com/products/databases/) would be a robust, paid, solution for long-term sensor data storage.

- brent r

brubell
 
Posts: 496
Joined: Fri Jul 17, 2015 10:33 pm

Please be positive and constructive with your questions and comments.