[whatwg] Asynchronous database API feedback
Dimitri Glazkov
dimitri.glazkov at gmail.com
Wed Dec 12 09:37:44 PST 2007
.. Speaking of batches, in my adventure of implementing the new SQL
spec, it looked like the transaction callback is mostly a functional
equivalent of a queue.
So, one idea would be explicitly make it an queue-like structure,
rather than a function callback:
var db = openDatabase('test');
var tx = db.createTransaction();
tx.add(db.sql('create table if not exists chickadees(name text, kind text)'));
tx.add(db.sql('insert into chickadees values(?, ?)', ['moesha',
'black-capped']));
tx.add(db.sql('select * from chickadees', [], function(rs) {
console.log(rs.rows.name); }));
tx.execute(function(error) {
console.log('bird flip!');
});
.. in which case single statements could be executed as:
db.sql('select count(*) as count from chickadees', [], function(rs) {
console.log(rs.rows.count); }).execute();
What do you think?
:DG<
More information about the whatwg
mailing list