Reading data from mariadb sql database on Pi Zero W
7 views (last 30 days)
Show older comments
Okay, here it goes. I'm kinda nervous about asking for help. I have a Pi Zero that collects data from a esp32 and its BME680 air quality sensor. I went though a randomnerdtutorials tutorial (https://randomnerdtutorials.com/esp32-esp8266-raspberry-pi-lamp-server/) to set up the database on the Pi zero. After some editing to get the database to also record the air quality, it works in spite of being presented with a huge 'pink screen' saying there is some kind of error and also an option to ignore. I've been ignoring it and it's been recording samples every 3 seconds just fine for the past 6 days. (I don't think the pink error is my problem though).
So I've got this mass of data and after taking my second signals class, I would like to analyze the data and maybe display it. It looked like you need the 'database toolbox' to import from sql databases. So, I bought the toolbox and tried to use it. I doesn't seem to connect. I think it has to do with the driver. When I downloaded the MySql jconnect package and installed it, I thought it was going to work. It didn't. After multiple searches coming up empty (I think i just don't know how to describe my problem). I asked a couple people on Fiverr and one guy wants $60 just to show me how to connect the database. That's kinda high for something that could be covered by Mathworks support. Could someone point me in the right direction?
Here are some screenshots that might be helpful?
2 Comments
Natalia Diakova
on 18 Jun 2021
I understand that you are trying to use Database toolbox for connection to MariaDB. Since MariaDB is not in the list on https://www.mathworks.com/products/database/driver-installation.html please search for an appropriate JDBC driver from your database provider. I would suggest to use appropriate version of MariaDB Connector depending on Java version installed: https://mariadb.com/kb/en/about-mariadb-connector-j/
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!