Ayende @ Rahien

Ayende Rahien commented on Observations on Embedded databases

Wed, 06 Aug 2008 00:06:36 GMT

http://ayende.com/Blog/archive/2008/07/07/Why-I-dont-like-FireBird-Part-II.aspx

Ayende Rahien commented on Observations on Embedded databases

Tue, 05 Aug 2008 23:35:03 GMT

Darrell, What part of embedded database does PostgresSQL Has?

Darrell commented on Observations on Embedded databases

Tue, 05 Aug 2008 13:50:04 GMT

May want to check out Postgresql: http://www.postgresql.org/ You will like their license!

Jan Persson commented on Observations on Embedded databases

Tue, 05 Aug 2008 09:42:37 GMT

I'm sorry to say that I neither have the time nor the competence to understand the problems you experienced by looking through your code. Could you instead please (in a few words) explain what kind of problems you had with Firebird? Since Firebird is using MVCC it doesn't behave in the same way as other databases when it comes to locking and isolation, but that is not the same thing as to say that it is not handling transaction isolation.

Ayende Rahien commented on Observations on Embedded databases

Mon, 04 Aug 2008 19:33:43 GMT

Run the throughput sample here, you'll see the problem: https://rhino-tools.svn.sourceforge.net/svnroot/rhino-tools/branches/rhino-queues-firebird

Jan Persson commented on Observations on Embedded databases

Mon, 04 Aug 2008 08:24:58 GMT

What do you mean when you say that Firebird does not handle transaction isolation? Actually it handles multiple transactions very well and we have been using it embedded in a multi-threaded application for almost two years now. http://www.firebirdsql.org/dotnetfirebird/blog/2005/02/transaction-isolation-levels-in.html

Ayende Rahien commented on Observations on Embedded databases

Mon, 21 Jul 2008 16:51:51 GMT

I am using the System.Data.Sqlite version, which has embedded version of the native DLL. No idea what that version is, though. I _think_ that I might have an earlier version. I'll have to try that.

Eric Hauser commented on Observations on Embedded databases

Mon, 21 Jul 2008 16:34:26 GMT

I was browsing through the SQLite documentation. According to it in versions greater than 3.4, the whole database does not lock: http://www.sqlite.org/34to35.html (Section 4.0) Based on your experiences, Is this inaccurate?

Gunnar Liljas commented on Observations on Embedded databases

Wed, 16 Jul 2008 11:45:44 GMT

db4o doesn't exactly have a "free license that allow commercial use" does it?

Pierre Meyer commented on Observations on Embedded databases

Wed, 16 Jul 2008 10:09:11 GMT

intersting blog !! for my AVS scm project, I tried at first OneDollarDB, which performances were quite great, but I had issues with indexes, which caused database crashes, so I dropped it out. now I am using DerbyDB, which also provides an embedded database, very stable product. Did you spend some time on this one ? Pierre

Ayende Rahien commented on Observations on Embedded databases

Wed, 16 Jul 2008 09:12:39 GMT

I did, and we had this issue. But note that I am not using this in an ASP.Net system

Marc commented on Observations on Embedded databases

Wed, 16 Jul 2008 08:47:26 GMT

Perhaps I'im mission something, but did you try to enable Sql CE for ASP.Net environment ? AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true) See http://blogs.msdn.com/stevelasker/archive/2006/11/27/sql-server-compact-edition-under-asp-net-and-iis.aspx for full explanation.

Ayende Rahien commented on Observations on Embedded databases

Mon, 14 Jul 2008 17:50:58 GMT

It is based on me not liking limitations on what I can do with a piece of software I write. If I am basing myself on a certain platform, I want to know what I can do with it. Having limitations on that is counter to what I would like to have. Paying for something is not an issue, but in this case, I am working on a hobby project. As such, I would like to be able to use it in any circumstance. Just to give you an idea, Rhino Mocks was a hobby project.

ecards commented on Observations on Embedded databases

Mon, 14 Jul 2008 15:02:59 GMT

Just wondering about your reluctance to use a commercial db (vistadb) in a commercial product. Is it based on philosophy or just affordability of the license? Of course I understand wanting to use open source for non-commercial projects, and also for commercial projects where there is a clearly proven and ready solution. But no doubt your time to research this was worth more than the cost of a license, so I'm curious about the motivation. best regards, lee

blater commented on Observations on Embedded databases

Mon, 14 Jul 2008 10:38:33 GMT

you have my sympathies - we spent a lot of time investigating embedded databases, and settled on derby/hsqldb... before getting burned by it's lack of proper support for some of the more "difficult" parts of sql 92. h2 (h2database.com) did the trick though. Recommended. if you need an embedded java database that won't turn round and bite you.

Ayende Rahien commented on Observations on Embedded databases

Mon, 14 Jul 2008 06:36:54 GMT

The issue is different, here you have redistribution vs. commercial

