W3C home > Mailing lists > Public > whatwg@whatwg.org > November 2007

[whatwg] SQL API and Transactions

From: Aaron Boodman <aa@google.com>
Date: Thu, 1 Nov 2007 10:05:26 -0700
Message-ID: <278fd46c0711011005l4aa7f485id4856668979b7e71@mail.gmail.com>
On 11/1/07, Scott Hess <shess at google.com> wrote:
> Hmm.  Is this because we're allowing for what SQLite calls BEGIN
> DEFERRED, rather than requiring BEGIN IMMEDIATE?  [I'm basing this on
> error code 5.]  In that case, yes, the above won't work.  I'd like to
> argue that BEGIN IMMEDIATE should be required, but I don't think
> that's at all portable.

I think most (all?) databases have some equiv of BEGIN IMMEDIATE.
Also, I'm thinking more and more that the standard should take a
firmer hand.

I haven't written this up yet, but something like explicitly only
allowing the SELECT,INSERT,UPDATE,DELETE statements. For creating
schema, you could have API that defines in terms of the standard DOM
datatypes (eg DOMString).

It would be up to the implementation to figure out what these
definitions mean in terms of the native types. I think in SQLite at
least, the conversion would be pretty straightforward. Seems like it
would give some flexibility to the other dbs and give a real shot at
interoperability as well.

- a
Received on Thursday, 1 November 2007 10:05:26 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Wednesday, 30 January 2013 18:47:42 GMT