🚀 go-pugleaf

Interesting question.  To my recollection, BC will use the BDE, just like
Delphi and C++B.

Honestly, I'd say you might even be better off simply writing an external
function that is callable from within the PL-SQL of Oracle and whatever
Sybase does for externals, and have that write your database for you, rather
than generate a complete application.  However, if you're going to build a
full executable for some user interaction, that idea becomes somewhat
pointless.

On the thought of a complete app, my default would be to build it in Delphi,
but that's simply because I'm better with that than any C-based language.
If you're unfamiliar with all the languages you mentioned, go with Delphi
simply for the softer learning curve.  Speed is comparable between Delphi /
BC / C++B; I can't speak for Visual C++ currently, but it wasn't terribly
visual last time I took a look at it (v4).

Avoid Oracle- or Sybase-specific tools.  Chances are they will be difficult
to manage when it comes to creating your exported database if it isn't an
Oracle or Sybase system.  That and their computation speed will (in all
likelihood - consider this hearsay) suck.

Generally, I'd probably just build it in Delphi, turn it on, and expect it
to work smoothly, cleanly, and quickly.  C++ Builder will be a similar
result, if you're more familiar with C++ than Pascal.  BC++ and VC++ will
require direct coding to the BDE or ODBC APIs, which seems to me too much
work (seeing as the wheel is already made, ride it).

Later -

  T


Jerwynn Lee wrote in message <72mlu5$mlq3@forums.borland.com>...
>Hi,
>
>We need to build a middleware system that will process huge amounts of data
>coming from
>Oracle and Sybase databases.  The program will transform these data by
>performing
>conversions and computations, and will dump the output to a new database.
>
>Is BC suitable for this kind of a program?  How would you rate / compare
the
>power of
>BC when it comes to database functionality? How would you compare it to
>Visual C++, and Delphi?
>
>What kind of database access does BC support (e.g. ODBC, embedded SQL)?
>Do you still have to deal w/ the IDE layer? What API's are available for
>Sybase and Oracle?
>How is the speed?
>
>Thanks.
>
>
>Jerwynn Lee
>
>
>
>
>
>

We have used C++ Builder 3 to natively talk to a Progress database running on a
Unix platform.  We were using Paradox and Paradox's locking symantics on a
Novell server but ran into record contention issues we could not solve.  We were
constantly deleting .lck files.  We then took a look at Interbase on Linux but
gave up due to lack of documentation -- maybe it has gotten better but seemed to
be a strong solution.

Finally, we wound up creating our own db API and use it to talk to a Progress
broker on Unix through use of Progress software's client networking for Win32
PCs.

Another very good tool is CodeBase.  Codebase now has some decent gui tools we
may look at getting back into.  Originally our team left Codebase due to lack of
gui support early on.  Some of our DOS applications used a Codebase (x-base)
library to connect 300 some people to an order entry system for a telemarketing
company and performance was very good for a $600 database.  CodeBase will work
with dbIV III, FoxPro, client server on Unix.  We were using it on a Novell
server with record locking trained by the app.

To answer your question, find native means to talk to your databases first.
ODBC is very network chatty... We see noticable benefits between ODBC and native
drivers time and time again.


Jerwynn Lee wrote:

> Hi,
>
> We need to build a middleware system that will process huge amounts of data
> coming from
> Oracle and Sybase databases.  The program will transform these data by
> performing
> conversions and computations, and will dump the output to a new database.
>
> Is BC suitable for this kind of a program?  How would you rate / compare the
> power of
> BC when it comes to database functionality? How would you compare it to
> Visual C++, and Delphi?
>
> What kind of database access does BC support (e.g. ODBC, embedded SQL)?
> Do you still have to deal w/ the IDE layer? What API's are available for
> Sybase and Oracle?
> How is the speed?
>
> Thanks.
>
> Jerwynn Lee