Someone else in our group came across something called "ContentProvider" and is under the impression we have to do some file conversion of the .db file use ContenProvider somehow if we want to use the original .db file created on our desktop. Frankly we are not understanding it.
I had assumed we just moved the .db file back and forth between our desktop and Android and the simplicity is part of the "coolness" of SQLite. A step-by-step example taking a .db file created with some data on a desktop and putting it on Android and using/adding data to it there, then putting it back on the desktop with the new data while it was on Android would be good to see. Thanks John On 3/2/12 11:38 AM, "Pavel Ivanov" <paiva...@gmail.com> wrote: >> Is there an example(s?) of a step-by-step for moving/using an SQLite .db file >> interchangeably between a desktop and an Android mobile device? > > What kind of example you want? SQLite's database format is the same > for any platform. So just copy the file (when it's not open by any > application) and you are done. > > > Pavel > > > On Fri, Mar 2, 2012 at 11:34 AM, Rose, John B <jbr...@utk.edu> wrote: >> Hello >> >> We are new to SQLite and are working on an intro tutorial for people here. >> >> We would like to create an example where we create an SQLite database on our >> desktop and access it there via command line, GUI like Navicon, and a web >> based application, then upload the .db file to our Android mobile device and >> users can use an database there via an interface we create. Ideally they >> could add or edit values in the database >> On the Android device. >> >> Is there an example(s?) of a step-by-step for moving/using an SQLite .db file >> interchangeably between a desktop and an Android mobile device? >> >> Thanks >> John >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users