Time series data for IOT project

I've been working on an IOT project that's time series heavy. It got me to think how to best process that. Build an API that the device (eg Raspberry) can post to and store. But MySQL or Postgres doesnt seem best practice for this. So I thought InfluxDB. For the 'regular CRUD stuff' I'd still use Postgres.

Anyone has any tips on how to best set this up (if at all in this way?)? I haven't found a Laravel package for Influx, making me doubt I'm on the right path...

aschmelyun

4 years ago

Best Answer

Level 4

Hey @axtg funny you should mention this, I'm actually working on the exact same thing on the side!

I have a RaspberryPi pulling in weather and temperature data, and sending it over to a Laravel app that was previously using a MySQL database as the main time-series store. Problem is, it got big fast lol.

I also looked into InfluxDB, and while I don't have any personal resources for you, I do have these bookmarked to help me when I make the switch, and it might help you too:

https://github.com/influxdata/influxdb-php
https://www.influxdata.com/blog/getting-started-php-influxdb/
https://github.com/tray-labs/laravel-influxdb (though this is just a wrapper for the influxdb-php lib)

Anyway, you can definitely use it with a Laravel project! I was torn between this or Redis (since it's baked into Laravel already), but support for time series with it is a little iffy.

axtg

4 years ago

Level 5

Thanks @aschmelyun, happy to read that I'm not thinking something "crazy" here. Just seems we're early to the party. If an official PHP Influx wrapper has fewer stars on Github than basically any Spatie package, one starts to wonder :D.

To be continued!

1 like

Please or to participate in this conversation.