Good idea. Some comments on the actual implementation. I don't think JDO supports JPA. But there's Apache OpenJPA that does - http://openjpa.apache.org/ . There's also Apache Cayenne ORM - http://cayenne.apache.org/ for which I can vouch personally as one of its authors (and also can help with the implementation). It has pretty good caching integration. I've deployed Cayenne with OSCache on very active DB-driven sites, like nhl.com.
Andrus On Dec 8, 2010, at 2:39 AM, Tad Glines wrote: > 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 (supports JDO and JPA) and Derby as a > starting point. Toss in a cache (e.g. ehcache, etc...) to add scalability. > > -Tad >
