[infinispan-dev] Fwd: Remote Querying DSL Design Discussion

[Mircea Markus]

Some more client feedback on the query DSL/functionality.

Begin forwarded message:

>> Thanks for sending this through. We have a few suggestions around functionality that we've found very useful in the past, but otherwise it looks promising.
>> 
>> 1. Query on keys or portion of keys
>> 
>> 2. Ability to query on unindexed attributes

We had this in mind, but I don't think this functionality will make it in the first release (ISPN 6.0)/ 

>> 
>> 3. the ability to specify a custom filter is potentially useful to implement missing or business logic, although in practice you may be able to construct these with the given filters. 
>> Example: Filter out currency values older than X if the time is between 10am and 11am 

something to consider.

>> 
>> 4.  The ability to specify a custom extractor which could be used to extract a portion of stored data or manipulate it before comparison.
>> Example : data is being stored as an array and we're interested in the Nth value in the array -> this is a requirement from a previous project
>> 
>> 5. equality and range filters should also include the "andEquals" options: lessThanEquals, greaterThanEquals

+1

>> 
>> 6. all(List) and any(List) functions are easier to use than chaining together and() and or() statements

+1

>> 
>> 7. I'd suggest with() rather than having() as this is closer to SQL syntax, which has a different meaning for HAVING
>> 
>> Do queries require that the entire object be deserialised before the filter can be evaluated or do you compare on deserialised index values? 
>> This is potentially quite slow, and requires that matching Java classes are provided on the server side even if the client is .NET
>> 
>> Rob
>> 
>> 

Cheers,
-- 
Mircea Markus
Infinispan lead (www.infinispan.org)




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/infinispan-dev/attachments/20130722/2bb2cb49/attachment.html