Small local database?
I'm wondering what some of you use for local data storage for small apps. (When something a bit more elaborate than ini and text files is called for...)
We're using DBISAM here with great success. It's small and it gets built into the exe file. They're providing frequent updates. http://www.elevatesoft.com
The Delphi Fan
How large is DBISAM's footprint? When you build it into your .exe, how much size does it add?
DBISAM adds 0.5 MB to your exe file, which is incredible for what you get.
I forgot to mention that this is uncompressed. So with an installer you are probably looking at 200/300 KB.
TClientDataSet, which is part of Delphi since 3 (possibly only pro or enterprise), can save and load from files. You cannot use SQL on them, but they have extensive filtering capabilities.
I'd encourage you to stay with Advantage. The company has been around a long time, their product is extremely stable, they have phenomenal support, and if you ever need to take any of your apps to client/server it's extremely easy.
I've had further time to evaluate Advantage and must say that I'm pretty pleased with it. It'd be nice to be able to compile into the exe; but distributing 2 small dlls is no hassle.
Regarding TClientDataSet, the table structure is saved in the file, so it is not necessary to set that up. In addition, the table structure for new tables can be built using the design time editor as well as in code. Master/detail relationships are supported both through either the MasterSource property or nested table fields. If you use nested tables, all tables in the relationship are contained in one dataset and one file.
Fog Creek Home