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: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Choosing a backend
Thread ID: 143564 Message ID: 143573 # Views: 10 # Ratings: 0
Version: Visual FoxPro 9 Category: Network and Computer Management
Date: Wednesday, August 29, 2007 11:54:33 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
>
> IMHO if 1 CPU and 4Gb database size is sufficient MSSQL express is a good option. There is MSSQL anywhere (they change the names often, I am not sure if current name is SQL server mobile or anywhere) that has a footprint as low as 2Mb, that doesn't need installation, that can replicate data to a central SQL server.
> If you need you could start to use full blown SQL server.
>
> MSSQL2005 with its enhancements and CLR support directly built-in I see that as a nice option. Unlike MSDE it has a nice management GUI tool, a web based management tool etc.
>
> But that maybe because I work primarily with MSSQL and satisfied with its aspects didn't even bother to evaluate others (tried to work with Oracle but they wanted me to pay 1200K+ annually just for the developer version! Now it is for free I may check).
>
> Cetin Basoz

Cetin,
Thanks for that. I forgot about Sybase SQL Anywhere Personal DB. While not free a 5 seat license is only $600.
But that still leaves MSSQL05 and MySQL as free, so...
Dan


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