Brilliant, am using mural db...have found an inbuilt replication feature in mysql. So will try out the dam(..., migrate_enabled=False) feature for read only. And of course will use only select statements in the read only app.
Thanx On 13 Jan 2014 21:42, "Anthony" <[email protected]> wrote: > Also, set DAL(..., migrate_enabled=False) to prevent migrations. > > Anthony > > On Monday, January 13, 2014 2:35:40 PM UTC-5, Richard wrote: >> >> web2py readonly : >> You implement select only in your app function everywhere : >> >> db().select() >> >> SQLFORM(..., readonly=True) >> >> SQLFORM.grid(..., deletable=False, editable=False, create=Flase, >> details=True, selectable=True) >> >> Replication : >> An audit trail on your table that received the new data should be what >> you want? >> >> >> :)# >> >> Richard >> >> >> On Mon, Jan 13, 2014 at 7:12 AM, Teddy Nyambe <[email protected]>wrote: >> >>> I have two web2py apps, one updates database the other app should just >>> read. But i want the readonly app to have its own db to ready from with >>> selected tables from the main db. Whats the best way to replicate selected >>> tables and monitor changes to main db. Secondly what would be the >>> configuration of web2py operate in readonly mode? >>> >>> -- >>> ............................................................ >>> ........................... >>> Teddy Lubasi Nyambe >>> Opensource Zambia >>> Lusaka, ZAMBIA >>> >>> Cell: +260 97 7760473 >>> website: http://www.opensource.org.zm >>> >>> ~/ >>> Human Knowledge belongs to the world! - AntiTrust >>> >>> Man is a tool-using animal. Without tools he is nothing, with tools he >>> is all - Thomas Carlyle 1795-1881 >>> >>> /~ >>> >>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "web2py-users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
