- From: Jeremy Orlow <jorlow@chromium.org>
- Date: Thu, 20 May 2010 10:55:20 +0100
- To: Shawn Wilsher <sdwilsh@mozilla.com>
- Cc: Jonas Sicking <jonas@sicking.cc>, Webapps WG <public-webapps@w3.org>
Received on Thursday, 20 May 2010 09:56:13 UTC
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 UTC