I've created a module that marries DBI with AJAX to support LiveGrids - dynamically updateable portions of web pages that work like google maps. As you scroll through the grid, the contents are buffered on the client-side, and limited on the server-side and only small sections are refreshed at any one time. This means that very large databases (anything accessible via DBI) can be served without either querying or sending more than small chunks for each request.

You can create a LiveGrid server as a CGI or mod_perl script with just a few lines of perl code and create a LiveGrid client with just a few lines of JavaScript (included with the distro).

DBIx::LiveGrid is based on the open source Rico and Prototype AJAX libraries and optionally makes use of SQL::Abstract and SQL::Abstract::Limit to construct queries, limits, and offsets.

For a demo of a LiveGrid, see http://openrico.org/rico/livegrid.page.

For a bit more about the modules, see: http://www.perlmonks.org/?node_id=492067.

To grab the tarball: http://www.vpservices.com/jeff/programs/DBIx-LiveGrid-0.01.tar.gz

I'd value all comments and criticisms, namespace suggestions, etc.

--
Jeff

Reply via email to