Leave a comment


 

arif said on August 18th, 2009 at 10:02 am :

Hello Rio,
Thank you for providing detailed analysis for different Grids and Tables. It is very informative. I am quite new to this concept. Can you please tell me what is the difference between Grid and Table.
Thanks again, Arif

I

 

J Singh said on October 18th, 2009 at 6:50 am :

Thanks for the list because it lets you make an overall judgment.

Another difference that needs to be highlighted is themability. I like DataTables a lot but it does not let users choose among the Themeroller themes.

So now I have second thoughts about DataTables :-(

 

J Singh said on October 18th, 2009 at 7:02 am :

Please reject my previous remark. DataTables does support themes.

Thanks.

 

joel caton said on June 12th, 2011 at 2:50 am :

I’m doing some research on the best grid to use and this great even though it is 2 years old. Thanks for posting it.

Jul 4, 2009 | Comparing jQuery grid and table plugins

I was curious what differences there were between AJAX grids and tables that were available for sorting, paging and otherwise organizing content for easy visualization. Here I’ve listed the three most popular ones, along with their differences.

jqGrid Flexigrid DataTables
Data format JSON, XML JSON, XML or existing data Existing HTML
Sorting Server-side (SQL ‘ORDER BY’). Multicolumn sorting supported. Server-side Client-side. Multicolumn sorting supported.
Pagination JSON/XML (server-side) Server-side Client-side
User/Auto resizing of columns Both Supported. Users can choose to hide columns. User only. Users can choose to hide columns. Auto only
Internation-alization Supported. Not supported. Supported.
JS file sizes (excluding jQuery) 300kB (some of which can be discarded based on application) 56kB 143kB
Advantages Extensive API and documentation Versatile, can wrap around HTML or used JSON/XML to populate grid Uses existing HTML structure to wrap around
Disadvantages Requires processing on server-side Relatively little documentation, most of the functionality only works with JSON/XML option Requires all the relevant data to be marked up as HTML

Verdict: As with all applications, each variant is suitable for a different solution. The fact that there are over 50 table plugins for jQuery is testament to how people see the need for developing new alternatives. jQuery is a powerful tool, but its use must also be weighed together with how much data you use – while server-side sorting and searching is usually very powerful and fast, it’s still a relatively expensive operation. Both jqGrid and DataTables have a lot of useful features (like grids withing grids, user-selectable rows and inline editing) with solid API documentation to support it. Flexigrid is good if you want something to work without too much hassles.

This entry was posted on Saturday, July 4th, 2009 at 12:02 am, EST under the category of Coding. Both comments and pings are currently closed.