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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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 ...
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
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
ASKER
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
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.
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.
ASKER
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