Re: [sqlite] Syncing databases on different servers

2011-06-01 Thread Alexey Pechnikov
See undo extension: http://sqlite.mobigroup.ru/artifact/265e408b4352d66cfc79a9990cb2c22fb390d3b6 http://sqlite.mobigroup.ru/artifact/2250bbbc83f80eff73ce003ab7a30293c688ae9b And history extension: http://sqlite.mobigroup.ru/artifact/0b8eaab9564575fcf37f459bb85c501f65089b31 http://sqlite.mobigroup.

Re: [sqlite] Syncing databases on different servers

2011-06-01 Thread Gary_Gabriel
Hi Ian, > I do not need instant syncing of SQLite databases, however I do have > a table stored on server X which I would like to gradually send > changes of to various other servers connected by TCP. > > In the first instance, I'd be quite happy to send rows with ids which > do not exist in t

Re: [sqlite] Syncing databases on different servers

2011-06-01 Thread Alexey Pechnikov
See http://sqlite.mobigroup.ru/wiki?name=sqlite3-rdiff 2011/6/1 Ian Hardingham : > Hey guys, > > First of all, I'm aware that SQLite is not a good choice for concurrency > over several machines. > > I do not need instant syncing of SQLite databases, however I do have a > table stored on server X

Re: [sqlite] Syncing databases on different servers

2011-06-01 Thread Igor Tandetnik
Ian Hardingham wrote: > I do not need instant syncing of SQLite databases, however I do have a > table stored on server X which I would like to gradually send changes of > to various other servers connected by TCP. Perhaps you could use something like rsync to synchronize at the file level. -- I

[sqlite] Syncing databases on different servers

2011-06-01 Thread Ian Hardingham
Hey guys, First of all, I'm aware that SQLite is not a good choice for concurrency over several machines. I do not need instant syncing of SQLite databases, however I do have a table stored on server X which I would like to gradually send changes of to various other servers connected by TCP.