W3C home > Mailing lists > Public > public-webapps@w3.org > April to June 2010

Re: [IndexedDB] Proposal for async API changes

From: Jeremy Orlow <jorlow@chromium.org>
Date: Thu, 20 May 2010 10:55:20 +0100
Message-ID: <AANLkTilHZkLNpUblAvx1bD7JLbnFx5-Mw0wIQq6VJOgb@mail.gmail.com>
To: Shawn Wilsher <sdwilsh@mozilla.com>
Cc: Jonas Sicking <jonas@sicking.cc>, Webapps WG <public-webapps@w3.org>
Thanks for taking the time to do this!

Can you maybe discuss the pros and cons you found in terms of implementing
something in WebSQLDatabase vs. IndexedDB?  I'm mainly interested in seeing
if there's any thing we can improve in IndexedDB that WebSQLDatabase already
does well.

J

On Wed, May 19, 2010 at 10:03 PM, Shawn Wilsher <sdwilsh@mozilla.com> wrote:

> On 5/19/2010 1:50 PM, Shawn Wilsher wrote:
> Er, and I managed to botch the SQL in the last two examples.  Those should
> be (if my non-tested SQL-fu is right):
> SELECT name, COUNT(kids.id)
>
> FROM kids INNER JOIN candySales
> ON kids.id = candySales.kidId
> GROUP BY kids.id;
>
> and:
> SELECT name, COUNT(kids.id)
>
> FROM kids LEFT JOIN candySales
> ON kids.id = candySales.kidId
> GROUP BY kids.id;
>
> respectively.
>
> Cheers,
>
> Shawn
>
>
Received on Thursday, 20 May 2010 09:56:13 GMT

This archive was generated by hypermail 2.3.1 : Tuesday, 26 March 2013 18:49:38 GMT