Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Daniel Hofford
  Where is Daniel Hofford?
 Ocala
 Florida - United States
 Daniel Hofford
 Tags
Subject: Choosing a backend
Thread ID: 143564 Message ID: 143564 # Views: 15 # Ratings: 1
Version: Visual FoxPro 9 Category: Network and Computer Management
Date: Wednesday, August 29, 2007 11:01:10 PM         
   


I've come to the conclusion that there is no way around installing a client/server database for this particular application.
The app is small, collecting data from about 20 work stations at three locations, one of them is where the server is and the other two are remote.
The connection will be over a vpn and one of the requirements is that if the wire goes down the apps keep functioning. This means three
apps on servers at each location collecting data and through some trigger, being sent to the central server. The amount of data that would go down the line at any one time is very small. However, the amount of data that needs to be accessed for validation and a 'change' process is large, too large to be brought over the wire which is what makes the c/s architecture so important. (Even bringing over just the indexes slows things down to a painful crawl).

Everone may have their favorite backend and for particular purposes one might be better than the other. I've never worked with any backend other than MS SQLServer but all I ever had to do was write the SQL to access it. I never had to consider what decisions would have to be made in choosing it. So this is all new to me.

I've tried to list what my criteria are and wonder if anyone out there has used more than one of these (able then to compare them) or any other that I might have missed and could give an indication of which way to go according to the criteria, some of which might be contradictory or a fantasy. I'm looking for a package that comes closest, not one that's perfect.

I had thought of using Recital which is integrated with VFP but the cost for 20 concurrent users is $2500 and what you get, essentially, is a driver and com object, which then manipulates the dbfs on the server. Seems a bit steep compared to the price for MySQL but then the learning curve is pretty short. I thought of using VFPServer but the instruction manual is in Spanish and support is non-existent.

My criteria for choosing are:

Free.
Be able to handle up to 20 concurrent users
The definition of Simplicity
Easy to install
Gentle learning curve
No DBA required
Self-Maintaining
Does not require learning another language
Does not require constant updates
Does not require prior allocation of disk space - Dynamically manages storage space
Windows GUI Management Console

The one's that seem most promising to me are:

Microsoft SQL Server 2005 Express Edition
http://www.microsoft.com/sql/editions/express/features.mspx

MySQL Community Server v5.0
http://dev.mysql.com/

PostgreSQL
http://www.postgresql.org/

Adabas D
http://www.softwareag.com/Corporate/Images/07June_FS_Adabas_D_tcm16-11120.pdf
Free but limited to 3 users, 1 CPU, 100 MB

This site lists many server products that can be had free (for the most part).
http://www.freeprogrammingresources.com/dbservers.html


Thanks again,
Dan
"Our gold does not chink and glitter. It gleams in the sun and neighs in the dark." Chief Joseph

ENTIRE THREAD

Choosing a backend Posted by Daniel Hofford @ 8/29/2007 11:01:10 PM
RE: Choosing a backend Posted by Cetin Basoz @ 8/29/2007 11:25:32 PM
RE: Choosing a backend Posted by Daniel Hofford @ 8/29/2007 11:54:33 PM
RE: Choosing a backend Posted by Cetin Basoz @ 8/30/2007 2:06:04 PM
RE: Choosing a backend Posted by Cetin Basoz @ 8/30/2007 2:21:57 PM
RE: Choosing a backend Posted by Daniel Hofford @ 8/30/2007 2:24:58 PM
RE: Choosing a backend Posted by Cetin Basoz @ 8/30/2007 2:30:49 PM
RE: Choosing a backend Posted by Ken Murphy @ 8/30/2007 1:23:43 AM
RE: Choosing a backend Posted by Daniel Hofford @ 8/30/2007 2:27:02 PM
RE: Choosing a backend Posted by Daniel Hofford @ 8/30/2007 10:20:15 PM
RE: Choosing a backend Posted by Ken Murphy @ 8/30/2007 10:37:54 PM
RE: Choosing a backend Posted by Daniel Hofford @ 8/31/2007 12:58:42 AM
RE: Choosing a backend Posted by Yull67 @ 8/31/2007 12:50:23 AM
RE: Choosing a backend Posted by Ken Murphy @ 8/31/2007 3:12:25 AM
RE: Choosing a backend Posted by Ronald Haugen @ 8/30/2007 1:57:00 PM
RE: Choosing a backend Posted by Daniel Hofford @ 8/30/2007 2:22:34 PM