Cayenne and SqlLite, Cayenne 3.0 vs. 2.0

[Eric Lazarus <er...@yahoo.com>]

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  



      

Re: Cayenne and SqlLite, Cayenne 3.0 vs. 2.0

[Lucas Holt <lu...@foolishgames.com>]

On Oct 16, 2009, at 5:09 PM, Eric Lazarus 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 started on 2.0 with a new project earlier this year. While debugging  
another problem, I tried migration to 3.0.  I would highly recommend  
going with 3.0M6.  It's working better for us.  If you use the  
modeler, it's quite nice in 3.0.  Even if you don't take advantage of  
new features in 3.0, it seems to be much more efficient and there are  
subtle documentation improvements.

Lucas Holt
Luke@FoolishGames.com
________________________________________________________
MidnightBSD.org (Free OS)
JustJournal.com (Free blogging)

Re: Cayenne and SqlLite, Cayenne 3.0 vs. 2.0

[Michael Gentry <mg...@masslight.net>]

I'm building against 3.0M6 currently.  I'll switch that to the beta
candidate when it comes out.  For my uses, I have no concerns of
deploying with 3.0M6+.

I've never used Cayenne with SQLite.  SQLite is a C-based embeddable
database.  I have no idea how well the JDBC driver/etc for SQLite
work.  Do you need access to your data from a C-based application?  If
you are only using Java, have you considered H2?

http://www.h2database.com/html/main.html

You mentioned Cayenne 2.0 several times.  Is that really a requirement
for you or are you just scared that 3.0 isn't final yet?

mrg


On Fri, Oct 16, 2009 at 5:09 PM, Eric Lazarus <er...@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
>
>
>
>

Re: Cayenne and SqlLite, Cayenne 3.0 vs. 2.0

[Mike Kienenberger <mk...@gmail.com>]

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 <si...@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 <er...@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
>>
>>
>>
>>
>

Re: Cayenne and SqlLite, Cayenne 3.0 vs. 2.0

[John Armstrong <si...@gmail.com>]

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 <er...@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
>
>
>
>