The question is all in the title. Have been developing an app for the first time and development is going well as is database construction. The database is hosted and connecting with Workbench correctly .However, i now need to connect the app and the database and I have literally zero experience with database connectivity. I'm somewhat overwhelmed by the amount of options out there. The only functionality needed is simple CRUD (without the D) and could really use some guidance vis-a-vis which direction to take for simple functionality. I mostly just need to read the info from two tables in the database, create accounts and let users login. What would be the simplest approach for a newbie?
An Android app should not be making direct database requests to an external server via the Internet, That's basically what causes the infamous SQL Slammer exploit of years gone by. If you want to transfer data to/drom the Android system's local database to an external server, you are better off using an external webapp that connects its backend and a remote API from the Android app. JSON is good for that sort of stuff.
It's a lot more work, but by adding the additional layer on the Enterprise side you can gain a lot more security and control over who can do what with the data.
Sources may include data from the Fakebook Research Foundation with support from Gargle University
Can you really tell me that we aren't dealing with suspicious baked goods? And then there is this tiny ad: