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
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Choosing a backend
Thread ID: 143564 Message ID: 143652 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 Category: Network and Computer Management
Date: Thursday, August 30, 2007 2:27:02 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
>
> Dan,
>
> I am unable to help you much with this. I work primarily for charities and as such, they are able to get Microsoft Charity licensing. A little plug for Microsoft here - they are very generous with charities and the license costs are quite inexpensive. For this reason, I only work with SQL Server. I would however, suggest that what ever you go with, there will be a learning curve. You might want to look at where you will be in 5 years time. Is your organization growing and will you need to move up to SQL or Oracle (or something in that size) in a few years anyway? While software costs can be high, higher still is the cost of that learning curve. Your normal productivity will fall off for a bit as you learn the server. The cost is not just the reduction in your productivity, there is also the opportunity cost of the applications you could not develop. As you can see, the cost of the learning curve is quite high - and higher still if you have to go through another learning curve in a few years.
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)

Ken,

Yes - excellent thought. With open source office thrown in I'd probably go with MySQL. No matter what I do I'll have to bite the bullet so I might as well make it as big a pay off as possible.

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