Have you considered MySQL as an embedded DB?
http://mysql.com/why-mysql/white-papers/embedded.php This variation on the
standard MySQL has a much smaller footprint... though I haven't used it as
such. It may just be my gut feel, but I would probably only use Derby for a
"development" database rather than to depend on it for a "production"
environment. MySQL, in general, has had a great track record as an open source
database and has a lot of support in the industry.
I would second John's suggestion to use JPA with Hibernate. JPA is part of the
Java5 standard, having incorporated the great success of the lightweight open
source persistence models to shore up the weaknesses associated with the old
EJB architecture.
-David
----- Original Message ----
From: John Finlay <[EMAIL PROTECTED]>
To: LDS Open Source Software <ldsoss@lists.ldsoss.org>
Sent: Tuesday, May 15, 2007 9:53:21 AM
Subject: RE: [Ldsoss] Database for FamilySearch OpenSource Client
<!--
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times
New Roman", "serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
span.EmailStyle17
{font-family:"Calibri", "sans-serif";color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
p.MsoNormal
{margin-left:3.0pt;}
I’ve used Derby and HSQL. Both are good embeddable
DBs. It sounds like H2 is worth looking into though.
For a database abstraction framework, I would go with the new standard
Java Persistence API (JPA). With the JPA and Java 5’s annotations
and generics, developing a persistence layer is a breeze.
See http://java.sun.com/javaee/technologies/persistence.jsp
and http://java.sun.com/javaee/overview/faq/persistence.jsp
Here is a good tutorial using Netbeans and Derby
https://glassfish.dev.java.net/javaee5/persistence/persistence-example.html
The JPA also runs on top of an implementation like Hibernate or
TopLink. So you not only get the advantage of coding to an open standard,
but you also get the power and stability of hibernate.
--John
John
Finlay
Instructor
- Neumont University
[EMAIL PROTECTED]
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Gordon Clarke
Sent: Friday, June 15, 2007 8:51 AM
To: LDSOSS@LISTS.LDSOSS.ORG
Subject: [Ldsoss] Database for FamilySearch OpenSource Client
LDS Developers,
I have three
important questions about the Java-based Open Source Desktop Client that
FamilySearch is developing to work in conjunction with our New FamilySearch
master family tree. All answers and any comments about the database issue will
be greatly appreciated.
1) What open source
database would you recommend?
2) Do you know of a
type of architecture that could be used to create a framework extensible for
different databases?
3) What do you think
about the Derby? H2?
Thanks so much,
Gordon Clarke
FamilySearch DevNet
Manager
NOTICE: This email
message is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies of
the original message.
_______________________________________________
Ldsoss mailing list
Ldsoss@lists.ldsoss.org
http://lists.ldsoss.org/mailman/listinfo/ldsoss
____________________________________________________________________________________Take
the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
http://mobile.yahoo.com/go?refer=1GNXIC_______________________________________________
Ldsoss mailing list
Ldsoss@lists.ldsoss.org
http://lists.ldsoss.org/mailman/listinfo/ldsoss
