- From: Aaron Boodman <aa@google.com>
- Date: Thu, 1 Nov 2007 10:05:26 -0700
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 UTC