On Tue, Nov 30, 2010 at 2:15 PM, Michael MacFadden < [email protected]> wrote:
> All, > > I was curious if there was any interest in a persistence module that > would store accounts, deltas etc in a SQL database (mysql, postgresql, > etc). Thanks. > > ~Michael > I have a lot of interest in this as well. I've attached a data model I created last year. I tried to balance several factors (normalization, space etc...) in the model. For example, instead of using the actual waveid/waveletid as foreign keys, I used a bigint: possibly an unnecessary optimization/complication. We may want to consider using JDO <http://db.apache.org/jdo/> (supports JDO and JPA) and Derby <http://db.apache.org/derby/> as a starting point. Toss in a cache (e.g. ehcache, etc...) to add scalability. -Tad