Justin Rudd commented on Observations on Embedded databases

Mon, 14 Jul 2008 06:29:04 GMT

The inability to use in a commercial version is a reason to reject it. I do intend to make use of this in a commercial applications. Be careful with Oracle BDB (i.e. Sleepycat) with regard to their open source license - http://www.oracle.com/technology/software/products/berkeley-db/htdocs/licensing.html - if you plan on distributing what you are working on under a commercial license, you'll need the commercial BDB license unless you are going to give away all the code. But then it would be a dual license...hm...I dunno. I just know that I had plans to use BDB in a little app that I wanted to be able to take commercial later on. The language in the OSI license was vague enough to make me rethink it. Now if you've got a lawyer that says otherwise...

Ayende Rahien commented on Observations on Embedded databases

Mon, 14 Jul 2008 02:37:36 GMT

I didn't miss the patch at all. And I am grateful for the quick responses in the forums. The problem that I have is that the cost of using BDB has risen to the point where I need to invest too much for a side project, which is what Iam using it for now. I am _very_ happy to hear that you are working on a .NET API, just making a 1:1 mapping between the languages would be incredibly valuable. Is there any beta program that would allow me to use this API right now?

Gregory Burd commented on Observations on Embedded databases

Mon, 14 Jul 2008 01:49:05 GMT

Hello, Thanks for checking into Berkeley DB and using our forums to try to address your issues. I think you missed the part where we posted you a fix as a patch to 4.5, did you try that? Also, 4.7.x is the latest release, and as always it is a bit better than its predecessors. Finally, you're looking for a .NET/C# API. Guess what? You're not alone. You ended up using someone's .NET API, but not one from Oracle. We're working on one that we will support. We're also working to make our C++ API more STL friendly. The .NET/C# API will evolve over time, we hope to be able to provide Direct Persistence Layer (DPL) style features (automatic object->database mappings) soon. In general, I think we need to better support Windows developers like you. Please keep going to our forums, or email me directly. regards, -greg Gregory Burd | Senior Product Manager | Berkeley DB, Oracle Corp

lg commented on Observations on Embedded databases

Sun, 13 Jul 2008 19:03:52 GMT

derby http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html http://www.hsqldb.org/ hsqldb

Tuna Toksoz commented on Observations on Embedded databases

Sat, 12 Jul 2008 16:16:42 GMT

I'm with James Arendt, It suports embedded server mode.

Ayende Rahien commented on Observations on Embedded databases

Sat, 12 Jul 2008 09:34:39 GMT

I know. The inability to use in a commercial version is a reason to reject it. I do intend to make use of this in a commercial applications.

Sean Kearon commented on Observations on Embedded databases

Sat, 12 Jul 2008 09:32:09 GMT

Ayende, VistaDB _does_ have an express version that allows what you need. You can use as long as you are not using it commercially, display the VistaDB logo, are not writing integration with VS, etc. Pretty straight forward and definitely allows open source projects to use it freely. There are a couple of feature restrictions too - no VS GUI support, no isolated storage, no in-memory support. But hey, can't have everything ;) They have a blog about it here: http://www.vistadb.net/blog/vistadb-news/vistadb-express-release/

Ayende Rahien commented on Observations on Embedded databases

Sat, 12 Jul 2008 03:10:08 GMT

If _I_ need to lock a DB, that is a problem with the DB. A DB should be thread safe.

Joshka commented on Observations on Embedded databases

Fri, 11 Jul 2008 19:25:39 GMT

but what makes any of the above db's not thread safe if you wrap them with locking...

Stiiifff commented on Observations on Embedded databases

Fri, 11 Jul 2008 14:32:22 GMT

Check out ServiceModelEx lib from Juval Lowy ... it contains System.Transaction-aware collections. Or maybe that's you've implemented already ;o)

pete w commented on Observations on Embedded databases

Fri, 11 Jul 2008 14:04:39 GMT

"Conclusion I start using Dictionary as my data store. Just don't restart the server." Reading that one made me laugh out loud :)

Casey Duplantis commented on Observations on Embedded databases

Fri, 11 Jul 2008 14:03:24 GMT

I agree - this is a missing part of the open.net approach. Have you tried hsqldb .net? (http://hsqldb.cvs.sourceforge.net/hsqldb/Dot.NET/Org.Hsqldb/) I've used the java version for Java/Groovy/Grails work - especially handy for unit tests. The downside? It looks like the .NET version runs on IKVM (might not be the best option for you) and has no recent activity.

Ayende Rahien commented on Observations on Embedded databases

Fri, 11 Jul 2008 12:23:36 GMT

vbandrade, Try to several hundred thousand items in it from multi threads, and it breaks down.

Ayende Rahien commented on Observations on Embedded databases

Fri, 11 Jul 2008 12:22:15 GMT

Joshka, It is thread safe if you wrap it with locking