Android communication and SQL database

Asked

Viewed 433 times

-1

I am developing a web application that aims to manage the stock, sales projections, etc. of a company. However, the sellers travel to carry out sales and have requested that they also make an application that communicates with the BD. For this, I need to be able to access the database of the web application through mobile at the same time as I deal with possible conflicts and temporarily save sales made in case there is no internet connection until it becomes available. Could someone indicate me a bibliography or some project that makes use of these resources?

android sql

  • You are developing the web or mobile application?:

  • Both. And I need you both to be able to communicate

  • Okay, sql tip is not database, see the tag. in the case of a web application I believe you are using some language for this PHP, C# something of the type, this part allowed you to make a connection to the database without problem. In the case of an application for Mobile you will have to use a database (SQLITE for ex;) on the device and through a web services synchronize your data with the database of your server.

  • Exactly, for the web application everything is already perfect. In PHP. But I’ve never worked with sqlite or use a web service as an intermediary. Do you know any book or website I can get to have a basis?

  • This is relative, depends on which language you work, which platform you will develop your application for. for android

1 answer

0


If you are using a web application, you can also create an HTML-Javascript application using Cordova for mobile.

You can use Localstorage or Sqlite to temporarily store the data. Check the connection from time to time or at the click of a button and synchronize the data.

To synchronize the data you can make a REST Webservice in your web application in addition to the visual part. With Webservice your mobile application will be able to communicate with the web application and access the database.

About the mobile application, this course: Course Phonegap/Apache Cordova

Browser other questions tagged android sql

You are not signed in. Login or sign up in order to post.