On Wed, April 29, 2009 5:52 pm, Stephen Russell wrote: > On Wed, Apr 29, 2009 at 3:20 PM, MB Software Solutions General Account > >> The VFP9-MySQL solutions I've got out there now working will not be >> affected, imo, by the acquisition by Oracle. They cannot, imo, put >> anything into place that would ill-affect my existing solutions. I may >> not be able to upgrade for whatever personal/business reason moving >> forward, but what works today should still work tomorrow and the day >> after that, etc etc, imo. Right? >> >> Because I've designed with the n-tier approach, I'm going to take one >> of my solutions and see if I can get the PostgreSQL backend solution as >> well. The only place I'd need to change things would be where there's >> MySQL-specific SQL that doesn't work the same in PostgreSQL. >> > -------------------------- > > > Are you currently using anything of MySQL outside of it as a storage > container? Or have you put in logic that runs in the database that has > nothing to do with VFP? These would be triggers, Stored Procedures, UDFs, > customer data types.
I'm using the database merely as a storage container (for 99% of it anyway...if there's an SPs, there's just a few that could be rewritten). I like to use the backend as a big storage box, and prefer to put the biz/data logic in the app. If there's a performance issue, then I write some stored procs, but that hasn't been needing for my volume of data. Because of this, it should be easy for me to switch backends if needed. > > If the answer is no then you can switch to any one of free open source > ones. Picking PostgreSQL for a reason is what you should be doing. > Otherwise why switch, and go into all of that change process for your > code base? > > Second part of the puzzle is where is this MySQL running? On your > hardware where you have 100% control on version etc, or at a hosted site > where they do it all for you, and you are at their whim in an upgrade? For some, it's running on their server inside their office. For others, it's running on the web but no upgrades would be done without my knowledge, so we're safe. Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
