Re: [sqlite] How synchronize two databases

2014-03-10 Thread Simon Slavin
On 10 Mar 2014, at 12:58pm, Adam Devita wrote: > Are the databases designed to allow you to perform such an operation easily? > > On the databases I do it with, I have designed in enough extra data in the > db and logic in my code to handle sorting out what to do (which

Re: [sqlite] How synchronize two databases

2014-03-10 Thread Adam Devita
Are the databases designed to allow you to perform such an operation easily? On the databases I do it with, I have designed in enough extra data in the db and logic in my code to handle sorting out what to do (which record to use) if both databases have different data with the same primary key.

Re: [sqlite] How synchronize two databases

2014-03-10 Thread Simon Slavin
On 10 Mar 2014, at 12:58pm, Muhammad Bashir Al-Noimi wrote: > May I get some help from you guys? If you're asking how to synchronise two SQL databases which may have had different commands executed on them, then you should know that this is an unsolved problem which

Re: [sqlite] How synchronize two databases

2014-03-10 Thread Dominique Devienne
On Mon, Mar 10, 2014 at 1:58 PM, Muhammad Bashir Al-Noimi wrote: > On 03/07/2014 08:28 PM, Muhammad Bashir Al-Noimi wrote: >> I've two identical sqlite databases from structure side. I want to make a >> synchronization for the data but I need to keep some tables away from the

Re: [sqlite] How synchronize two databases

2014-03-10 Thread Muhammad Bashir Al-Noimi
On 03/07/2014 08:28 PM, Muhammad Bashir Al-Noimi wrote: Howdy, I've two identical sqlite databases from structure side. I want to make a synchronization for the data but I need to keep some tables away from the synchronization process. Is there any library can do that OR I've to do it

Re: [sqlite] How synchronize two databases

2014-03-10 Thread Klaas V
Muhammad wrote: | ... two identical sqlite databases from structure side. I want to make a synchronization for the data ... | Is there any library can do that OR I've to do it by myself? With an Apple you can do it within SQLite itself. http://www.sqlite.org/pragma.html#pragma_fullfsync To do

[sqlite] How synchronize two databases

2014-03-07 Thread Muhammad Bashir Al-Noimi
Howdy, I've two identical sqlite databases from structure side. I want to make a synchronization for the data but I need to keep some tables away from the synchronization process. Is there any library can do that OR I've to do it by myself? P.S. * I'm using C++/Wt * I read about