Create Mobile application using MySQL database

Question

I have create e-commerce website design using html, css, js and jQuery. I want to create functionality and also need to create Mobile application. I will use MySQL database. Kindly refer me which technology will suitable for mobile application and website?

Answer 1

It sounds like you want to have your mobile app depend on the same database that your e-commerce website does.

You don't want a direct connection between your mobile app and the MySQL database because this will be a big security risk. Whatever MySQL user account you connect with will be in a much more vulnerable place inside your app.
Instead, you should add API's as needed into your website that can be called from your mobile application for whatever the mobile app needs. Although the database schema could protect against many data integrity problems, your server-side programming for the website and these new API's can include tighter validation and limit access to the database to precisely what your mobile application needs to do and nothing more. You could also authenticate the mobile app's HTTP requests against a user of your ecommerce website.

Consider using a Progressive Web Application instead of a native mobile application if you want it for both IOS and Android. PWA is easier for web developers to work with than creating a completely native mobile application. A PWA can be accessed like a native application including when the mobile device has no network connection.

If you want persistent memory in your app for when it is offline, you could manage that with a SQLite database. SQLite is great for Android and I think IOS apps because it doesn't run a server. SQLite is also immediately available without any dependencies in Android and likely in IOS so it won't inflate your application download size.

If you need more information, please specify the following:
What mobile application operating system or operating systems are you developing your mobile application for? Android? IOS? Both?

Answer 2

For both