FoxPro users petition to keep database language alive

Fans say open-sourcing could keep venerable tool viable; Microsoft unconvinced

Despite a concerted online effort by devoted Visual FoxPro developers, Microsoft Corp. said late last week that it won’t change its plan to halt work on the venerable database programming tool.

Two Spanish developers have set up a wiki-based Web site called MasFoxPro (More FoxPro) calling for Microsoft to continue developing the database and development tool after this summer’s release of Service Pack 2 for Visual FoxPro 9. Microsoft announced that it would terminate development of the 23-year-old product, which it acquired a decade and a half ago, at its Most Valuable Professional (MVP) Summit in Seattle last month.

In a statement e-mailed to Computerworld on Friday, Jay Roxe, Microsoft’s group product manager for Visual Studio, said that the decision to halt development of FoxPro was considered "very carefully" and remains the only realistic scenario.

"For Microsoft to continue to evolve the FoxPro base, we would need to look at creating a 64-bit development environment, and that would involve an almost complete rewrite of the core product," Roxe said. "As far as forming a partnership with a third party is concerned, we’ve heard from a number of large FoxPro customers that this would make it impossible for them to continue to use FoxPro since it would no longer be from an approved vendor. We felt that putting the environment into open source on CodePlex [Microsoft’s open-source site], which balances the needs of both the community and the large customers, was the best path forward."

Disagreeing devotees

Supporters of the petition, which as of Sunday had garnered more than 2,400 signatures, take the opposite view. Even if Microsoft keeps its promise to support FoxPro users until 2015, halting development will make it impossible for FoxPro developers to hawk their wares. And, supporters say, why give up on a tool that, despite its age, remains more powerful and easier to use in many respects than Microsoft’s favored developer platform, .Net -- especially when the investment for Microsoft would be minimal?

"There is still a lot of life left in FoxPro," said Colin Keeler, director of financial systems for the South Dakota state government and an officer in the Virtual FoxPro User Group. South Dakota has used Visual FoxPro since the early 1990s to create its annual state budget. While the state now uses SQL Server for actual data storage, it still uses FoxPro as its chief front-end development platform.

"We use SQL Server for the heavy lifting but prefer FoxPro for the fine-tuning," he said.

FoxPro is a "kickass product," said Alec Gagne, president of CrimeStar Inc.., a small San Jose, Calif.-based vendor that has embedded FoxPro in its namesake police department management software for nearly a decade. "A lot of things that are now finding their way into .Net for handing data, frankly, I saw a long time ago in FoxPro," he said. "While .Net is getting significantly better at handling data in its development tools, it’s just not there yet."

Is open source the answer?

Others are more sanguine, saying that Microsoft’s open-sourcing of FoxPro could give the resilient product its best chance for long-term survival.

"They said PowerBuilder was going to kill FoxBase back in 1994. Nobody uses PowerBuilder anymore," said Andrew MacNeill, a Canadian FoxPro developer and evangelist. "Then they said Paradox was going to be the next big thing. But FoxPro has always been able to evolve. So this is not a death announcement by any stretch."

Though unwelcome, Microsoft’s announcement was no surprise to many FoxPro users, who said the software has been under the ax almost from the day it was acquired by Microsoft in 1992.

Originally called FoxBase when it was released by Toledo, Ohio-based Fox Software in 1984, the software started off as a clone of the dominant database of the era, dBase II.

Microsoft bought FoxBase hoping to gain a strong immediate foothold in that then-burgeoning market. It did. By 1995, DevCon 6, the FoxPro-centric trade show put on by San Diego-based trade publisher Advisor Media Inc., drew up to 3,000 attendees who came to gawk at FoxPro 3.0, the first "Visual" version put out by Microsoft.

"FoxPro bought me everything that I’ve got: my cars, my house, my dogs," said Kevin Cully, an Atlanta developer who says he has relied on the software since the early 1990s. 

