🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4433

DBMS for Eval through Corporate Apps?

#4433
From: Fernie Arredondo
Date: Fri, 28 Dec 2001 04:53
37 lines
2635 bytes
I would like to know what BCB developers are using for distributing
EVALUATION versions of their applications.

1.  I'm not simply looking for something that is free but ideally, I would
like to find a RDMS that can run free of cost for _single_ or a _limited_
number of users without the need for a database server.

2.  At the same time, I would like a system that is scaleable for larger
environments where a database server is necessary.  Yes, I know that this
isn't free!

3.  Full SQL support supporting stored procedures.

Using the CA-Visual Objects programming language for several projects, I was
able to use a native driver (much like a DLL) that would give me direct
access to FoxPro databases without ODBC as long as the app stored directory
info.  This driver is perfect for single user / evaluation applications and
very good for multi-user apps having a few hundred thousand records over a
LAN.  There is no licensing cost associated with these databases but there
are a host of limitations that a RDMS overcomes.

Advantage Database Server by Extended Systems offers powerful server
solution to overcome most but not all of the limitations found by using
FoxPro/DBase/Clipper tables with no code changes which makes it extreemly
attractive.  I know programmers that have used it with great success.

Unfortunately, in my humble opinion, Advantage Database Server lacks some
features that found in a full blown RDMS.  ADS will not allow for a "thin"
client as none of your business logic can be off-set to the server.  This is
the biggest limitation that I want to get away from.

As you can see, I want to make a smart choice and your advice is greatly
appreciated!

Kindest Regards,

Fernie
Technical Details
Message-ID: <3c2bb430$1_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3043a8ab4251ead9,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-12-27 15:59:12 PST
From: "Fernie Arredondo" <FernieArredondo@Yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: DBMS for Eval through Corporate Apps?
Date: Thu, 27 Dec 2001 16:53:03 -1200
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 204.99.122.136
Message-ID: <3c2bb430$1_1@dnews>
X-Trace: dnews 1009497136 204.99.122.136 (27 Dec 2001 15:52:16 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews