Designing a new app and I’d like to know what is best method for accessing databases on cloud server. The back end will most likely be AWS RDS Aurora MySQL (either server or serverless - but it doesn’t really matter what back end I use). I see two methods:
- The mobile device would directly issue SQL commands to the server from the mobile app. It would appear we would need an ODBC compliant library to run on the mobile app if using AWS RDS Server Database. If using the AWS RDS Serverless Database, then accessing the data directly from the mobile app would be some HTTPS calls using the AWS Data API.
Suggestions of a different alternative or services welcome.