How to connect sqlite with an online database on Phonegap.

[Rana]

Hi, 

I made a database using phonegap[cordova 1.7.0] sqlite on IOS5. But instead of using this database, I want to switch it with one that I already have on an online server.

Is there some method to do that ? And would it be possible to update the online database using the functions provided at the storage api of cordova ?

Thanks a lot.

[jcesar]

You can't switch them, phonegap can only use local database, but you
can sync it with a online database, I think there are some plugins to
do this

[Mohit]

hi jcesar!
I'm having trouble understanding Phonegap... have downloaded anything
yet, so am new to creating any android app at all!
How can I create an sqlite database? Can I link external text files to
the database? Like a databse of cities with some info in a text file
named as per the city name?
I'm not an expert at coding, but know little bit of html, css, C++ and
flash action script... I mean I can understand coding, but cannot
create any code from scratch, can edit it if it's simple.
Any help would be great!

Thanks.
-Mohit.

[Rana]

Are you sure of that? So, even if I have a database script, I can't connect it with the phonegap ?

[jcesar]

With phonegap you can only use sqlite, and you create and access the
data with javascript.
There are some ways to load a sqlite dump file and work with it.
This 2 options are always with local data.

But you can't work with a server database (mysql, oracle) directly
from phonegap, to read server databases you need code on the server to
access the data and convert it to XML or JSON (or even TXT), and then
you can read it from your app with javascript and show it or store in
your local database.
I think there are plugins who take care of the data sync between the
local database and an online database