To whom it may concern,
First off, thank you to the Arduino community as I've recently picked up this new great hobby. My background is in open source database technology and I'd like to use
Chuck Bells mysql connector in my sketches to interface with a database server.
A special thank you to Mr Bell as well, the tutorial is here:
However some of the examples seem to be missing the mysql.h file
fatal error: mysql.h: No such file or directory
#include <mysql.h>
(Notes)
N1) I am running the arduino 1.8.5 IDE on a MAC 10.11.6 El Capitan
N2) I have a basic "101 Starter Kit Series" Arduino Basics Tutorials" set
N3) The card inside reads "OSEPP UNO R3 Plus"
N4) Successful with accompanying tutorials
(Question)
Q1) Do I need an additional mysql connector package in my sketch?
https://dev.mysql.com/downloads/connector/c/6.0.html
Q2) Is it possible to use the MariaDB equivalent?
Q3) Can I use a c++ connector? rather than a c connector?
Q4) In the case where I would need to download an additional connector package, what are the steps to "cleanse" the library so the IDE can recognize them? So far I have the following, please confirm if these are true:
Q4a) Libraries that use special characters or numbers cannot be used
Q4b) Library files (.h and .c) need to reside in a "src" subfolder for each library
Q4c) Are there any special filesystem permissions that could prevent the IDE from seeing these files when I compile?
Q5) Do I want to download the source code for the connector or a binary for a specific platform? (such as my Mac?)
Q6) According to the spec in the link here, I see a few different places where I can add libraries (at the "IDE level" at the "sketch level" and I believe there is yet another one the the "users home level" on the filesystem. What are some best practices for managing these libraries among various projects?
Looking forward to my next eureka moment with Arduino!
Thank you all in advance!
kurtrocks