Stored Procedures from sql to Influxdb

Hello, I’m new to using this database and its technologies. I was using an SQL database containing stored procedures for tracking data produced in the company. As SQL is not suitable for storing temporal data, I chose to use Influxdb. As I’m still a beginner, I would like to know if there is a way of transforming these stored procedures into other procedures that can be used in Influxdb. I’ve done some research and found that Kapacitor can do similar things, but I’m very confused.
Could you tell me how to proceed?

Thank you very much.

Hello @Lily,
Kapacitor is for v1 and doesn’t have any support. I don’t suggest using it.
Instead I would use something like mage or quix for data processing.

I’d also suggest using InfluxDB cloud v3 or waiting for v3 oss to be released because v3 is much more performant.
Here are resources for tasks or data processing in v3:

You can query v3 with sql.

That being said you can use Flux for v2 but it has a significant barrier to adoption. And v2 has a lot of features (like Flux) that don’t exist in v3 so migrating will become harder.

1 Like

Thanks @Anaisdg for the answer