Early on, Visual FoxPro nailed several key technical features. It had a mature object-oriented environment years before Java or Visual Basic 6 arrived. It can run as fast as in-memory databases for certain applications, MacNeill said.

Finally, its chameleon-like ability to serve both as a data store and as a data-minded development environment has helped it evolve for today’s Web environments.

"Now it’s a great middleware piece you can team with SQL Server in a multi-tier architecture," MacNeill said.

The perils of popularity

 As dBase imploded due to mismanagement by successive owners, FoxPro’s original raison d’etre became less important, especially as Microsoft eyed the lucrative enterprise market.

But FoxPro’s use of the open .dbf file format made it impossible for Microsoft to raise prices for the software. Even today, Visual FoxPro 9.0 lists for just $649. For no additional fee, developers can embed FoxPro in an unlimited number of their applications.

FoxPro, though wildly popular, became a burden and an opportunity cost for Microsoft. "Every time Microsoft sold a copy of FoxPro, I think Bill Gates thought about all the money they were losing from not being able to sell a copy of SQL Server," Cully said.

Microsoft began plundering FoxPro of both its technology and its developers, incorporating them into more favored products such as Access, SQL Server, Visual Basic 6, and now .Net. Calvin Hsia, Microsoft’s lead developer for Visual FoxPro, confirmed that "a lot of what’s in SQL Server came from FoxPro technology."

FoxPro also has technical shortcomings. Because of the .dbf format, it is more vulnerable to data corruption than true relational databases. And "from a development perspective, FoxPro-created apps don’t look as up-to-date [as others] right now," MacNeill said.

Overseas, a rock star

Interest in FoxPro, especially in the U.S., began to wane. DevCon last drew more than 1,000 attendees in 2000. Last year’s DevCon, now combined with other technologies, drew about 100 attendees to the FoxPro segment.

But overseas, FoxPro remains a rock star in places like China and Eastern Europe. A 2005 presentation by Ken Levy, then Microsoft’s Visual FoxPro product manger, in Sofia, Bulgaria, reportedly drew 1,000 attendees.

"The way the French are about fashion, the Americans are about technology," Cully said. "We are always throwing out what we’ve got for the latest thing. But in other countries, there are still lots of FoxPro users because they are focused on getting the job done in a cost-effective way, with little regard for the buzzword of the day."

And interest in FoxPro may not be as low domestically as trade-show attendance figures indicate. For one, most active FoxPro developers are independent consultants who are more likely to participate in online forums than foot their own travel bill to a pricey conference.

The Virtual FoxPro User Grouphas 14,000 active members, Keeler said. And according to a popular ranking of programming languages byTiobe Software BV, FoxPro was ranked the 13th most-popular language as recently as last July, ahead of more modern languages such Visual Basic and ColdFusion.

You're only as young as your fans feel

Despite FoxPro’s history, it doesn’t face the problem of an aging user base, a problem mainframe computing shops are grappling with. Cully and MacNeill are both in their late 30s. MacNeill’s partner in his consulting firm, who is also heavily involved in FoxPro, is just 27.

"Most of VFUG’s U.S. members are in their late 30s or early 40s," Keeler said. And because of Microsoft’s long neglect, they are used to being "very self-sufficient" in the fashion of open-source community members, according to Keeler. That cultural fit could help FoxPro transition to the open-source world.

Finally, while Vista’s recent introduction heralds the mainstreaming of 64-bit desktop computing -- a problem since FoxPro is 32-bit only today -- it will be many years before 32-bit PCs disappear, if the long transition from 16- to 32-bit Windows is any guide.

Add up those factors, CrimeStar’s Gagne said, and the choice is clear.

"My immediate plans are to stay where I am," he said. "I’ve got far too much time and intellectual property dedicated to FoxPro to just throw my arms up in the air."

Copyright © 2007 IDG Communications, Inc.

7 inconvenient truths about the hybrid work trend
Shop Tech Products at Amazon