http://www.flexigrid.info/
Just come across this, and will be implementing in the back end of our site.
What the developer says:
Lightweight but rich data grid with resizable columns and a scrolling data to match the headers, plus an ability to connect to an xml based data source using Ajax to load the content.
Similar in concept with the Ext Grid only its pure jQuery love, which makes it light weight and follows the jQuery mantra of running with the least amount of configuration.
Features
* Resizable columns
* Resizable height and width
* Sortable column headers
* Cool theme
* Can convert an ordinary table
* Ability to connect to an ajax data source (XML and JSON[new])
* Paging
* Show/hide columns
* Toolbar (new)
* Search (new)
* Accessible API
* Many more
I'm planning to add an Editable and Resortable rows feature, as well as other cool GUI features.
One of my main goal for the plugin is ultimately to keep it lightweight, maybe under 20k when compressed. Because otherwise you should probably stick with Ext Grid or YUI data table.
Rupert, G is indexing ajax pages now if you follow their quasi-beta protocol.
Try site:bookwhack.com +"!#"
G's spec here: http://code.google.com/web/ajaxcrawling/docs/specification.html
thx Guys. I will be using it in the back end part the customers never see, but that is relevant to me elsewhere RC.
Google surfing Ajax now eh? Well I only build my site with a million pages so that I could point my customers at an exact page with their sizes selected... nothing to do with google of course :)
>only build my site with a million pages
Sounds like it's worthwhile to try the ajax setup. I can't see any harm.
Yes, we Ajax for the user too :)
is anyone actualy using Googles workaround? I know its been around for a year or so now (unless this is a new one?) and I thought at the time it looked like a really bad solution to the problem - although I can't code more than the basics so perhaps I'm missing something? Would you not just be better making static url's if you really really need indexable ajax?
My other problem was it doesn't solve the problems for Yahoo and Bing anyway. Yeah I know, who cares, but I'd rather at least get sites indexed everywhere if possible.
RC, Tried to sticky you, did you get it?
OK, maybe I'm stupid. But it just looks like a database. With a hook that allows an easy way to dump an xml feed into it.
Am I wrong?
the issues I have had with some of the grids is some load the full dataset everytime and when you page through they load it again, and again
aside from that they're kinda purty when they don't load 30k records to show 10
Heather, no, I thinks that's right.
jatar_k is there a way round that?
We are trying to reduce the calls to the database, so the start is (as I understand it) to put the base data required into a separate table, so we dont have to call 30,000 lines every time.
We have a table with 10 items in it, and if something in the 30,000 changes, then that table of 10 is edited.
I guess we know we only want "live" data, not all of it in our case. Not being a data expert, I really have no idea what I am talking about, just what I understand of how it has been explained to me :)
for this style of paging where you don't hit the db for every 10 items and reload the whole page you need some type of caching but really it depends on how slow the queries are, if db traffic is an issue it may be you need more server or it may be innefficient queries, hard to say
tsome solutions load the whole shootin match and then page them which works for middling sizes, what that means depends on too many things
essentially if you feel it's slow then you need to change something, jquery is less about efficiency (my opinion after viewing a bunch of implementations) than it is about pretty. The cool thing with only changing a div is the user still has stuff to look at, not a blank screen waiting for a page to load, so long as the user feels like they are in control (less than 1 sec loads) then you're fine
At the mo, we are, as I understand it, pulling too much on the DB. A part of the implementation is to speed things up, a part to make it look pretty.... that's Richard, the programmer :)
Quote...need more server ...
ah if only I knew when the server is overloaded :) But that is another day.
Thanks for you feedback jatar_k... appreciated.
Thanks for that, looks good. Have passed it to the coders.