# Node-red and influxDB

**URL:** <https://discourse.nodered.org/t/node-red-and-influxdb/63406>\
**Category:** General\
**Created:** [2 June 2022 22:51 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406 "2022-06-02T22:51:47Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![a45293](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/a45293/32/62556_2.png) [@a45293](https://discourse.nodered.org/u/a45293)\
**Post date:** [2 June 2022 22:51 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/1 "2022-06-02T22:51:47Z")

</div>

Hi, everyone, can someone help me,  
i need do send my base64 data to influxdb and when i try to do it, i get the error " unsupported input type for mean aggregate: string "  
Can someone help me, please.

 ![nodered](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/b/db634207548160c352c0b3fbe8531e521d280573.png)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [3 June 2022 00:18 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/2 "2022-06-03T00:18:07Z")

</div>

What are you trying to achieve? You wouldn't normally send binary data to InfluxDB which is a timeseries database. Indeed it doesn't support such a datatype.

---

<div class="post-metadata">

**Author:** ![a45293](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/a45293/32/62556_2.png) [@a45293](https://discourse.nodered.org/u/a45293)\
**Post date:** [3 June 2022 00:47 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/3 "2022-06-03T00:47:35Z")

</div>

in my project I have 2 clients in which one has to take a photo and send it to the other client, this client receives a maximum of 10 photos and these 10 photos must be stored in a database.  
this is my node-red project:

 ![1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/7/172b1fe1eb284cf70ca4d1bf65cc685848272eae.png)  
 ![22](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/b/ebc6213699a61e66fada62a3115c5d9a466933a0.jpeg)

---

<div class="post-metadata">

**Author:** ![a45293](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/a45293/32/62556_2.png) [@a45293](https://discourse.nodered.org/u/a45293)\
**Post date:** [3 June 2022 00:48 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/4 "2022-06-03T00:48:39Z")

</div>

and the other client have a dashboard like this

 ![33](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/d/2dce581e24e144c1d2e57a8c4a4c37bccffa439b.jpeg)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [3 June 2022 01:28 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/5 "2022-06-03T01:28:22Z")

</div>

> [@a45293](#):
>
> these 10 photos must be stored in a database

Sorry, but InfluxDB is the wrong type of database for this use. As mentioned, it does not store binary data. It is used for statistical analysis of timeseries data. Great for analysing IoT sensor data over time. No use for storing photos I'm afraid.

---

<div class="post-metadata">

**Author:** ![a45293](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/a45293/32/62556_2.png) [@a45293](https://discourse.nodered.org/u/a45293)\
**Post date:** [3 June 2022 02:23 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/6 "2022-06-03T02:23:05Z")

</div>

what can i use instead ?

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [3 June 2022 04:10 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/7 "2022-06-03T04:10:59Z")

</div>

for example sqlite or mariadb/mysql.

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [3 June 2022 09:26 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/8 "2022-06-03T09:26:30Z")

</div>

Or even MQTT at a pinch.

---

<div class="post-metadata">

**Author:** ![a45293](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/a45293/32/62556_2.png) [@a45293](https://discourse.nodered.org/u/a45293)\
**Post date:** [3 June 2022 12:42 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/9 "2022-06-03T12:42:42Z")

</div>

thank you all

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [17 June 2022 12:43 UTC](https://discourse.nodered.org/t/node-red-and-influxdb/63406/10 "2022-06-17T12:43:29Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.