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 <mkienen..mail.com> wrote:
> From: Mike Kienenberger <mkienen..mail.com>
> Subject: Re: Cayenne and SqlLite, Cayenne 3.0 vs. 2.0
> To: use..ayenne.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 <siberia..mail.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 <ericllazaru..ahoo.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
> >>
> >>
> >>
> >>
> >
>
This archive was generated by hypermail 2.0.0 : Fri Oct 16 2009 - 17:49:31 EDT