Which database

[hennep]

I have just built an application that uses sqlite for data storage. It's a very good solution when you do not need multiple threads to access the data at the same time.

But what if you do, what if you application wants a multi user database?

I don't want to run setup procedures for installing oracle,sqlserver,mysql,... as a dependancy for my own application.
Is there any database that uses a single file for storage and has multiuser capabilities as well? Preferably with the database engine compiled into my own exe-file

thanks,
Hennie

 

[ZoneVM]

I posted a "which Database..." question here a while back. I ended up using Firebird, and couldn't be happier. Not sure what OS you're running, but firebird has an embedded server, which is just a dll dropped into your application directory. Using the embedded server, my app is totally self contained as uses a single file for storage.

I plan on making my app a client eventually, and have a central server handle connections. All that I'll have to do is change my connection string in my dbexpress components. I'm using the firebird driver from upscene.com, which is not free, but is cheap and good.

 

[hennep]

Thank you for your reply.
I am running CBuilder on Windows XP.
What do you mean by "it is not free"? In the quick start document they publish a link to

http://sourceforge.net/projects/firebird.

You can download the latest source on this site. Did they recently change the license? This gives the impression that it is open source.
The quick start document also mentions a server and a guardian process. I prefer to enbed these parts into my own executable. Or is this the part that I have to buy?

 

[melmitts]

it is not free" refers to the IBX driver from updcene.com he is using.