Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/03/12 10:55, Rose, John B wrote: > In this particular example, a particular researcher would be creating > the initial version of the database on their own computer, but once > they got out in the field they may update the copy they have on

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Simon Slavin
On 2 Mar 2012, at 7:40pm, "Rose, John B" wrote: >> So once again, how would you answer Roger's question ? Suppose changes were >> made on both computers at the same time. How would you reconcile the two >> copies of the databases ? If you want to use the copy from the

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Rose, John B
> So once again, how would you answer Roger's question ? Suppose changes were > made on both computers at the same time. How would you reconcile the two > copies of the databases ? If you want to use the copy from the computer to > /update/ the copy in the mobile device then the mobile device

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Simon Slavin
On 2 Mar 2012, at 6:55pm, "Rose, John B" wrote: > Thanks for the very thorough reply. > >> Android is a red herring in this and your approach is not a good one. How >> would you do this using two different regular computers? How would you >> deal with changes being made on

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Rose, John B
Thanks for the very thorough reply. > Android is a red herring in this and your approach is not a good one. How > would you do this using two different regular computers? How would you > deal with changes being made on both machines at the same time? How would > you copy databases ensuring

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Simon Slavin
On 2 Mar 2012, at 5:58pm, Roger Binns wrote: > On 02/03/12 09:40, Simon Slavin wrote: >> What ContentProvider is, as far as I can work out, is a way of >> accessing a SQLite database file in a form convenient for Android >> apps. > > No, it is a way for Android app

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/03/12 09:40, Simon Slavin wrote: > What ContentProvider is, as far as I can work out, is a way of > accessing a SQLite database file in a form convenient for Android > apps. No, it is a way for Android app components to expose and manipulate

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [I reordered your message in my response] On 02/03/12 08:59, Rose, John B wrote: > 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. Yes, Android

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Simon Slavin
On 2 Mar 2012, at 4:59pm, "Rose, John B" wrote: > 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

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Rose, John B
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

Re: [sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Pavel Ivanov
> 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)

[sqlite] Interchangeably using SQLite .db file between desktop and android mobile device

2012-03-02 Thread Rose, John B
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