Remote database synchronization

61 views
Skip to first unread message

Scott Hunter

unread,
Dec 8, 2017, 3:30:05 PM12/8/17
to web2py-users
The technique put forth in Chapter 6 of the book says every record must "reference the UUID instead of the id", and the example redefines a field of db.dog from `Field('owner', db.person),` to Field('owner', length=64),``, adding `db.dog.owner.requires = IS_IN_DB(db,'person.uuid','%(name)s')`. 

Does this mean that things like SQLFORM.grid will not work for tables defined so?  What about tables like those part of `auth`?

If these parts of web2py will no longer work, is there a recommended way to synchronize remote databases that does not have these issues?

- Scott

Ari Lion BR Sp

unread,
Jan 13, 2020, 7:17:02 AM1/13/20
to web2py-users
Hi,

I have the same question.
Does web2py allows remote synchro?

Better if it was assynchronous. It means, every transaction wold be stored in a quewe and eventualy synchronized to remote.
Its it possible?


I need this feature.

regards,
Ari

Ari Lion BR Sp

unread,
Jan 14, 2020, 10:11:53 AM1/14/20
to web2py-users
Is it possible to catch each and every Dal Action and send it to a queue, in order to use the info to update another database (remote, which I want to update, assynchronously). 

Would I need to have a UUID to make it?


Best regaqrds
Ari
Reply all
Reply to author
Forward
0 new messages