On Sat, Mar 7, 2009 at 9:38 AM, MB Software Solutions General Account <[email protected]> wrote: > Ed Leafe wrote: >> On Mar 7, 2009, at 8:56 AM, MB Software Solutions General Account wrote: >> >>> No...sorry. Where's your presentation? A PyCon or something like >>> that? >> >> Yep - http://us.pycon.org/2009/conference/schedule/event/58/ >> > > > Awesome! What your session says sounds like what I've been doing with > VFP9/MySQL for the past 4 years...creating a VFP9 rich/smart client app > that uses a web database. One of my clients is having me retool an app > from 2004 to use this approach. I wouldn't design apps any other way > anymore. While VFP backends can kick ass, MySQL is great for my apps > and it has the added benefit of running locally (workstation or LAN) > (like VFP) but also over the web. I've seen some ideas that suggest > that's becoming more possible for VFP but I like the true client/server > approach moreso. > > I'd love to retool FabMate in this fashion (as it still uses the VFP > backend) but that's just such an enormous project that I unfortunately > don't have to time to do right now. I'm scrambling to pick up any side > projects that will pay some bills! (Man, this debt stuff really sucks!) > > Of course the benefit of Dabo is that it would run on non-Windows > platforms too...and with the same code base, iirc. (Yeah, Steve...they > pay me to throw such statements out there!!!!) <gd&r> --------------------------------------------
Have you considered wrapping the DB access into a series of web service calls? You would get better security on your data for all of your clients. You do keep a single db for all the data correct? Or do you generate a new db for each client? Benefits are that you could present a service to do data manipulation on the server/database instead of bringing that data local and then passing it back for reseting to a new status. I think of rolling status in a job from one phase to another. This is all part of working with a C/S mindset where you are disconnected to your data. -- Stephen Russell Sr. Production Systems Programmer Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

