I’ve been on the lookout for a good AJAX DataGrid component for some time now, hoping to find one that I can add to my bag of tricks. Most data-driven web applications need to show data in a table or grid at some point or another. There are quite a few for .NET programming, but if you just want the JavaScript to plug into your app, there are not as many choices.
Writing a flexible and powerful AJAX DataGrid is a complicated task and, speaking for myself, not one that most developers will want to tackle. Using a 3rd party component makes a lot of sense. However the commercial vendors of AJAX DataGrids out there are charging ridiculous amounts for licensing. I’m sure these prices will come down to Earth as more open source options become available.
The most promising open source DataGrid I’ve found is the Rico LiveGrid at www.openrico.org. But from what I can tell, it’s a read-only display of data. I could be wrong about that, but I haven’t seen any example code to show edit capability with LiveGrid.
The most most impressive commercial DataGrid in my opinion is the nitobi Grid at www.nitobi.com but it’s not exactly cheap. If anyone knows of any other options out there and/or has a preference for one of these, please leave some feedback. I’d be interested to read some other opinions.
| Name | Active Widgets Grid | Zapatec Grid | nitobi Grid V3 | dhtmlxGrid |
|---|---|---|---|---|
| URL | visit… | visit… | visit… | visit… |
| License | ||||
| Type | Commercial | Commercial | Commercial | GPL, Commercial |
| Per Seat Cost | $395.00 | NA | $489.00 | $149.00 |
| Per Server Cost | NA | $59.00 | NA | NA |
| Unlimited Server Cost | $2,450.00 | $799.00 | NA | NA |
| Distribute w/ My App Cost | NA | $1,199.00 | NA | NA |
| Source Included | Yes | Yes | Only with $3,699 Enterprise Edition | Yes |
| Trial Download | Yes | NA | Yes | NA |
| Free Version | No | Yes, “Lite” | No | Yes, GPL |
| Free/Trial Version Limitations | Honor System? | Link required, Non-removable “About” button in grid | Reg. Required, 30 Day Limitation | Feature Limitations |
| Technical | ||||
| Browsers | IE6+ FireFox (Safari TBA 2006) | ? | IE 6+, FireFox 1+, Camino 1.3+ | IE5+, FireFox 0.9+, Safari 1.3+ |
| How Data Loaded | JS Array, CSV, XML | HTML, XML, JSON | XML, JS API | |
| Features | ||||
| JIT Rendering (Scroll) | Yes | No, but has “Slider” pagination control | Yes | Pro Version Only |
| Edit In Place | Yes | Yes | Yes | Yes |
| Input Controls | ? | Yes | Yes | Pro Version Only |
| Sortable Rows | Yes | Yes | Yes | Yes |
| Resize Columns | Yes | No | Yes | Yes |
| Frozen Columns | Yes | Yes | Yes | Yes |
| Notes | Includes various user controls like sliders, buttons, etc. | Charts feature for customized output display | Copy/Paste multiple cells, to-from Excel. | Interesting “TreeView” Grid |
Terminology:
JIT Rendering: “Just in Time” rendering is the ability to show part of your data and load more dynamically as you scroll down.
Edit in Place: The ability to click on a cell and edit the data with no page reload
Input Controls: The ability to use drop-downs, checkboxes, etc when editing in place.
Frozen Columns: The ability to allow scrolling through your records but keep a column or row “frozen” as you can in Excel.
#1 by Thijs on November 23rd, 2006
You might want to try this one: http://www.xml.com/pub/a/2006/08/23/xsldatagrid-xslt-ajax.html
I have not yet got it to work, but it looks promising!
#2 by Jason on November 27th, 2006
Hey Thijs, I had actually looked at that one as well and I like their way of thinking a lot. I like any solution where the data is structured and the presentation is separate from that. It seems like this particular code is still in the concept phase as far as I can tell, but I am going to keep my eye on it. Thanks for the comment!
#3 by Andre Charland on December 4th, 2006
Thanks for putting this together and the kind words on the Nitobi Grid. We’ve been working on it for long time:) Just a heads up we’re adding grouping / treeview functionality into our grid, been in the works for a while with some beta customers. Also, we’re releasing a suite early in 2007 which will bring the per component cost down quite a bit for the community.
I’m curious why you haven’t included offerings from Ajax component vendors like Infragistics, Backbase or Telerik?
Do you develop mainly in .Net on the backend?
Thanks!
#4 by Jason on December 4th, 2006
Hi Andre, Thanks for the message – you guys make a great product! I actually only included links on this page for non .NET products. Though I do use .NET, in this case I’m looking for a PHP solution. So, I didn’t include the ones that only have a .NET version. But, I will check out the companies that you mentioned.
#5 by Andre Charland on December 4th, 2006
Thanks Jason. We’ve always felt supporting multiple backends is very important. That’s why we were so excited to get .Net and Cold Fusion support in this fall. We have a PHP backend, what did you think of that? What IDE are you using for development? And I’m guessing it’s MySQL for the DB? I’m also curious since you’re looking for a JavaScript component whether you have a preference for XML or JSON?
Finally, one last question, what would you consider a down to earth price for this type of product?
#6 by Jason on December 5th, 2006
Hi Andre, Well first thanks for your interest in my humble opinion! I use Visual Studio for most of my development. For PHP I use JCX Software’s vsPHP plugin which is awesome. For my own personal work, I choose the LAMP/WAMP platform because it has the widest install base and the least hassle. When I’m working for a client, the sky is the limit – I work with about everything – Oracle, MS SQL, Java, C#, etc. So your support for all of those things is nice because I could theoretically learn your product and use it in all of my work.
As far as XML or JSON. hmm… XML is tempting because I can imagine a generic back-end with a replaceable presentation layer. But on a practical level you want the grid to be as responsive as possible. JSON is probably the pragmatic choice.
As far as price, that is a tough question. I think $399 for a component puts you definitely into the corporate price range for developers like myself who would buy it for work. I do like the fact that there is unlimited deployment for that price. I think it’s a fair deal. It just hurts a little to shell out that much cash unless the company is footing the bill.
I think there are two groups of developers you’re filtering out with that price – the freelancers and the OSS guys. You’ll never get OSS guys with a commercial product. If you want to go after the freelancers, though, I think there is a sweet spot around $99. I bet you would see more sales, but your support costs would go up as well. If you can make something work at that price, I think you guys would get a lot more customers.
Thanks for stopping by!
#7 by Ivan on June 2nd, 2008
The simplest way I’ve found to generate online xml that can feed your ajax datagrid is using this web app. http://www.simplesa.net
#8 by Divid Zhang on July 16th, 2008
sigmagrid http://www.sigmawidgets.com
displaytag http://displaytag.sourceforge.net
eXtremeComponents http://www.extremecomponents.org
#9 by Thomas Fouracc on July 17th, 2008
Hello,
I see you mention Nitobi as expensive, I purchased all, I found the grid very good, the only thing that let down the entire collection was the Combomenu, It was very buggy and left me with a bad taste in my mouth with regards to Nitobi products. I also found that Nitobi support can take up to 4 weeks for responce.
I am not debasing Nitobi, only passing an observation.
Regards
Thomas