On 17 Nov 2002 at 17:54, Jason Chapman (JAC2) wrote:

> I would ask this in the borland.public.dbExpress but I want to ensure
> I have the Firebird users POV.
>
> I am recommending a client move away from IBX for their Firebird
> (currently 0.94, but that's another story) deployments. I would
> normally pick between IBO or FIBPlus and the client states that they
> are committed to Firebird, BUT I really think that some day soon one
> of their prospects (mist likely the largest to date) is going to state
> that the product MUST work with OraM$ql server. So I was wondering if
> people have found dbExpress acceptable for their development. I
> haven't really used it that much except for small test application and
> data pumping. Failing this it will be TDataset derivatives from
> IBO/FIBplus, ringfencing special features of each to ease migration.
>
> My current thoughts are:
> 1) There is an IB and FB Driver for dbExpress
> 2) It does have the notion of Transactions, even if they are a little
> different to other implementations 3) The come in the box (good and
> bad thing) 4) They have reasonable performance. 5) TParams does not
> have an INT64, but .AsBCD or .AsDouble would probably work I am
> guessing. 6) Other dbExpress drivers are being developed for ODBC /
> Oracle / MSSql etc.
>

In using multiple engines, I would rather use ODBC, and be careful about the API
usage, so that the existing drivers work. In using a single engine, I would use
something native mode, such as IBO, IBPP, etc. I tend not to use RADs for
anything but Q&D stuff, the only copy of Delphi I have is really old.... For real
programming, I use C++.