db4o Embedded DB

[Mike Hankey]

Has anyone used this product? Is there anything out there free and better? I did some research but chose this product because; 1) It was free 2) Fairly lightweight 3) C# API 4) GNU General Public License which if I understand correctly allows me to just about anything with it. Any gotchas there if I go commercial with my product? 5) Integrates with VS2005 and VS2008 6) Ease of use (Seems to be drop-dead easy?) Guess I answered my own question unless there is something that just absolutely sucks about it? Thanks, Mike

Age doesn't make you forgetful. Having way too many stupid things to remember makes you forgetful. http://www.hq4thmarinescomm.com[^] My Site

[PIEBALDconsult]

Never heard of it; got a link?

[Mike Hankey]

Got it here db4o[^]

Age doesn't make you forgetful. Having way too many stupid things to remember makes you forgetful. http://www.hq4thmarinescomm.com[^] My Site

[PIEBALDconsult]

I just read through their Wikipedia page. It looks like it only persists objects, it seems it doesn't support SQL, it might not allow you to use queries to create different subsets of data. Looking at their site now...

[Mike Hankey]

PIEBALDconsult wrote:

it seems it doesn't support SQL

That's one of the things I didn't like about it, but they have a nice Native Query alternative that looks to be pretty sophisticated. I've only been working with it for a couple of hours and have found a couple of things I don't like about it but can live with. Also the documentation is decent so that helps a lot, at least for me.

Age doesn't make you forgetful. Having way too many stupid things to remember makes you forgetful. http://www.hq4thmarinescomm.com[^] My Site

[PIEBALDconsult]

If it does what you need, then use it.

[Mike Hankey]

PIEBALDconsult wrote:

If it does what you need, then use it.

It looks like it will do what I want but I haven't used many embedded DB's so the only reason I posted was so if I got 3/4 of the way down the line and started finding problems, restrictions, etc. then maybe someone with more experience could save me the frustration and point me to a better EDB. Anyway thanks for your input

Age doesn't make you forgetful. Having way too many stupid things to remember makes you forgetful. http://www.hq4thmarinescomm.com[^] My Site

[Dan Mos]

for an embedded DB it's simply the fastest approach. Not saying it's faster than SQL Lite or SQL Compact just that it's a lot faster to create the app. No need to map or use ORM tools in order to fill the gap between the ObjectModel and the DB Layer/Model. I used it a lot as a small embedded DB and it's more than fine. I wouldn't risk buying it and using it as a DB Server. But for small/local/embedded DBs it just works. :)

I bug

[Mike Hankey]

Thanks that's exactly the feedback I was looking for. I'm just using it as a local DB as I didn't want users of application I am developing to have to install SqlExpress or other server just to run this app.. Just needed something fast, lite and easy to learn/use. Thanks for the input, Mike

Age doesn't make you forgetful. Having way too many stupid things to remember makes you forgetful. http://www.hq4thmarinescomm.com[^] My Site

[Dan Mos]

you're welcome :)

I bug