Pow-LiveGrid

From PlainOldWebserver

Jump to: navigation, search

Rico's LiveGrid with SQLite: the Pow's way !

--Emchem 05:02, 12 April 2007 (PDT)

Rico [1] is an AJAX toolkit which offers some very interesting widgets. One of them, the LiveGrid, display a scrollable view of a database table, using paging technique (i.e. it sends ajax live calls to the database server whenever you're scrolling the grid, in order to refresh the display).


The Rico LiveGrid's demo provides a working example of this grid widget acting as a front end for a SQLite database. Pay attention to the "bookmark" link and to the sort by column.

A movie table sorted on 'genre'


Download the pow livegrid demo here: [2]


Installation:

  • extract the zip file in htdocs directory
  • then go to the url: [3]


WARNING !!! : For this demo to run, you must first apply the xml serving bug solution available here .

---

Resources:

  • The Rico's livegrid demo: [4]
  • The Rico's livegrid tutorial : [5]
  • SQLite Database Browser : [6] (a tiny but powerful SQLite manager)
Personal tools
Navigation