Re: [sqlite] Features of SQLite question

2012-06-12 Thread Black, Michael (IS)
Sent: Monday, June 11, 2012 5:31 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Features of SQLite question On 11 Jun 2012, at 11:11pm, "Black, Michael (IS)" <michael.bla...@ngc.com> wrote: > Isn't it true that semi-accurate (sub-second) time-tagge

Re: [sqlite] Features of SQLite question

2012-06-11 Thread Jay A. Kreibich
On Mon, Jun 11, 2012 at 10:11:45PM +, Black, Michael (IS) scratched on the wall: > Answer: The most recent one. > > Isn't it true that semi-accurate (sub-second) time-tagged transactions > will generally keep 2 databases in sync? "Generally", perhaps, but not always. > I've done that

Re: [sqlite] Features of SQLite question

2012-06-11 Thread Simon Slavin
On 12 Jun 2012, at 12:06am, Brent Shifley wrote: > So, if I understand things correctly, if I created said app, with associated > database, if I had identical databases on both iPads, and tracked all > transactions and used them to modify a third copy of the database,

Re: [sqlite] Features of SQLite question

2012-06-11 Thread Brent Shifley
Wow! I feel I just tried to eat an elephant. ;) What I am thinking of doing is creating a specialized app for handling contacts related to a business that I own. I am formerly a software tester that was exposed to a lot of different things, including a little sql. Now, back to the

Re: [sqlite] Features of SQLite question

2012-06-11 Thread Simon Slavin
On 11 Jun 2012, at 11:11pm, "Black, Michael (IS)" wrote: > Isn't it true that semi-accurate (sub-second) time-tagged transactions will > generally keep 2 databases in sync? > > I've done that before with considerable success. You don't sync the > fields...you sync

Re: [sqlite] Features of SQLite question

2012-06-11 Thread Black, Michael (IS)
...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Monday, June 11, 2012 5:03 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Features of SQLite question On 11 Jun 2012, at 10:14pm, Brent Shifley <brentshif...@yahoo.com>

Re: [sqlite] Features of SQLite question

2012-06-11 Thread Simon Slavin
On 11 Jun 2012, at 10:14pm, Brent Shifley wrote: > I was wondering. If you had a SQLite database on two different iPads, then > had different changes applied to each database, is it possible to sync the > changes to each database? Suppose you have a list of contacts

Re: [sqlite] Features of SQLite question

2012-06-11 Thread Jay A. Kreibich
On Mon, Jun 11, 2012 at 04:14:59PM -0500, Brent Shifley scratched on the wall: > I was wondering. If you had a SQLite database on two different iPads, > then had different changes applied to each database, is it possible to > sync the changes to each database? Sure, why not? Does SQLite

[sqlite] Features of SQLite question

2012-06-11 Thread Brent Shifley
I was wondering. If you had a SQLite database on two different iPads, then had different changes applied to each database, is it possible to sync the changes to each database? Sent from my iPad ___ sqlite-users mailing list sqlite-users@sqlite.org