Well, there will be no write operations, only read instructions. The database will be defined by the programmer (in this case me).
User will enter a number, the program will define how big the number is, for example:
- between 1 and 5 = low
- between 6 and 10 = normal
- between 11 and 15 = high
Based on this rule arduino must go to the database and pull all the information for the given value.
The amount of data will be:
- table A with about 5 rows and 4 columns: 3 numeric integers, 1 varchar
- table B with about 100 rows and 2 columns: 1 numeric integer, 1 varchar
- table C with about 100 rows and 2 columns: 1 numeric integer, 1 varchar (very long, size of a recipe aprox)
Table A has some user information.
Table B has the title name of a recipe, for example: pancakes
Table C has (for example) the detailed instructions on how to make pancakes
As you can see the data must be persistant and available every time the device it is turned on.
Sorry, I'm very new at this hehe,