the suggestions above all leverage a Linux based extension to the board so the Arduino (ATMEGA328/2560 etc) is not managing the DB, it is simply sending commands to the Linux based system to do it remotely
remotely being maybe an inch away to over the internet
What you can do is have the data saved to a file on the SD card and have a PC/PI poll the Arduino for the data on a scheduled basis and load it into a database or even have the Arduino send it via wireless / ethernet / serial out to a listening device (Web server, PC, PI, Other) where it can be processed.
at the end of the day, ask yourself, is the database actually necessary, what is your final output for a user, what are you trying to do with he data ?
You simply have a separation between data collection and subsequent processing / viewing
the suggestions above all leverage a Linux based extension to the board so the Arduino (ATMEGA328/2560 etc) is not managing the DB, it is simply sending commands to the Linux based system to do it remotely
remotely being maybe an inch away to over the internet
What you can do is have the data saved to a file on the SD card and have a PC/PI poll the Arduino for the data on a scheduled basis and load it into a database or even have the Arduino send it via wireless / ethernet / serial out to a listening device (Web server, PC, PI, Other) where it can be processed.
at the end of the day, ask yourself, is the database actually necessary, what is your final output for a user, what are you trying to do with he data ?
You simply have a separation between data collection and subsequent processing / viewing
