Re: Suggestoins for Local DB to use with Shareware

Hi!

G. Bradley MacDonald wrote:
Hello Everyone,

I am looking for suggestions for a good local DB for our shareware
app.

DBISAM (www.elevatesoft.com). I use it in very small applications / tools up to multi user systems. It simply works and does not hinder you to do the job.

....
It should have the following:

The DB should fully support SQL.

Yup.

It would be nice if it only had one actual file - storing all the
tables/indexes, etc in that one file.

No.

It must be able to handle string fields of up to 512 characters in
size. Larger would be nice. It would even be better if it they were
like VarChar fields in a relational database and only took up the
size that was used.

Char up to 512 and memo fields.

It must have a low foot print in terms of size. This is shareware and
is downloadable. Somewhere arount 1 to 2 MB would be tollerable.

Sorry, but it is very hard to build a Delphi application with such a small footprint. But with a really good EXE packer, it's possible. The footprint of DBISAM is really small, but because my applications are up to 20 mb, I don't know if the footprint is 200k or 400k.

We will also be supporting MS SQL, Oracle, Interbase - for larger
customers - but want to support a local DB for smaller customers. So
- this DB must be able to support SQL as its main way of accessing the
data. It MUST be accessable using Borlands standard components - no
special TTable derivities is important.

All integrated db systems I know use their own tabkle components. In DBISAM, it's TDBISAMTable (and TDBISAMQuery). I don't think that there is anything working with Borlands TTable components.

Ralf

.