Grafana Weather Dashboard on a Raspberry Pi using InfluxDB and an ESP32 - In-Depth Tutorial

[@TheRoeckie]

Exactly what I'm looking for. I'm going to put a bunch of sensors inside and outside my greenhouse to see how environmental parameters influence the growth. Great explanation!

[@MichaelKlements]

That's great! Try using BME280 sensors, they accurate and each does temperature, pressure and humidity all in one.

[@BillEason]

@@MichaelKlements In my experience with BME280 over the past 6-7 years, I find that the part has 1-2 degrees (F) of self-heating. If you're looking for reliable temperature sensing, I'd go with something else, but the barometric pressure sensing is amazing. It's able to detect changes in elevation of under 1/2 meter just based on the air pressure. Hard to believe, but true. To test the self-heating, (1) compare temp readings vs. other parts, like the SHT30 or (2) set it up to display temperature at short intervals -- like a couple of seconds apart. When you first power on the device, the temperature reading will be fairly accurate, but just watch it climb a degree or two within the first minute or so that it's turned on, then stabilize. Obviously, you'll have to turn it off and let it reach ambient temperature before doing that second test.

[@PoisonWaffle3]

Nifty! I've used similar hardware for a similar project, but used a completely different software approach. I've got a Pi hosting Home Assistant + ESPHome, InfluxDB, and Grafana (both HA add-ons), and it all runs locally. It's pretty straightforward to take the temperature/humidity from DHT22s connected to ESP8266 or ESP32 boards and display it in Grafana. I also have various other temperature sensors for my ecobee thermostat and inside my SmartThings buttons that I can pipe right into Grafana as well. I followed a few different guides on KZbin for the general concept, but did a few things a bit differently.

[@MichaelKlements]

That's awesome, sounds like you've got a pretty neat setup running!

[@jacocoetzee762]

Fantastic! I’m using the nano 33 sense with the esp32. Been looking exactly for this tutorial. Thanks so much!

[@MichaelKlements]

That's great!

[@GeekendZone]

Thanks it works, I make some modifications and used it with a BME280 sensor.

[@alvarogascon9161]

great video! Just what I was looking for!

[@gensys244]

Amazing beyond interesting 🧐 great job very much enjoy your projects !

[@MichaelKlements]

Thank you!

[@georgeboydratcliff1036]

Absolutely brilliant! Thank you!

[@mohammedrezk8072]

Very useful and straight forward many thanks

[@laszlobanyik2175]

Hi, it's a great and resourceful video. When I am trying to search for Arduino Client Library nothing comes up. Only Python Client library. Could you please help me out if you know the answer?

[@doncucumber]

Same problem here! Is it now only in the paid plans, maybe?

[@DamianMyszko]

Okay, I had same problem, but found a solution. Pick different library and change ending of URL adres. If you picked python, the ending should look like this ..../new-user-setup/python. Now just change "python" to "Arduino" and you'll see a page for arduino setup. I have no idea why it's hidden but it works.

[@TexanMechanicus]

I have followed your tutorial all the way through and it was very well explained. I am running into one issue and it is that I can not get grafana to display the temperature in Fahrenheit. Is there something I'm missing?

[@SmithyScotland]

When using graphana the most important thing to remember is to click the save button. Nothing auto saves. Very easy to throw away hours work. I speak from bitter experience. Also to say the dht11 is incredibly unreliable and inaccurate. Best to use an i2c sensor or at a push a dht22.

[@MichaelKlements]

Yeah I probably should have mentioned this a few more times, I have also lost a few hours work on Grafana because I didn't save and simply closed the browser. I agree, the DHT11 sensor is quite poor, but it was just one that I had lying around for this tutorial. My weather station uses a BMP280 sensor.

[@YuxiangChi]

agree, also their 'newer' python library is very unreliable. Do you have any i2c sensor recommended?

[@MichaelKlements]

The BME280 and BMP280 sensors often have I2C interfaces (all of Adafruits ones do).

[@bigpickles]

@@MichaelKlements The BME280 is the best choice out of all the above mentioned. Excellent little sensor and it's cheap!

[@dukara702]

Great video! Can I use a raspberry pi rather than ESP32 to collect sensor data following this tutorial?

[@MichaelKlements]

Yes you could log the data to InfluxDB using the Pi directly.

[@KawaiRonin]

Great work here man! I also noticed for ease of use, maybe include the libraries. I used a different set of sensors and libraries.

