[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