Re: [web2py] Powertable remarks

2010-12-20 Thread Ivan Matveev
Thank you Bruno for this beautiful SQLTABLES drop in replacement. Joined Rows, virtual fields on Rows work! You saved my week. Looks great and I love client side sorting and searching. On small(hundreds of rows) its faster than server side.

Re: [web2py] Powertable remarks

2010-12-20 Thread Bruno Rocha
Hi Ivan, Thanks for testing the plugin. I am finishing some features that will be added this week Filtering by fields Edit button opens a default crud.update form in details Add button at the top opens a crud.create form Progressive scrolling Datatables updated to version 1.75 Internet Explorer

Re: [web2py] Powertable remarks

2010-12-18 Thread Bruno Rocha
jqGrid also supports progressive loading (without paging , it does ajax to load while scrolling down). I do not see those features exist in datatables. Just got progressive loading working on powerTable plugin powerTable.dtfeatures['bScrollInfinite'] = True

[web2py] Powertable remarks

2010-12-17 Thread Johann Spies
I have downloaded Powertable and like most of what I see. What I like: * The ability to use more datasources than just a table and a single-column query. * The layout which is more readable and understandable than jqgrid from plugin_wiki I have certain questions and concerns though: * Is

Re: [web2py] Powertable remarks

2010-12-17 Thread rochacbruno
Hi, thank you for testing the plugin. I am writing the documentation explaining every option of the API. In this First alpha release only client side is available, the table is entirely loaded to the client, which is really not usable if you has more than 500 rows. I am working right now on

Re: [web2py] Powertable remarks

2010-12-17 Thread Phyo Arkar
* I have tested it this morning on a table with more just over 8200 entries and it took 70-90 seconds on Firefox and 30-35 secondes no Chrome to reload the page from localhost. That is not usable. Plugin_wiki's jqgrid does this in less than a second. It seems that it loads the whole table

Re: [web2py] Powertable remarks

2010-12-17 Thread Martín Mulone
You fetch 8200 records, this is not good for the server side and client browser. Perhaps need some tutorial about pagination or integrated with the plugin. 2010/12/17 Johann Spies johann.sp...@gmail.com: I have downloaded Powertable and like most of what I see. What I like: *  The ability to

Re: [web2py] Powertable remarks

2010-12-17 Thread rochacbruno
WIth jqgrid even without paging , i had successfully loaded 40k records within 6 - 8 secs . That is because jqgrid loads limited amount of data per request, i am doing this with datatables. And I am working to incorporaye it to the plugin.

Re: [web2py] Powertable remarks

2010-12-17 Thread Phyo Arkar
That is because jqgrid loads limited amount of data per request, i am doing this with datatables. And I am working to incorporaye it to the plugin. Nope , i did loadonce option which load all records atonce. and my database now is 500k records+ On 12/17/10, rochacbruno rochacbr...@gmail.com

Re: [web2py] Powertable remarks

2010-12-17 Thread Bruno Rocha
Nope , i did loadonce option which load all records atonce. and my database now is 500k records+ Is it loading all this records into a JSON? I just tested 20k of data loaded in to Java Script Array with this approach http://www.datatables.net/examples/data_sources/js_array.html Works

Re: [web2py] Powertable remarks

2010-12-17 Thread Branko Vukelic
- Original Message - From: rochacbruno Sent: 12/17/10 01:38 PM To: web2py@googlegroups.com Subject: Re: [web2py] Powertable remarks WIth jqgrid even without paging , i had successfully loaded 40k records within 6 - 8 secs . That is because jqgrid loads limited amount

Re: [web2py] Powertable remarks

2010-12-17 Thread Bruno Rocha
- Original Message - From: rochacbruno Sent: 12/17/10 01:38 PM To: web2py@googlegroups.com Subject: Re: [web2py] Powertable remarks WIth jqgrid even without paging , i had successfully loaded 40k records within 6 - 8 secs . That is because jqgrid loads limited amount of data per

Re: [web2py] Powertable remarks

2010-12-17 Thread Branko Vukelic
- Original Message - From: Bruno Rocha Sent: 12/17/10 03:08 PM To: web2py@googlegroups.com Subject: Re: [web2py] Powertable remarks Nice library! I didn't know http://demo.qooxdoo.org/ Well, check out their tag line on the homepage http://www.qooxdoo.org/. It's not a lie

Re: [web2py] Powertable remarks

2010-12-17 Thread Bruno Rocha
Just wanted to add a detail: I have not started to develop the plugin to replace or compete jqGrid. I do not use jQgrid just because I do not like its layout and i've never read its documentation. JqGrid or webgrid does not use PluginManager() to config grid option, and I like the way we do with

Re: [web2py] Powertable remarks

2010-12-17 Thread ron_m
This is a tiny nit pick so my apologies in advance but I thought it might be worth mentioning. I went to the demo page, picked Products and hit the green plus to open the details on the last item in the list. The control turned red but nothing else appeared to happen. Second time I noticed a

Re: [web2py] Powertable remarks

2010-12-17 Thread rochacbruno
I noticed a scroll bar activated on the right side of the form and sure enough if you scroll down there it is. I don't know how difficult it would be to expose the part that opened if it is out of the current view area. I'll try to bring it up to the viewport. Thank you for mentioning.