On Tue, Sep 16, 2008 at 10:12 AM, Jason Rutherglen <[EMAIL PROTECTED]> wrote: >> SQL database such as H2 > Mainly to offer joins and be able to perform hierarchical queries.
Can you define or give an example of what you mean by "hierarchical" queries? A downside of any type of cross-document queries (like joins) is that it tends to limit scalability. Of course, I think it's acceptable to have some query types that only work on a single shard, since that may continue to cover the majority of users. Along the same lines, I think it would be useful to have a highly integrated extension point for stored fields (so they could be retrieved from external systems if needed). -Yonik