On Monday, January 31, 2011 5:13:19 AM UTC-5, vortex wrote: > > Let me rephrase my question: > > I need to implement a inventory management system with web2py. Is it > practical to have a local web2py database for each store which allows > users to read and write and then synchronize all the different > databases across the network?
web2py can handle connections to multiple databases (including master-slave replication setups) -- see http://web2py.com/book/default/chapter/11#Using-Replicated-Databases. If necessary, it can connect to a given database conditionally depending on information in the HTTP request. I suppose you would have to configure the actual replication scheme at the database level, though (i.e., web2py would read/write to the appropriate store database, but then the database would have to manage the replication activity) -- here's some discussion of that for PostgreSQL: http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling Also, have you seen this: https://github.com/jlew/Web2Py-Inventory Best, Anthony
