ISSUE-36: Client side database storage SQL statement support

client-side-storage-sql

Client side database storage SQL statement support

State:

CLOSED

Product:

HTML 5 spec

Raised by:

Shawn Medero

Opened on:

2008-02-19

Description:

__This issue may depend on the resolution of ISSUE-16 (Is the offline application spec within scope?)__

Should the client-side database storage section of the specification clearly outline what SQL statements _must_ be supported by implementors?

If so what are the MUSTs vs. SHOULDs?

Raised by Mikko Honkala via email:
http://lists.w3.org/Archives/Public/public-html/2008Feb/0288.html

> The current spec only notes: "Note: A future version of this
> specification will probably define the exact SQL subset required in more
> detail".
> http://tinyurl.com/23d324

> 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.

## Proposals

Mikko Honkala suggested:
http://lists.w3.org/Archives/Public/public-html/2008Feb/0288.html

> 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
> search:
> http://code.google.com/apis/gears/api_database.html#sqlite_fts
> http://www.sqlite.org/cvstrac/wiki?p=FtsTwo
>
> And making BEGIN/COMMIT/ROLLBACK no-ops, since transactions are
> built-in to the API.

Related Actions Items:

No related actions

Related emails:

1. Issues closed (from mjs@apple.com on 2009-08-20)
2. {agenda} HTML WG telcon 2009-08-20 (from rubys@intertwingly.net on 2009-08-19)
3. Old issues - will be closed on 2009-08-20 if there are no objections (from mjs@apple.com on 2009-08-13)
4. ISSUE-36 - client-side-storage-sql (from mjs@apple.com on 2009-08-13)
5. Re: {agenda} HTML WG telcon 2009-08-13 (from cooper@w3.org on 2009-08-12)
6. Re: {agenda} HTML WG telcon 2009-08-13 (from singer@apple.com on 2009-08-12)
7. {agenda} HTML WG telcon 2009-08-13 (from rubys@intertwingly.net on 2009-08-12)
8. More suggested issues to close (from mjs@apple.com on 2009-08-12)
9. minutes HTML WG weekly 21 Feb (from connolly@w3.org on 2008-03-09)
10. ISSUE-36 (client-side-storage-sql): Client side database storage SQL statement support [HTML 5 spec] (from sysbot+tracker@w3.org on 2008-02-19)

Related notes:

Display change log