Subject dbExpress anyone (possibly considered OT)
Author Jason Chapman (JAC2)
All,

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.

Please, any thoughts / experiences would be most welcome.

JAC.