sql - Android client/server application? -


i supervising project done 2 students involves retrieving information server , displaying on android phone. students have never learnt networking, sql or java before (although know how program) , learning how setup socketed connections between phone , sample server app gave them.

they need setup simple sql database on server on campus network , able communicate , pull information database , display on phone.

my current plan receive xml objects generated on server side sent stream through socket connection. able generate dom using javax.xml classes , display see fit on phone itself.

is valid method? kind of problems can expect experience following technique? there another/better/correct way (without using php or webservices)? system multiple users there significant performance issue proposed method?

note 1: phone never sends request other single multicharacter identifier. server interprets identifier , returns information preprogrammed queries , places xml format.

webservices sound correct approach this, since not want directly allow communication database on internet.

the book "unlocking android" manning publications, isbn 978-1-933988-67-2 has chapter (6) dedicated "networking , web services".

ah , there 1 , nice video presentation regarding android , restful webservices google io.

couchbase, although nosql movement have nice summary well.

you use json instead of xml, easier parse , work (feels more lightweight me @ least).

sorry, forgot answer search of problems:

  • activity freezing upon freezing requests: use additional threads requests
  • how handle high latency
  • handle offline behaviour

Comments

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

fortran - Function return type mismatch -

queue - mq_receive: message too long -