Re: [web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Richard Vézina
d3js seems a good horse to bet on him in the long run, I mean it is there to stay and offer a lot of feature... But I didn't compare neither. But there is not that much plot js in open source that offer all the goodies of highcharts Richard On Tue, Oct 22, 2013 at 10:13 AM, Thomas S wrote: > T

Re: [web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Richard Vézina
file_name come from your field : db.table.field.upload_field Here my field definition : Field('picture', 'upload', uploadseparate=True, autodelete=True, label=T('Profile image'), represent=lambda value, row: image_chooser(value, row, '360px', '360px') ), You can read the fu

Re: [web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Thomas S
There are tons of such JavaScript based applications for plots. I have not compared them but flot seems to do the job. web2py is using flot for some graphs. What I meant with Java tools is that it's quite complex to write and read hdf files in Java applications. Unfortunately I have to use Java

Re: [web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Richard Vézina
request.application ?? On Tue, Oct 22, 2013 at 10:01 AM, Thomas S wrote: > Yes, I use HDF5 for more than a year now. > It's great. The only drawback is the lack of elegant Java tools. > I upload those files and store their obfuscated names in a database, but > the actual file in uploads. > Havin

Re: [web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Richard Vézina
You actually store the file name in database? if file_name != '' and file_name is not None: image_dir = db.auth_user[field].retrieve_file_properties(file_name)['path'] img = Image.open(os.path.join(image_dir, file_name)) :) Richard On Tue, Oct 22, 2013 at 10:06 AM, Richard Vézi

Re: [web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Richard Vézina
There is also : http://d3js.org/ :) Richard On Tue, Oct 22, 2013 at 10:04 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > request.application ?? > > > On Tue, Oct 22, 2013 at 10:01 AM, Thomas S wrote: > >> Yes, I use HDF5 for more than a year now. >> It's great. The only drawback is

Re: [web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Thomas S
Yes, I use HDF5 for more than a year now. It's great. The only drawback is the lack of elegant Java tools. I upload those files and store their obfuscated names in a database, but the actual file in uploads. Having said that it's not very elegant to construct the URL to locate the file: def sho

Re: [web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Richard Vézina
I heard a lot of good about HDF5 file format to hande important volume of data hierachical (mean you can query what ever data you need without load the full data set into a json for instance) : http://en.wikipedia.org/wiki/Hierarchical_Data_Format It very much faster then postgres (sure postgres i

[web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Cliff Kachinske
use the rows field in auth_permission as described here. http://web2py.com/books/default/chapter/29/09/access-control#Authorization On Tuesday, October 22, 2013 5:40:49 AM UTC-4, Thomas S wrote: > > Ok, I am making progress. I guess all those JavaScript tools are not great > when it comes to plo

[web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-22 Thread Thomas S
Ok, I am making progress. I guess all those JavaScript tools are not great when it comes to plotting millions of points but I am happy to downsample on the server side and send less points - I am using flot instead of highcharts - Currently, the user is uploading a csv file. I don't do any par

[web2py] Re: Writing a time series monitor, pandas, matplotlib, highcharts...

2013-10-20 Thread Niphlod
first things first: are you sure that highcharts can handle 10*100k points to draw a graph ? As for the storage, you can do anything you like: if the data doesn't change that much, storing into the database will be a long process only on the first time. On the other end, if you need to fetch 100