ClientDataSet, NexusDB etc. - Which single user database?

[Bronsi]

I'd appreciate it if anyone had any ideas on which solution they'd use for creating a single user, local data, application.
I've looked at NexusDB, EasyTable and a few others. Then there is using ClientDataSets or even just bog standard typed files of records.
I've got no one to talk to
So if anyone has used any of these approaches and has any advice or preferences, then please let me know.
Thanks.

 

[DjangMan]

ADO/MSAccess Then you don't have to pay for any other components.

If you need more gusto then consider MSSQL Express.

 

[melmitts]

Check out:

http://www.componentace.com/bde_replacement_database_delphi_absolute_database.htm

It is free for personal use.

 

[Bronsi]

It is an application which will be sold for use by small to medium businesses.
I just don't want o have to install anything other than my app. on customer PCs. Which is why I'm after a nice neat solution which will compile right into my software.
There are many out there which can be had for very reasonable prices, including the source if necessary. I'd just like to hear of any experiences others have had in going down this route and with which databases.

 

[melmitts]

Absolute Database compiles into your Delphi program so all you have distribute is the .EXE file and database file. There are several options for purchasing the software for commercial purposes.

 

[DjangMan]

I have ABS as well and find it to be a good work horse. I've never had any corruption issues and tech support has always been responsive. I have the multi-user edition. I tried AidAim's offerings but I found their tech support to be slow in responding to queries.

 

[roo0047]

Although I have not used it personally, I've considered Sqlite for a simular application. If anyone HAS used it, please advise.

http://www.sqlite.org/

Roo
Delphi Rules!

 

[KoenVandemoortel]

Hi, I am looking for the same thing.
I've tried AidAim's SQLMemTable and the Absolute DB (ComponentAce) and they are both easy to handle, well documented toys with really working examples (while usually demos never work), but both have bugs when working with unicode memo fields. AidAim promised to fix them in a few weeks.

 

[KoenVandemoortel]

Does SQLite work with Delphi?

 

[DjangMan]

http://sqlite4delphi.sourceforge.net/

http://www.itwriting.com/blog/a-simple-delphi-wrapper-for-sqlite-3

 

[JES1904]

ClientDataSet provides a means of moving the data into memory. Since it is in memory it will accelerate performance working with the data. It also tracks all changes made to the data before the file based copy is updated, allowing a number of changes to be accepted or deleted before the permanent file is updated. There is a good tutorial series in delphi.about.com. written by Jensen. I think it is also found in the Codegear site downloads.