[@MichaelKlements]

Thanks for the suggestion and feedback!

[@extremeroom7u7]

i really likes your videos the are very informative

[@Ashish-v1d8i]

Pls make a separate video for grafana with prothemus using esp32,since no tutorial are available on KZbin 🙏

[@MrCentrax]

Excelent tutorial. Just one question. Why did you chose InfluxDB instead of Prometheus?

[@MichaelKlements]

InfluxDB is a better choice for time series logging, like weather metrics changing with time.

[@nielsnelson3570]

Hey thank you for this tutorial it was very helpful. I want to ask if it is possible to show me how you added the measurements into fields in Influxdb?

[@radish6691]

Nice! What is the little screen shown at the beginning, the one with the F1, F2, and F3 buttons?

[@MichaelKlements]

It's called a reTerminal by Seeed studios. It's a full Raspberry Pi based touch panel, it's got an embedded CM4 module.

[@noeliafernanda1061]

Good project 👍 But, one question: Where do I configure so that the panel updates in real time or refresh the screen automatically??? 🤔

[@MichaelKlements]

In your dashboard settings there is an option to refresh the dashboard in a set time period

[@nicklaspersson4687]

Great video and update to PI as a data collector. However in my experience the sensor DHT22 does not seem to survive below 0 dgr C. It will work for a few months and then crash your system. See others who also have had similar problems with it used outdoors, also it does have very low accuracy for humidity. Imho. its not worth the trouble.

[@MichaelKlements]

Thanks Nicklas! Yeah the sensors I've used here are just for the tutorial, they're not particularly accurate or reliable. I use BME280 sensors in my weather station and air quality monitoring setups.

[@legion9826]

Hi, thnks for whare it. How did you transfer the grafana dashboard to the tablet? simple browser or what?

[@muhammadrizkhi8428]

Wow greate video!! Thanks for tutor

[@Ashish-v1d8i]

Confused 🤔 Can we see our database on computer 💻 after configuring it with the esp as you shown?

[@MichaelKlements]

Yes, by going to the Grafana web dashboard on any computer on your local network

[@kelgar1]

Hi, great tutorial, could you do a video with the BME280? Would be great to have these outside (in an appropriate case) and then multiple sensors indoors in each room, then feed all of that to the dashboard 👍🏼

[@MichaelKlements]

Thank you! My weather station project uses a BME280 sensor, so you could combine the two to get what you're after. All the code on the InfluxDB and Grafana side is the same regardless of what sensor is used.

[@kelgar1]

@@MichaelKlements okay thanks for the reply

[@laszlobanyik2175]

Pls, help would be greatly appreciated. I don't understand, I created an account just like on the video, but I do not have the same dashboard and I do not have Arduino Client Library. The question is that something to do with my OS environment? Do I need to install something on the windows machine?

[@sussyimposter6994]

I have the same problem.... Have you got a solution yet?

[@DamianMyszko]

Okay, I had same problem, but found a solution. Pick different library and change ending of URL adres. If you picked python, the ending should look like this ..../new-user-setup/python. Now just change "python" to "Arduino" and you'll see a page for arduino setup. I have no idea why it's hidden but it works.

[@DavRH]

Very nice!

[@laidbackobs]

Great video! Quick question. If I want to view the Grafana dashboard from any website instead of on my localhost how can I do that?

[@MichaelKlements]

Do you mean embed the dashboard on another site? Or just access it remotely?

[@raphaelf.martins7455]

@@MichaelKlements He asked a good question. Please, I would also like to know how to remotely access Graphana dashboards through a website too, which I can access from anywhere. And thank you for ur detailed tutorial, it's all what I needed.

[@Armand79th]

The well-documented method would be to configure a reverse proxy.

[@baghdadiabdellatif1581]

Thank you

[@gregruthenium]

Hi. Can this be used with ESp8266? Also, can you direct to which library you used for MultiWifi.h

[@vishnudpillai]

so to store data, do we need a cloud provider's support like aws or azure? can we store data in influxDB? or can we setup only with esp32+influxDB+grafana?

[@MichaelKlements]

Both influxDB and Grafana have local or cloud options, so you can decide whether you want the data to be stored locally or in the cloud. You don't need to use aws or azure as well.

[@vishnudpillai]

@@MichaelKlements so which is more cost efficient for a new entrepreneur? using influXDB+grafana or aws_iot _core+aws_timestream+grafana ? which is best to scale the devices in future?

