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