On Feb 11, 2004, at 9:31 PM, Chris Nolan wrote:
>> Done intelligently, though, a Visual FoxPro app that uses VFP for
>> the GUI and business logic, and which uses MySQL as the back end, is
>> an incredibly powerful combination. I haven't done VFP development
>> that uses Xbase-type tables in years. You'll never hear about it from
>> Microsoft, though, because they'd rather sell you the full Visual
>> Studio package along with a bunch of Microsoft SQL Server licenses.
> Out of curiosity, have you ever migrated an application built using FP
> or VFP along with XBase-type tables to MySQL? There's a developer I
> know who would be interested in doing so and is looking for some
> advice if you're interested.
Yes, I've done several. The level of difficulty depends on how
well-designed the app was in the first place. If they used lots of the
ancient Xbase commands to access data, it will be pretty much a
complete re-write. However, if they used any sort of data classes, or
if they used buffered SQL views instead of direct tables access, it can
be converted without too much pain.
>> As an aside, the VFP community has never really integrated into
>> the whole Microsoft "way" of doing things. There is a large group of
>> developers who develop business apps for Windows desktops in VFP, and
>> use MySQL on Linux servers for the data. At a recent VFP conference,
>> a session on using MySQL was packed.
> There's been a few threads on this list in the past regarding the
> difficulty in matching VFP's native datastore performance when using
> MySQL (mainly due to VFP's Rushmore optimisation engine). Have you
> experienced this problem to any degree?
In many cases, there is nothing faster than the VFP data engine. It
never ceases to amaze me how wicked fast it is with properly designed
indexes. But there are few businesses today that can afford to keep
their data in a data store with no security. With Xbase tables, if you
have access to them at all, you have full access - there is no concept
of levels of security. None of my clients would dream of trading the
security and scalability of MySQL for a couple of milliseconds of