http://qs1969.pair.com?node_id=492101


in reply to Re: RFC : AJAX + DBI = DBIx::LiveGrid
in thread RFC : AJAX + DBI = DBIx::LiveGrid

would it be possible to decouple the LiveGrid interface from DBI?
It already is that way :-). By default the module uses DBI and SQL::Abstract to return an AoA (e.g. from selectall_arrayref) but I make it explicit that you can generate the AoA any way you'd like (with or without DBI), as long as you remember to do things like check the user's request values before sending them somewhere dangerous. As long as you build this AoA yourself and don't call the query_database() method, the module will happily work without DBI. The same is true for its XHTML building and XML cleaning routines - if you don't like the built-ins, just substitute your own. The curtailed synopsis above shows only the run() method, but for finer control you create a liveGrid object with new(), which does not take $dbh as a parameter.