Has anyone extend Ext.data.Store to provide greater RDBMS functionality?

[Nohcs777]

I have been looking around the forums looking for any threads where someone may have extended the Ext.data.Store to provide greater querying functionality. Initially I was hoping to find someone who may have written a SQL like query language for the Ext.data.Store that allowed for complex agregations, grouping, storing, subqueries etc. Additionally, hoping to find someone who had provided a extention to allow a store to host / handle multiple data sets and complex relationships / constraints.

I am not trying to build a data warehouse on the client but a normalized / relational data store could have some advantages even in the web service cashed / proxied implimentation.

Anyone seen this or had ideas on how to build it?

[alexbr]

You may (or may not) find http://www.codeplex.com/JSLINQ interesting.

[Nohcs777]

Thats a good start. I'll take a closer look at its capabilities.

Thanks.

[jay@moduscreate.com]

why would you want to do this in an extremly slow environment such as javascript?

[devnull]

why would you want to do this in an extremly slow environment such as javascript?
I could see the point in certain situations. One would have to consider the execution time cost vs the round trip time cost of local vs remote queries. Depending on connection speed, local (and for that matter remote) computing power, and complexity of the query, different situations could benefit from either senario.

[jay@moduscreate.com]

I understand what you're saying. Unless you're digesting extremely small data sets, in most cases, I'd keep multi dimensional sorting at the server side. Javascript is very slow. I wish the JS engines were faster.


here is a test example:

I am able to sort 1000 records faster on an oracle test host with a 1.8Ghz celeron with 512MB Ram vs. my desktop which is core2 duo 1.87Ghz with 3GB of RAM.