Link to home
Start Free TrialLog in
Avatar of cuuu
cuuu

asked on

Free BDE alternative

Hi.
I'm looking for a *free* alternative for BDE so that all the database access mechanism at a final stage is self-contained in one exe, no additional installations, drivers, etc. Ideally, the database should be kept in one big file, possibly with encryption, crc checks, etc. It also should be compatible with standart Delphi data avare controls.
SOLUTION
Avatar of jconde
jconde

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Wim ten Brink
Wim ten Brink
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cuuu
cuuu

ASKER

I am experimenting with TinyDB right now, and $89 really isn't such a big problem.
One thing distracts me - the word "Tiny" in its title. What if i had 10 tables with several K of records all related to each other? In documentation it's mentioned that this db can handle more than 100'000 records but, emm, what  with performance? :)
So I think I'll give it some crash tests ;)
Since this db cannot handle SQL requests (as for me, well maybe it can and i'm just dumb :/ ), it may actually not be possible to bring all these complex relations to life.
DeerBear - i guess i didn't make myself clear - I am definitely not looking for another bloated db interface like BDE, or, even worse, ADO (lots of users will be forced to update their DCOM, ADO and whatnot, in this case it's unacceptable). I'm looking for a lightweight DB system with no additional drivers and no specific requirements for environment. I hope i'm not dreaming :)
Another one that you might want to look at is the Advantage Database Server (ADS). I didn't mention it before because it didn't meet all of your criteria. Specifically, the data is stored in more than one file and ADS doesn't compile into the program. However, it has several attractive features.

* It's *free* for single user use.
* It supports a subset of ANSI-92 SQL.
* If you ever needed to scale up, there's a client/server version ($)

I've used it and thought it worked quite well. www.advantagedatabase.com