>From what you explained it sounds like you just want: 1) Independent database server 2) Web2py to handle requests via a service 3) Javascript to connect to a web2py service using ajax and or sockets
If that is what you are asking it web2py can handle that simply if that is not what you are suggesting then I am not sure, and need more details. On Sat, Apr 21, 2012 at 11:02 AM, Carlos <carlosgali...@gmail.com> wrote: > Hi, > > My environment: latest web2py trunk, ubuntu, postgresql, nginx, uwsgi. > > Following are some requirements for my new potential project (where SYS is > my web2py system, and CLIENT and SERVER are two completely different / > independent non-web2py remote servers): > > (for each web services call ...) > > + CLIENT initiates the communication to SYS via web services to request > some data. > > + during this same connection (in real time), SYS connects to the remote > SERVER to execute some SQL commands (in a MySQL database) and get the > requested data. > > + finally SYS responds to CLIENT with the data. > > In summary, SYS will act as the middle-man between CLIENT and SERVER. > > Questions: > > Is this doable?, should I be aware of any issues that might arise?, > concurrency, others?. > > Do you recommend other ways to accomplish this?. > > Do you know how can my web2py server connect remotely to a non-web2py > server to execute some SQL commands?. > > Will SYS have enough time for this process to complete on each web service > call?. > > I would just like to know your general (or specific) recommendations about > this scenario. > > Thanks!, > > Carlos > > -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.fittraineronline.com - Fitness Personal Trainers Online http://www.warplydesigned.com