Re: [IndexedDB] Proposal for async API changes

On Thu, May 20, 2010 at 11:25 PM, Shawn Wilsher <sdwilsh@mozilla.com> wrote:

> On 5/20/2010 7:34 AM, Shawn Wilsher wrote:
>
>> So far it's really just that joins are painful in IndexedDB. I'm working
>> on a blog post on this very topic though, and I'll be sure to point
>> everyone in this thread to it (I figure this is useful stuff to get out
>> to a wider audience).
>>
> And honestly, I thought that we had discussed joins on this list, but I
> only see a thread from Pablo mentioning it, but no real discussions. Should
> we start that?
>

Joins were actually in the original spec but taken out during the effort to
simply the API greatly.  IIRC, the main reason why Nikunj took them out is
that we believed you could fairly efficiently join yourself if you had 2
sorted lists and because we didn't see a simple way to do them without
introducing a lot of API surface area or creating (or borrowing) some sort
of syntax for the joins.  (Now that I think about it, though, maybe doing
this is not that big of a leap from what we're going to need to do to spec
keyPaths.  I'm starting to wonder if we need to rethink that as well....)

Anyway, the decision was made so long ago that maybe it's worth re-opening
the discussion.  I'll hunt through my mail archives tomorrow and start a new
thread with references to any original bits of info I can find.

J