[Ldsoss] Database for FamilySearch OpenSource Client

[John Finlay]

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.h
tml 

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 <http://www.neumont.edu/> 

john.finlay at neumont.edu <mailto:mjohn.finlay at neumont.edu> 

 

From: ldsoss-bounces at lists.ldsoss.org
[mailto:ldsoss-bounces at lists.ldsoss.org] On Behalf Of Gordon Clarke
Sent: Friday, June 15, 2007 8:51 AM
To: LDSOSS at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ldsoss.org/pipermail/ldsoss/attachments/20070515/dd8727e3/attachment.htm