Connecting Android to MySQL – Php or Servlet?

综合编程 2017-12-30

This is not a codefix question but please help me where possible.

I am developing an application which needs to store information in a database. This information needs to be stored off-device for security reasons (patient data).

I have explored using PHP as a bridge to the external MySQL database hosted locally via WAMP, however I have recently been informed of servlets and also of SQLite.

As I am learning these technologies under a limited time frame I need to know which to invest my time into to get the job done as easily as possible. I have no experience with any query language but I did get a simple login screen to work on Android using PHP and MySQL on WAMP using HTTP post/fetch within android.

Also, is it possible to store the information in SQLite within android and write that data to a server, which can then load the SQLite database again on re-launch?

Many thanks for your time!

From our expericence these kind of services need to work offline if possible. Both 3g and especially wifi has been unreliable in several occasions.

You do good if you save the data locally in e.g. sqlite database but be warned the data can get wiped on OS update or software update.

Also try to write your changes/additions in batches and servr updater can send all the batches that are not yet on the server. this way it's more reliable if you miss updates.

These kind of interfaces to another systems take a lot of time in testing. Consider getting a new timeframe in advance.

Hello, buddy!

责编内容by:Hello, buddy! (源链)。感谢您的支持!


阿里云内网,利用mysql-proxy访问腾讯云数据库... 看到标题就知道怎么处理了。 1、在有公网IP的那台服务器上装上mysql-proxy (debian 自带的mysql-proxy好象有问题,还是自己配置比较好) 直接就用网上的配置即可...
PHP MySQL – Do I do something wrong&ques... For two hours now, I'm trying to insert a value into a table. I don't get any error and I can't find...
Strange behavior when using varchar in decimal I have table with a column mrr varchar(64) . I can't change the type of the column. This sim...
MySQL Enterprise Monitor 3.4.3 GA has been release... We are pleased to announce that MySQL Enterprise Monitor 3.4.3 is now available for download on the ...
mysql优化 上篇文章是关于mysql优化的,那个内容是我大学的时候学习的笔记,最近学习发现一些比较好的内容,在这里分享给大家。 版权源于网上。 工作中使用最多的就是MySQL, 但是mysql的优化也就是通过建...