Link to home
Create AccountLog in
Avatar of yarekGmail
yarekGmail

asked on

delphi XE and database

Hi
I have some questions about delphi XE and database components built in.
1) what would be the best components for database manipulations exclusively in memory with no files created on hard disk.

2) what would be the best delphi components for database manipualtions with no database server to be installed or deployed : the goal would be to have the lightest .exe installer possible on client PC.

There are many DB components builtin and I do not know  which one I should use.

Thanx
ASKER CERTIFIED SOLUTION
Avatar of Ephraim Wangoya
Ephraim Wangoya
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of yarekGmail
yarekGmail

ASKER

Hello,
componentAce and kbMemTable are both 3rd party components.
What about these ones shipped with Delphi ?
1) is there are memory Database builtin ?
2) is there a database that does not require database server deployments at all (noether external DLL etc..) ?


Regards
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I don't mix goals: I try to get the best components for my devlopments.

I have 2 different devlopments:
1) with no database files at all: so a kind of memory database


2) a light devlopment database (with some files): I just do not want my users to have to install 200megas of sqlserver first. So a light datbase with no external DLLs calls etc...


Some one has suggested KBmemory and Absolute database: that's fine.
I just prefer to use builtin delphi components if they exist. If not, I will use these external ones.


Regards
what does your program do ?
what are the requirements ?
do your requirements meet the requirements of the customer ?

high performance using in memory processing doesn't work in a multi user environment ...


If you look at my first post, TClientDataset can be used as a Memory dataset and it comes with delphi

If you want a light weight database, you can use Firebird and the Interbase components already in delphi

Also Geert has given you some good input you will need to consider
ok perfect.
Just last question abut firebird: what is the extension of the firebird databse ?
What extra size is the final .exe with firebird deployment ?
Is there a firebird database manager included in delphi for table creation etc ?

regards
@ mlmcc,
I recommend split points (37247842, 37248217, 37249473)


@ yarekGmail,
>   what is the extension of the firebird database?
.fdb

>   What extra size is the final .exe with firebird deployment?
The exe will not change, you will need to install firebird or provide the supporting files along with your exe.

>   Is there a firebird database manager included in delphi for table creation etc ?
No, Delphi does not have firebird DB Manager.
But there are firebird database management software which do not come by default with Delphi or firebird.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.