dojo 1.0 database table browsing demo

Submitted by afryer on Tue, 11/13/2007 - 08:23.

Dojo Showcase

I have finally got the dojo 1.0 version of the database grid widget up and running. The new demo is here...

http://www.cyberavenue.com.au/resources/majalin/tests/test_Navigator.htm...

DataStore Features

custom dojo data store implementation fully implements the read, write, identity and notification apis. You can not only browse table data but create, update and delete as well. Hooks seemlessly into the dojo combo box and filtering selects. Provides additional functionality in addition to the api functions like

the ability to specify SQL filtering in addition to the standard data store filtering. This means you can use OR conditions which isn't possible with the standard data store query functionality.

Example of specifying an SQL filter...
store.fetch( { query: "equipGrpId LIKE 'S-NS%' or functionCode >= 'M0042'" } );

Example of using standard dojo data filtering...
store.fetch( {query: {equipGrpId: "S-NSP*"} } );

a count function to find out how many rows exist for a given filter.

Example of counting a result set...
store.count( { query: "equipGrpId = 'G-POLECONC'" } );

access to table meta data including column titles, property names, property types (ie. string, date, integer etc.)

The data store in this demo is using a server which is xdomain. It's simple to enable or disable a xdomain datastore with a single 'xdomain' attribute when defining the store...

The server side is powered by hibernate and can run against any database supported by hibernate. A demo at http://weblogic.cyberavenue.com.au/Majalin/Admin demonstrates oracle, mysql and postgresql table browsing and editing

Table Features

The ability to filter columns by clicking on the filtering icon in the column headers (looks like a diamond)

The ability to sort columns by clicking on the column title text

NEW: the ability to resize column headers with instant resize feedback which differs from the way the dojox.grid handles column resizing

NEW: ResultSets are counted asyncronously and only when the filter changes. This improves server side and client side performance considerably since counting can be an expensive operation. If it does take a long time on the server, the user can still page through the results but the last page button will not work until the count is returned.

Any feedback is appreciated.

Login or register to post comments
Subscribe post

really neat!

Submitted by alex on Wed, 12/12/2007 - 20:23.

Wow, sounds like a really impressive bit of work. Unfortunantly it's not coming up from the linked URL. Is the server perhaps experiencing an outage?

--
Project Lead, The Dojo Toolkit 
President, The Dojo Foundation

availability

Submitted by afryer on Wed, 12/12/2007 - 23:29.

It's running on my home pc which I've been powering down at night lately. Also since I'm in Australia this means its been down during the day US time. I'll keep my PC powered up overnight for the next week or so.

This is a work in progress. The latest demo using more of dojo and ajax is here...

http://weblogic.cyberavenue.com.au/Majalin/Console.jsp

In my opinion this type of app is where the dojox.grid should be really handy, but I don't quite find it lightweight or performant enough hence I've had to roll my own grid for now.