Just dumping a few links to some prototype Open Source projects I’ve run into recently, which are notable both because they’re pushing the frontiers and because looking at the code gives cause for optimism.
http://phprestsql.sourceforge.net/ – publish your MySQL database directly via PHP as XML, with nice friendly URLs (although can we eliminate the ‘?’).
Initial issues that spring to my mind here, without having looked too deeply
– paged result sets? Without them what happens when you have many rows…
– tag naming. Do we want tags called ‘table’ and ‘row’. Keith recently raised what may be a related question here – replace ‘table’ with the plural (e.g. ‘users’) and ‘row’ with the singular (e.g. ‘user’)?
http://xulrecordset.sourceforge.net/ – “xulRecordset is a project to create XUL widget library with a recordset behaviour.”. What’s cool about this is the way it uses XBL to extend the XUL tagset and make the record set easy to work with (plus it’s also using JPSpan so yet more bias). The remote API is probably too fine grained right now for decent performance – added my thoughts here but think the general notion is a big step in the right direction.
Speaks for itself.