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 <
[hidden email]> 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 <
[hidden email]> wrote:
>
>> From: Mike Kienenberger <
[hidden email]>
>> Subject: Re: Cayenne and SqlLite, Cayenne 3.0 vs. 2.0
>> To:
[hidden email]
>> 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 <
[hidden email]>
>> 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 <
[hidden email]>
>> 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
>> >>
>> >>
>> >>
>> >>
>> >
>>
>
>
>
>
