[Ldsoss] Database for FamilySearch OpenSource Client

[David Hale]

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 <John.Finlay at neumont.edu>
To: LDS Open Source Software <ldsoss at 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
 

john.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.
 







_______________________________________________
Ldsoss mailing list
Ldsoss at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ldsoss.org/pipermail/ldsoss/attachments/20070515/12e8160e/attachment-0001.html