Topic
3 replies Latest Post - ‏2011-10-24T14:32:48Z by SystemAdmin
SebastjanStucl
SebastjanStucl
1 Post
ACCEPTED ANSWER

Pinned topic Database

‏2011-10-11T06:59:28Z |
Hello,
as new developer in mobile apps I have question on database here in Android case. What is the architecture here for select/update database tables in Android apps is there internal embedded db (sqlite) or the idea here is to use wasp db? Or we can only store data in *.xml here?
Thanks Sebastjan Stucl
Updated on 2011-10-24T14:32:48Z at 2011-10-24T14:32:48Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    59 Posts
    ACCEPTED ANSWER

    Re: Database

    ‏2011-10-11T13:54:13Z  in response to SebastjanStucl
    Hi Sebastjan,
    I think you'll find what you're looking for at http://developer.android.com/guide/topics/data/data-storage.html. Android provides full support for SQLite databases.
    Updated on 2011-10-11T13:54:13Z at 2011-10-11T13:54:13Z by SystemAdmin
  • BillNagy
    BillNagy
    2 Posts
    ACCEPTED ANSWER

    Re: Database

    ‏2011-10-11T15:32:19Z  in response to SebastjanStucl
    Hi Sebastjan,

    That really depends upon what your application is trying to accomplish -- there is no 'right' answer. If you're writing a native application, you can certain use the native APIs to manage the sqlite DB (http://developer.android.com/reference/android/database/sqlite/package-summary.html) If you're creating hybrid applications you can make use of the HTML5 and PhoneGap support for Web SQL (http://dev.w3.org/html5/webdatabase/), although as that page points out, the direction for support is uncertain at this moment. In certain situations it may also be appropriate to delegate all DB activity to
    the backend. It all depends upon the characteristics that you're trying to achieve.

    -Bill
    • SystemAdmin
      SystemAdmin
      59 Posts
      ACCEPTED ANSWER

      Re: Database

      ‏2011-10-24T14:32:48Z  in response to BillNagy
      In case of sensitive data, it is probably best to not store it locally. However, the problem is determining a standard authentication and authorization scheme that will work across all OS/phones. I am considering using Phonegap's childbrowser functionality to open up the Siteminder login page and start the session on the server. We have single-sign on enabled and most of our web services are security enabled. We also have DataPowe which is another possible option to get user credentials from the phone. Has anybody tried this before - accessing a secured web service or any other http resource from a hybrid widget?