H2 has excellent support as an open source db. It's called H2 because it's a rewrite of Hsqldb by the original author, as far as I can tell.
Why go with a java database? A couple of reasons. 1) You can "install" (or distribute) the db just by adding the jar file to the project, and specifying an appropriate jdbc url. No separate database configuration/installation/maintenance necessary. Hsqldb will even run entirely in memory with no file system access. Not as sure about h2. 2) If there's a problem, you're more likely to be able to debug/identify and fix it as a java programmer, particularly since it can be a part of your actual application rather than a separate process. On Fri, Oct 16, 2009 at 5:47 PM, Eric Lazarus <ericllaza...@yahoo.com> wrote: > Thanks for all the help, folks! > > So, are people saying we should go with Cayenne 3.x and H2 or Apache Derby as > our personal desktop data store? We didn't want to use anything that was > unstable or incomplete but it is sounding like 3.x is what is current. > > Who is using Apache Derby? Who is using SQLLite? What makes sense for us? Our > goals are to get this out RAPIDLY and make it run on everything, install > easily and make it easy for folks in the open source world to continue the > development. The database must be invisible to the end user with no > maintenance headaches. > > Mike, why do you feel strongly that we should go with a Java DB? > > Thanks again! > > Eric > > > --- On Fri, 10/16/09, Mike Kienenberger <mkien...@gmail.com> wrote: > >> From: Mike Kienenberger <mkien...@gmail.com> >> Subject: Re: Cayenne and SqlLite, Cayenne 3.0 vs. 2.0 >> To: user@cayenne.apache.org >> Date: Friday, October 16, 2009, 5:40 PM >> Yes, I'd recommend H2, Hsqldb, or >> derby. >> >> I use H2 these days for small projects. I used to use >> hsqldb. Derby >> didn't seem to offer any advantage over these when I'd >> looked at it in >> the past, but it's still probably better than a non-java >> db. >> >> On Fri, Oct 16, 2009 at 5:21 PM, John Armstrong <siber...@gmail.com> >> wrote: >> > I use Derby for this. Its embedded. Its java. It works >> exceptionally well. >> > >> > John- >> > >> > On Fri, Oct 16, 2009 at 2:09 PM, Eric Lazarus <ericllaza...@yahoo.com> >> wrote: >> >> Folks >> >> >> >> Are people building new systems on Cayenne 3.0 or >> 2.0, mostly? What is recommended? (We have been deeply back >> versioned, successfully using 1.1 for many years.) >> >> >> >> I am about to release a threat modeling tool as an >> open source desktop system and I would like to have it save >> its data to a local, very low maintanane database. I was >> thinking SqlLite. Is it practical for me to save/retieve my >> objects to SqlLite via Cayenne? It seems that Sqlite is >> supported only in 3.0 not in 2.0.6. How stable is the >> current release 3.0M6? >> >> >> >> Is it possible or desireable to add the sqlite >> package from 3.0 to the 2.0 system? >> >> >> >> Is there another database that is so low maintance >> that I could consider using it as a personal data store for >> a desktop app that IS well supported by Cayenne in 2.0, if >> 2.0 is recommended for current development/depolyment? >> >> >> >> Thanks! >> >> >> >> Eric >> >> >> >> >> >> >> >> >> > >> > > > >
