Objective : Control an Arduino with an Android App and display pin info on the App w/ SQLite3 (all connected wirelessly)
(I want complete disassociation between all parts; meaning, I don't want any direct connections between the Board, Database, and App. (The board has its own control box, the database has a desktop, and the app is hosted on an Android phone))
To start, I don't know if this ALL is possible.
I have an Arduino MKR 1010 connected to a machine. I know how to display specific information on the Android app from the SQLite database, but I don't know how to put the Arduino's pin information into the SQLite database in the first place... (to then be read and displayed by the app)
But my biggest problem is being able to control the Arduino with the Android app (turning several processes off/on). Is there any way I could connect my Arduino MKR (possibly with the SQLite Database) to control it from the app? I've seen the posts talking about controlling Arduinos with Bluetooth, but could the Arduino be controlled by the "custom-made-app" over the internet (from anywhere with internet access?)
If I'm missing anything other boards, a separate (Unbuntu) server that needs to control anything, or anything other ideas you might have, please let me know. (I also read about MySQL? Would that be easier than using SQLite in this situation?)
And if you need more information, please ask.
(Even if you only know a small portion of the overall project, still leave a comment)