[@abhijithnscs1364]

Can i use multiple esp32 as input

[@bewingbewing]

Thanks for this. I'm a little unclear about where you install influx. You're apparently working on a Windows machine at install time (06:38), but toward the end of the video (14:26), it seems to be co-located with Grafana on the Raspberry Pi. I'd rather it all be in the Pi, not cluttering up my PC. BTW, I'm trying to set up a CO2 sensor to establish the effectivity of my Covid-inspired ventilation system, using an AirGradient setup. It works great but just displaying a value isn't enough; I need to see the effect, over time, of people in the room (or not) with and without ventilation.

[@MichaelKlements]

I run through the two options for each near the beginning, I'm not installing Influx locally, I'm using their cloud server in this tutorial. Yes, I use both a Windows PC and Raspberry Pi - I don't like working with Arduino programming on a Raspberry Pi so I do this from the Windows PC. It sounds like this sort of data logging setup would be perfect for what you're trying to achieve!

[@thewatchmaker.]

Isn't it possible to make influxdb/grafana take MY timestamp (e.g. a field named "timestamp") instead of what it creates itself when data is added to the database? Since I am collecting sensor data for about 10 minutes every 3 seconds and I need to send this data every 10 minutes to reduce the impact of Wi-Fi on the battery. Thanks!

[@MichaelKlements]

I don't see why you couldn't create a new field for your own timestamp just like any other data field. The issue you'll probably run into is that most standard visualisation tools are designs around their time series and a data field so you'd have to modify these to be across two fields rather.

[@Armand79th]

You're immediately correct... I don't know what "dah-ta" is. pLeAsE eXpLaIn. 😅

[@kulaniscap]

10/10🙂

[@Ashish-v1d8i]

Pls bro make a another short video for grafana with prothemus for air quality monitor no one else has made it ,so it will be of great use to many others like me since prothemus is very popular and effective 🙏🙏🙏🤝

[@srikumarc]

Can I use nodemcu instead of esp32?

[@MichaelKlements]

Yes you can use any microcontroller with WiFi

[@srikumarc]

Thanks Micheal for your excellent guide. Exactly what I was looking for. Great resource indeed.

[@srikumarc]

Micheal, I am trying to implement your code as it is but am running into errors. One specific error is "assert failed:XqueGenericSend queue.c820 (pxQueue). There are other lines in the serial monitor too.

[@srikumarc]

Micheal, disregard my earlier comment. I could resolve the issue. Everthing works ! perfect ! Thanks a lot for the video

[@srikumarc]

Michael, can you modify this video to include Mosquitto & Nodered (on the web) so that the data from ESP32 is passed through Nodered to InfluxDB using Mosquitto? . This will be wonderful because all elements of the stack will be on the web.

[@Ashish-v1d8i]

How can we do it with Prometheus pls help??pls

[@8m405]

Can graphana show it on Alexa echo show devices

[@MichaelKlements]

You can display a web page through the built in browser Silk, this would allow you to display a Grafana dashboard

[@zuwei8490]

谢谢. Thank you

[@scrody33]

I am trying to figure out how to use grafana on my ras pi locally with no internet connection. Any one know how to do that ?

[@generalknowledge9555]

ESP 32 with used to connect water flow sensor. This sensor value is stored in the InfluxDB database. while the below-shown Arduino code is removed we can get the correct accurate flow rate. But in this code is removed, then data can not be sent to the InfluxDB database. (water flow sensor is connected with an interrupt pin). if (!client.writePoint(sensor)) { Serial.print("InfluxDB write failed: "); Serial.println(client.getLastErrorMessage()); } Please give me the correct solution as soon as possible. It will be a big help for me.

[@MichaelKlements]

Have a look at my code that I've used for this example, you should be able to use the parts of the code that write to the database to get yours to work. The above is only a small portion of your code, there could be a number of issues in other areas.

[@kayezero703]

Nice

[@EvgeniX.]

8:13 is it me, or somebody just pwned his soundcard 4 a moment 🤔

[@Juliodonadello]

can you share the code?

[@MichaelKlements]

The code for the ESP32 is available on my blog post, linked in the video description

[@kishore3466]

How much ram need

[@MichaelKlements]

You can run this on a 2GB variant quite easily.

[@RonWolfHowl]

@@MichaelKlements Thank

[@The_Unobtainium]

cloud based services SucK!