Hi Carlos, Thanks for clarifying.
Do you know how can my web2py server connect remotely to a non-web2py server to execute some SQL commands? I think you need to think about this at a python level more then a web2py level. web2py uses python which means yes you can connect to whatever non-web2py server that handles network protocols in one way or another. Do you want to basically get a request from the client and pass that request to a server/mysql which will determine what to do with the request, return you data and that data is returned back to the client? How is the non-web2py server listening for connections? Does it already have an api programmed or is that also your task? On Sat, Apr 21, 2012 at 11:20 AM, Carlos <[email protected]> wrote: > Hi Bruce, > > Thanks, but that's not the case. > > My web2py system is already a complete cloud SaaS server, with a single > postgresql db, multi-tenancy, multi-apps, single-sign-on, etc. > > And one potential customer (tenant), who will use all the other apps in > the cloud, requires this new scenario/app where my system handles web > services requests from an external non-web2py system (named CLIENT) and > collects the respective data from another external non-web2py system (named > SERVER), therefore acting as a middle-server (or so). > > All 3 systems (my own cloud SaaS SYS, and CLIENT, and SERVER) are > completely independent (with no relation whatsoever). > > Thanks, > > Carlos > > > On Saturday, April 21, 2012 1:08:55 PM UTC-5, Bruce Wade wrote: >> >> 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 <[email protected]> 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://ca.linkedin.com/in/brucelwade> >> http://www.wadecybertech.com >> http://www.fittraineronline.**com <http://www.fittraineronline.com> - >> Fitness Personal Trainers Online >> http://www.warplydesigned.com >> >> -- -- 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
