W3C home > Mailing lists > Public > public-html@w3.org > February 2008

SQL subset definition ( 4.11. Client-side database storage )

From: <mikko.honkala@nokia.com>
Date: Mon, 18 Feb 2008 17:08:14 +0200
Message-ID: <72FEB86533D5F643882E15DB52FEE75F043434D4@esebe105.NOE.Nokia.com>
To: <public-html@w3.org>

Hello group,

I would like to kick off the discussion of the SQL subset in 4.11. 

The current spec only notes: "Note: A future version of this
specification will probably define the exact SQL subset required in more

This is not a good position, especially since implementations are
starting to pop up. On a high level, we need requirements and further
proposals for the subset that is going to get specified as a MUST level
requirement in the spec.

We have at least three things as a starting point:

1. Google Gears

2. WebKit Nightly Build DB Storage Implementation

3. The SQL subset supported by SQLite

All of these build on top of SQLite, which is in my opinion a valid
starting point, even on mobile devices. There are presumably differences
even with these three starting points.

One difference, which I am aware is whether the full-text search
extension is enabled or not (it is is Gears, but not to my knowledge in
WebKit nightly). I would very much argue that full-text search is an
essential requirement for HTML5 client-side database API, since it is
pretty heavy to implement the functionality in JavaScript. Comments?

So in minimum I propose having an issue in issue tracking system for
this, and would call for people who care about the client-side storage
to contribute to this topic.

My kick-off proposal would be to start with the number 3 : "The SQL
subset supported by SQLite", combined with their support for full - text
And making BEGIN/COMMIT/ROLLBACK  no-ops, since transactions are
built-in to the API.

Best Regards,
  Mikko Honkala
Received on Monday, 18 February 2008 15:08:54 UTC

This archive was generated by hypermail 2.3.1 : Thursday, 29 October 2015 10:15:30 UTC