RE: RFC : AJAX + DBI = DBIx::LiveGrid

Jeff,

Nice one.

However, it does not quite work with my DBD and database. What I see is the
first 70 rows repeated as I scroll through the table. The SQL being executed
does not seem correct:

select * from
(
select top 70 * from
(
select top 70 col,col from table
) as foo
) as bar

then when you go past the 70th row I get variations like:

select * from
(
select top 70 * from
(
select top 350 col,col from table
) as foo
) as bar

which obviously returns the same first 70 rows.

I'm investigating. I think the issue may be in SQL-Abstract-Limit. Do you have
any ideas?

Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development


On 14-Sep-2005 Jeff Zucker wrote:
> 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
.

Relevant Pages

  • Re: Bit surprised there arent more virtual listbox controls/code available
    ... How about stick the MIDI data into a recordset then as a listbox can only ... would scroll the list as if it was a normal full listbox. ... You mean, display, say, 20 rows in the list box (e.g events 0 through ... processing would be standard database stuff. ...
    (microsoft.public.vb.general.discussion)
  • Re: Copy/Highlight Content
    ... highlight below the end of the window the same thing happened. ... The issue is to copy and scroll beyond the bottom of the window and stop at ... Hmmmm, this isn't a normal indication of database corruption, but we need to ...
    (microsoft.public.mac.office.entourage)
  • Reloading and Editing UserForms in Excel - help!
    ... I have created a database in Excel for a client to do data entry. ... Right now I have multiple forms set up that they can scroll through ... the data at a later time, edit it, and their changes would be saved ...
    (microsoft.public.excel.programming)
  • Re: Copy/Highlight Content
    ... highlight and say copy it I can not get the page to scroll down past the ... and highlight in all my other applications like Word and Safari. ... Hmmmm, this isn't a normal indication of database corruption, but we need to ... then you need to rebuild your database. ...
    (microsoft.public.mac.office.entourage)