whats the best database component to use

is it dbExpress connection?
is it ADODB connection?
is it the BdE? <dissolve>
As  I see  interbase component was exclusively put in the palette.


what if I use oracle express, what's good for it? dbExpress, adoDb?  odac for what?



As a Delphi database expert, what are your recommendations? or sayings?
whats the best database component to use?

please forgive me if my ask are too complicated, but just say you input and outputs.


thanks
LVL 14
systanAsked:
Who is Participating?
 
Ephraim WangoyaCommented:
BEE is no good, don't use it
dbExpress is excellent and its what I use to connect to sql server and forebode with depart drivers
ADO is also very good intact it is much faster than dbexpress since dbexpress has to go through an extra dll to communicate with the database and the drivers often come  free with the database

My best bet is to use ADO. But I am sure other people will have different opinions
0
 
Ephraim WangoyaCommented:
Sorry for the typos, typing on the phone is not always fun
<BDE is no good, don't use it>
<dbExpress is excellent and its what I use to connect to sql server and firebird with depart drivers
0
 
Ephraim WangoyaCommented:


I'm not familiar with odac, I have never used it so I can't comment on it
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Mahdi78Commented:
The best component it is Unidac from devart.com
It support Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).

Take look in this picture


unidacdiagram.jpg
0
 
jimyXCommented:
@ ewangoya
>   "BEE is no good"

Some times BEE is good, otherwise we don't get honey :-)

0
 
Ephraim WangoyaCommented:

@jimyX
LOL nice one
I'll get you somedaye
0
 
Ephraim WangoyaCommented:

@Mahdi78
I don't know about best
Unidac is still communicating with OLE DB or ODBC, its just one more layer before you get to the database
0
 
systanAuthor Commented:
i LIKE all the comments;

>>BDE is no good, don't use it
yes, it was dissolve, it if is good then they will never abolish it.

>>dbExpress is excellent and its what I use to connect to sql server and forebode with depart drivers
it is recommended by Embarcadero

>>ADO is also very good intact it is much faster than dbexpress since dbexpress has to go through an extra dll to communicate with the database and the drivers often come  free with the database
I agree with this

>>My best bet is to use ADO. But I am sure other people will have different opinions
But using ADO?   do you think,   we can connect to every kind of database models such as my_sql, sq_lite, ms_sql, oracle,  teradata, db2 or 3?   I think ADODB component can only be used to connect using ms_access data model?
...
...
>>The best component it is Unidac from devart.com
Yes, I've seen this chart a long time ago, it is.
All most the same as dBexpress.
..
..
>>otherwise we don't get honey :-)
now, this is a joke, anyway, congrats to jimyX in top 25 in delphi hall of fame,  too early.
...
...
>>I'm not familiar with odac, I have never used it so I can't comment on it
Actually, epasquier and geert recommends to use it, they said it's fast and good.
I think it's from DevArt too AS dbExpress from?  I don't know if there is from Oracle it self.
0
 
systanAuthor Commented:
...
...
>>Unidac is still communicating with OLE DB or ODBC, its just one more layer before you get to the database
yes, slows down the database system? a little maybe,  nice comment ewangoya.
0
 
Ephraim WangoyaCommented:


ADO can connect to all databases as long as you a have an OLE DB Provider or ODBC driver for that database. So all the databases you mentioned can be accessed through ADO including the ones shown in the odac diagram by Mahdi78
0
 
jimyXCommented:
BDE has got abandoned and left behind while ago. It does exist to support old development but it will not be improved.

The advantage of DBExpress over ADO is that DBExpress supports multi-platforms.

ODAC is a component for fast direct access to Oracle.

You can read this page (it's a translation from Spanish language):
Todoexpertos.com
The original Page

Regarding the best database component, there are many factors to consider when selecting DB components.
0
 
systanAuthor Commented:
>>ADO can connect to all databases as long as you a have an OLE DB Provider or ODBC driver for that database
yes the driver itself slows down the database system.  ODBC is slow.  OLEDB is fast.
...
...
>>The advantage of DBExpress over ADO is that DBExpress supports multi-platforms.
I think they are both same,  not with multi-platform.
ADO only individualized the drivers needed to connect.
dBExpress has it's own internal drivers for different data models.
...
...
>>ODAC is a component for fast direct access to Oracle.
Yes, it's from devArt, so it will be installed on dbExpress?

I think jimyX is in favor of dbExpress, aDO for ewangoya, unidac for madhi.


>>
Regarding the best database component, there are many factors to consider when selecting DB components.
What factors? like?


Ok; I got to close this by monday, good comments fellows.

thanks
0
 
systanAuthor Commented:
Oh, iNTERbASE on the palette?
A special database component palette using the interbase data model ALONE.?
0
 
Geert GOracle dbaCommented:
BDE 2/10, ADO3/10, IB 3/10, ODAC 9/10
but that's just my opinion

BDE only gets 2/10 because it didn't stick around anymore ... :)
0
 
systanAuthor Commented:
ODAC 9/10?
what?
odac access from dBexpress
so dBexpress incharge of odac?
I don't really know what will happen to the palette if you install odac on delphi.
0
 
Geert GOracle dbaCommented:
no, odac from devart
0
 
ThommyCommented:
I'm committed to dBExpress, using it for ORACLE 10g and 11g database.

It is  straightforward, powerful and flexible...
0
 
systanAuthor Commented:
Points increased for many assistance.


But dBexpress is a devArt project? isn't it?
...
...
>>no, odac from devart
You meant to say that after installation of odac?, it will build another palette for just odac?
..
..
>>I'm committed to dBExpress, using it for ORACLE 10g and 11g database.
>>It is  straightforward, powerful and flexible...
I believed this one; with oracle, but the oracle driver is ODAC itself?  if NOT where does that came from<the oracle from dBexpress I meant>?
0
 
8080_DiverCommented:
My vote goes for ADO with dbExppress coming in second.  Admittedly, I have only used ODAC a little bit but I still wind up using ADO for 99% of the projects I do.
0
 
Geert GOracle dbaCommented:
i set the points only for components i have used
i never put dbexpress in my comments
that's something you did systan

Odac = Oracle Data Access Component
from http://www.devart.com/odac/

it looks like there are 2 sets which can be used in delphi
http://www.devart.com/vcl.html




0
 
systanAuthor Commented:
The comments are great.

There is also, core labs odac for Delphi, I'm not sure if is real.

The comments are graded level.


thank you
0
 
Geert GOracle dbaCommented:
core labs was taken over be devart.
They are 1 and the same
0
 
systanAuthor Commented:
toink;

thanks geert
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.