On 2010-07-30 21.31, Paul Merlin wrote:
Just to keep you informed.

Stanislav and I are currently refactoring theses projects in order to use java-
sql-dsl for SQL generation : http://github.com/stazz/java-sql-dsl

So if you did not have time to look at the code yet, please wait until we're
done with the refactoring. It will be much easier to read then :)

One more thing: the Good Thing about having an SQL store is that it makes Qi4j apps fit better in traditional environments, and makes it easy to decouple app from store servers. Backups become easier, if you know how to backup the database. The Bad Thing is that latency to read from database is higher than compared to JDBM.

I've been looking at Ehcache the past week for use in StreamFlow, and it's really easy to use. It would probably be a great idea to add Ehcache to the SQL EntityStore as an integrated part, and make it a read-through/write-through part. Then writes would go down to the database (either using write-through or write-behind), and reads could a lot of the time come from Ehcache, especially if overflow-to-disk is used. That would get us the best of both worlds.

Same reasoning applies to the S3-store really.

/Rickard

_______________________________________________
qi4j-dev mailing list
[email protected]
http://lists.ops4j.org/mailman/listinfo/qi4j-dev

Reply via email to