• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

Simplest way to connect a hosted MYSQL database with an application on Android Studio

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Saloon Keeper
Posts: 24212
167
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Can you really tell me that we aren't dealing with suspicious baked goods? And then there is this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic