8 Jun
2011
8 Jun
'11
5:51 p.m.
On Sat, Jun 4, 2011 at 9:57 PM, Ammar Yasir <ammaryasir.88(a)gmail.com> wrote:
On Wed, Jun 1, 2011 at 7:47 PM, Madhura Jayaratne <madhura.cj(a)gmail.com>wrote;wrote:
I've pushed my work. The basic plot functionality is implemented along with
classes for the same. Currently it works only for numeric fields, I'll add
support for other data types after some testing. You can try scenarios in
'sakila' database and search 'films' or 'film_actor' table.
Regards,
Ammar Yasir
On Wed, Jun 1, 2011 at 5:30 PM, Marc Delisle <marc(a)infomarc.info> wrote:
I was looking up jQuery-SVG and SVG past two days. There has been a
discussion going on in the list about whether to include a different
plotting library than existing(pChart). For now, instead of including
another plotting library, I've developed a prototype that creates the plot
using just SVG. I'll push it to my repo sometime later today.
>
> Hi, Madhura Jayaratne a écrit :
This is a Firefox compatibility problem. Resolved and pushed to the repo.
Demo will take some time to upgrade to the new version. Meanwhile if you
have Chrome, you can still experience what it's suppose to do.
--
Thanks and Regards,
Madhura Jayaratne
Hi,
On Wed, Jun 1, 2011 at 4:30 PM, Madhura Jayaratne <
madhura.cj(a)gmail.com
<mailto:madhura.cj@gmail.com>> wrote:
On Wed, Jun 1, 2011 at 2:10 AM, Ammar Yasir <
ammaryasir.88(a)gmail.com
<mailto:ammaryasir.88@gmail.com>>
wrote:
On Wed, Jun 1, 2011 at 1:55 AM, Marc Delisle <
marc(a)infomarc.info
<mailto:marc@infomarc.info>>
wrote:
Ammar Yasir a écrit :
>
>
> On Tue, May 31, 2011 at 10:14 PM, Marc Delisle
<marc(a)infomarc.info <mailto:marc@infomarc.info>
> <mailto:marc@infomarc.info <mailto:marc@infomarc.info
>>
wrote:
>
> Ammar Yasir a écrit :
>
> > Parts refactored are:
> > - Setting titles (titles['Browse']])
> > - getting fields list (getting column details)
> > - setting sub-tabs (Table search and Zoom search)
> > - setting table header of QBE display
> > - displaying foreign data
> > - search criteria input elements (HTML content
generation for the
> input
> > elements)
>
> Very good!
>
> Another trick you can use: when a function returns
an
array, like your
> PMA_tbl_getFields(), to fill all the returned values
in one statement
> you can use this syntax:
>
> list($fields_list, $fields_type, $fields_collation,
$fields_null) =
> PMA_tbl_getFields($table,$db);
>
>
> I made some more changes.
OK. There are still a few tab characters (found some in
libraries/tbl_select.lib.php).
> Should I proceed now to try the charting libraries?
Yes but in your proposal you wrote that you preferred
jQuery-SVG so I
assume you'll try this one first?
I'll try SVG first. I'm following what others have to say about
SVG, Madhura is using it for his GIS visualization. Tyron
proposed real-time charting but I don't think it'll be of much
help in our case.
Hi Ammar,
I'm not sure what exactly your requirement is. But pls have a look
at the visualization of data at [1] by clicking on the 'Visualize
GIS data' link in the 'Query results operations' section towards
the
bottom of the page. Try out zooming by double
clicking and panning
by dragging. I believe you are looking for something like this for
your zoom search feature.
Madhura,
I have issues operating panning and zooming. Here is the scenario:
1. Browse world_cities and click Visualize GIS data
2. Click-drag: pans OK
3. Double-click: this is a zoom out, I guess
4. Click-drag: no panning
5. Click "zoom out": data points are enlarging, isn't this a zoom-in?
Marc,
------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with
vRanger.
Installation's a snap, and flexible recovery options mean your data is
safe,
secure and there when you need it. Data protection magic?
Nope - It's vRanger. Get your free trial download today.
http://p.sf.net/sfu/quest-sfdev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
9 Jun
9 Jun
1:05 p.m.
New subject: [Phpmyadmin-devel] Zoom Search
Ammar Yasir a écrit :
On Sat, Jun 4, 2011 at 9:57 PM, Ammar Yasir <ammaryasir.88(a)gmail.com
<mailto:ammaryasir.88@gmail.com>> wrote:
On Wed, Jun 1, 2011 at 7:47 PM, Madhura Jayaratne
<madhura.cj(a)gmail.com <mailto:madhura.cj@gmail.com>> wrote:
On Wed, Jun 1, 2011 at 5:30 PM, Marc Delisle <marc(a)infomarc.info
<mailto:marc@infomarc.info>> wrote:
Madhura Jayaratne a écrit :
Ammar,
I'm concentrating on testing the interface right now, haven't looked at
the code yet.
1. Let's say I choose film_actor, activate actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see the
value I entered in the dialog.
But this scenario gives me a notice:
Notice in ./libraries/svg_plot/pma_scatter_plot.php#224
Undefined index:
Backtrace
./libraries/svg_plot/pma_scatter_plot.php#161:
PMA_Scatter_Plot->_prepareDataSet(
array,
integer 0,
array,
string ,
)
./libraries/svg_plot/pma_scatter_plot.php#176: PMA_Scatter_Plot->_svg()
./libraries/tbl_select.lib.php#373: PMA_Scatter_Plot->asSVG()
./tbl_zoom_select.php#131: PMA_SVG_scatter_plot(
array,
array,
)
2. What should I enter as data label to have meaningful results? Please
give an example.
3. Did you find a table (in sakila) for which choosing two columns and
generating a plot would make me recognize some kind of trend in the data?
As an example, on a copy of the film table I did
update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
--
Marc Delisle
http://infomarc.info
On Wed, Jun 1, 2011 at 4:30 PM, Madhura Jayaratne
<madhura.cj(a)gmail.com <mailto:madhura.cj@gmail.com>
<mailto:madhura.cj@gmail.com
<mailto:madhura.cj@gmail.com>>> wrote:
On Wed, Jun 1, 2011 at 2:10 AM, Ammar Yasir
<ammaryasir.88(a)gmail.com <mailto:ammaryasir.88@gmail.com>
<mailto:ammaryasir.88@gmail.com
<mailto:ammaryasir.88@gmail.com>>> wrote:
On Wed, Jun 1, 2011 at 1:55 AM, Marc Delisle
<marc(a)infomarc.info <mailto:marc@infomarc.info>
<mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>> wrote:
Ammar Yasir a écrit :
<mailto:marc@infomarc.info> <mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>
On Tue, May 31, 2011 at 10:14 PM, Marc Delisle
<marc(a)infomarc.info
> <mailto:marc@infomarc.info
<mailto:marc@infomarc.info> <mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>>>
wrote:
>
> Ammar Yasir a écrit :
>
> > Parts refactored are:
> > - Setting titles (titles['Browse']])
> > - getting fields list (getting
column
details)
> > - setting sub-tabs
(Table search
and Zoom search)
> > - setting table
header of QBE display
> > - displaying foreign data
> > - search criteria input elements
(HTML
content
generation for the
> input
> > elements)
>
> Very good!
>
> Another trick you can use: when a
function
returns an
array, like your
> PMA_tbl_getFields(), to fill all the
returned
values
in one statement
> you can use this syntax:
>
> list($fields_list, $fields_type,
$fields_collation,
$fields_null) =
(found some in
PMA_tbl_getFields($table,$db);
I made some more changes.
OK. There are still a few tab characters libraries/tbl_select.lib.php).
> Should I proceed now to try the charting
libraries?
Yes but in your proposal you wrote that you
preferred
jQuery-SVG so I
assume you'll try this one first?
I'll try SVG first. I'm following what others
have to
say about
SVG, Madhura is using it for his GIS
visualization. Tyron
proposed real-time charting but I
don't think
it'll be of much
help in our case.
Hi Ammar,
I'm not sure what exactly your requirement is. But
pls have a
look
at the visualization of data at [1] by
clicking on
the 'Visualize
GIS data' link in the 'Query results
operations'
section towards the
bottom of the page. Try out zooming by double
clicking and panning
by dragging. I believe you are looking for
something
like this for
your zoom search feature.
Madhura,
I have issues operating panning and zooming. Here is the
scenario:
1. Browse world_cities and click Visualize GIS data
2. Click-drag: pans OK
3. Double-click: this is a zoom out, I guess
4. Click-drag: no panning
5. Click "zoom out": data points are enlarging, isn't this a
zoom-in?
Marc,
This is a Firefox compatibility problem. Resolved and pushed to
the repo. Demo will take some time to upgrade to the new
version. Meanwhile if you have Chrome, you can still experience
what it's suppose to do.
--
Thanks and Regards,
Madhura Jayaratne
Hi,
I was looking up jQuery-SVG and SVG past two days. There has been a
discussion going on in the list about whether to include a different
plotting library than existing(pChart). For now, instead of
including another plotting library, I've developed a prototype that
creates the plot using just SVG. I'll push it to my repo sometime
later today.
Hi,
I've pushed my work. The basic plot functionality is implemented along
with classes for the same. Currently it works only for numeric fields,
I'll add support for other data types after some testing. You can try
scenarios in 'sakila' database and search 'films' or 'film_actor'
table. 
1:49 p.m.
New subject: [Phpmyadmin-devel] Zoom Search
By the way, what about using Highcharts for this project?
Highcharts can have clickable points: http://www.highcharts.com/demo/line-ajax
And is zoomable (altough mouse-wheel zoom would be nicer):
http://www.highcharts.com/demo/line-time-series
On Thu, Jun 9, 2011 at 7:05 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Ammar Yasir a écrit :
On Sat, Jun 4, 2011 at 9:57 PM, Ammar Yasir <ammaryasir.88(a)gmail.com
<mailto:ammaryasir.88@gmail.com>> wrote:
On Wed, Jun 1, 2011 at 7:47 PM, Madhura Jayaratne
<madhura.cj(a)gmail.com <mailto:madhura.cj@gmail.com>> wrote:
On Wed, Jun 1, 2011 at 5:30 PM, Marc Delisle <marc(a)infomarc.info
<mailto:marc@infomarc.info>> wrote:
Madhura Jayaratne a écrit :
Ammar,
I'm concentrating on testing the interface right now, haven't looked at
the code yet.
1. Let's say I choose film_actor, activate actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see the
value I entered in the dialog.
But this scenario gives me a notice:
Notice in ./libraries/svg_plot/pma_scatter_plot.php#224
Undefined index:
Backtrace
./libraries/svg_plot/pma_scatter_plot.php#161:
PMA_Scatter_Plot->_prepareDataSet(
array,
integer 0,
array,
string ,
)
./libraries/svg_plot/pma_scatter_plot.php#176: PMA_Scatter_Plot->_svg()
./libraries/tbl_select.lib.php#373: PMA_Scatter_Plot->asSVG()
./tbl_zoom_select.php#131: PMA_SVG_scatter_plot(
array,
array,
)
2. What should I enter as data label to have meaningful results? Please
give an example.
3. Did you find a table (in sakila) for which choosing two columns and
generating a plot would make me recognize some kind of trend in the data?
As an example, on a copy of the film table I did
update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
--
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Wed, Jun 1, 2011 at 4:30 PM, Madhura Jayaratne
<madhura.cj(a)gmail.com <mailto:madhura.cj@gmail.com>
<mailto:madhura.cj@gmail.com
<mailto:madhura.cj@gmail.com>>> wrote:
On Wed, Jun 1, 2011 at 2:10 AM, Ammar Yasir
<ammaryasir.88(a)gmail.com <mailto:ammaryasir.88@gmail.com>
<mailto:ammaryasir.88@gmail.com
<mailto:ammaryasir.88@gmail.com>>> wrote:
On Wed, Jun 1, 2011 at 1:55 AM, Marc Delisle
<marc(a)infomarc.info <mailto:marc@infomarc.info>
<mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>> wrote:
Ammar Yasir a écrit :
<mailto:marc@infomarc.info> <mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>
On Tue, May 31, 2011 at 10:14 PM, Marc Delisle
<marc(a)infomarc.info
> <mailto:marc@infomarc.info
<mailto:marc@infomarc.info> <mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>>>
wrote:
>
> Ammar Yasir a écrit :
>
> > Parts refactored are:
> > - Setting titles (titles['Browse']])
> > - getting fields list (getting
column
details)
> > - setting sub-tabs
(Table search
and Zoom search)
> > - setting table
header of QBE display
> > - displaying foreign data
> > - search criteria input elements
(HTML
content
generation for the
> input
> > elements)
>
> Very good!
>
> Another trick you can use: when a
function
returns an
array, like your
> PMA_tbl_getFields(), to fill all the
returned
values
in one statement
> you can use this syntax:
>
> list($fields_list, $fields_type,
$fields_collation,
$fields_null) =
(found some in
PMA_tbl_getFields($table,$db);
I made some more changes.
OK. There are still a few tab characters libraries/tbl_select.lib.php).
> Should I proceed now to try the charting
libraries?
Yes but in your proposal you wrote that you
preferred
jQuery-SVG so I
assume you'll try this one first?
I'll try SVG first. I'm following what others
have to
say about
SVG, Madhura is using it for his GIS
visualization. Tyron
proposed real-time charting but I
don't think
it'll be of much
help in our case.
Hi Ammar,
I'm not sure what exactly your requirement is. But
pls have a
look
at the visualization of data at [1] by
clicking on
the 'Visualize
GIS data' link in the 'Query results
operations'
section towards the
bottom of the page. Try out zooming by double
clicking and panning
by dragging. I believe you are looking for
something
like this for
your zoom search feature.
Madhura,
I have issues operating panning and zooming. Here is the
scenario:
1. Browse world_cities and click Visualize GIS data
2. Click-drag: pans OK
3. Double-click: this is a zoom out, I guess
4. Click-drag: no panning
5. Click "zoom out": data points are enlarging, isn't this a
zoom-in?
Marc,
This is a Firefox compatibility problem. Resolved and pushed to
the repo. Demo will take some time to upgrade to the new
version. Meanwhile if you have Chrome, you can still experience
what it's suppose to do.
--
Thanks and Regards,
Madhura Jayaratne
Hi,
I was looking up jQuery-SVG and SVG past two days. There has been a
discussion going on in the list about whether to include a different
plotting library than existing(pChart). For now, instead of
including another plotting library, I've developed a prototype that
creates the plot using just SVG. I'll push it to my repo sometime
later today.
Hi,
I've pushed my work. The basic plot functionality is implemented along
with classes for the same. Currently it works only for numeric fields,
I'll add support for other data types after some testing. You can try
scenarios in 'sakila' database and search 'films' or 'film_actor'
table.
10:28 p.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Thu, Jun 9, 2011 at 10:35 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Ammar Yasir a écrit :
display
Ammar,
I'm concentrating on testing the interface right now, haven't looked at
the code yet.
Hi,
On Sat, Jun 4, 2011 at 9:57 PM, Ammar Yasir <ammaryasir.88(a)gmail.com
<mailto:ammaryasir.88@gmail.com>> wrote:
On Wed, Jun 1, 2011 at 7:47 PM, Madhura Jayaratne
<madhura.cj(a)gmail.com <mailto:madhura.cj@gmail.com>> wrote:
On Wed, Jun 1, 2011 at 5:30 PM, Marc Delisle <marc(a)infomarc.info
<mailto:marc@infomarc.info>> wrote:
Madhura Jayaratne a écrit :
Delisle
On Wed, Jun 1, 2011 at 4:30 PM, Madhura Jayaratne
<madhura.cj(a)gmail.com <mailto:madhura.cj@gmail.com>
<mailto:madhura.cj@gmail.com
<mailto:madhura.cj@gmail.com>>> wrote:
On Wed, Jun 1, 2011 at 2:10 AM, Ammar Yasir
<ammaryasir.88(a)gmail.com <mailto:ammaryasir.88@gmail.com>
<mailto:ammaryasir.88@gmail.com
<mailto:ammaryasir.88@gmail.com>>> wrote:
On Wed, Jun 1, 2011 at 1:55 AM, Marc Delisle
<marc(a)infomarc.info <mailto:marc@infomarc.info>
<mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>> wrote:
>
> Ammar Yasir a écrit :
> >
> >
> > On Tue, May 31, 2011 at 10:14 PM, Marc
<marc(a)infomarc.info
<mailto:marc@infomarc.info>
<mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>
> <mailto:marc@infomarc.info
<mailto:marc@infomarc.info> <mailto:marc@infomarc.info
<mailto:marc@infomarc.info>>>>
wrote:
>
> Ammar Yasir a écrit :
>
> > Parts refactored are:
> > - Setting titles (titles['Browse']])
> > - getting fields list (getting
column
details)
> > - setting sub-tabs
(Table search
and Zoom search)
> > > - setting table header of QBE
> > - displaying foreign data
> > - search criteria input elements
(HTML
content
generation for the
> input
> > elements)
>
> Very good!
>
> Another trick you can use: when a
function
returns an
array, like your
> PMA_tbl_getFields(), to fill all the
returned
values
in one statement
> you can use this syntax:
>
> list($fields_list, $fields_type,
$fields_collation,
$fields_null) =
(found some in
PMA_tbl_getFields($table,$db);
I made some more changes.
OK. There are still a few tab characters libraries/tbl_select.lib.php).
> Should I proceed now to try the charting
libraries?
Yes but in your proposal you wrote that you
preferred
jQuery-SVG so I
assume you'll try this one first?
I'll try SVG first. I'm following what others
have to
say about
SVG, Madhura is using it for his GIS
visualization. Tyron
proposed real-time charting but I
don't think
it'll be of much
help in our case.
Hi Ammar,
I'm not sure what exactly your requirement is. But
pls have a
look
at the visualization of data at [1] by
clicking on
the 'Visualize
GIS data' link in the 'Query results
operations'
section towards the
bottom of the page. Try out zooming by double
clicking and panning
by dragging. I believe you are looking for
something
like this for
your zoom search feature.
Madhura,
I have issues operating panning and zooming. Here is the
scenario:
1. Browse world_cities and click Visualize GIS data
2. Click-drag: pans OK
3. Double-click: this is a zoom out, I guess
4. Click-drag: no panning
5. Click "zoom out": data points are enlarging, isn't this a
zoom-in?
Marc,
This is a Firefox compatibility problem. Resolved and pushed to
the repo. Demo will take some time to upgrade to the new
version. Meanwhile if you have Chrome, you can still experience
what it's suppose to do.
--
Thanks and Regards,
Madhura Jayaratne
Hi,
I was looking up jQuery-SVG and SVG past two days. There has been a
discussion going on in the list about whether to include a different
plotting library than existing(pChart). For now, instead of
including another plotting library, I've developed a prototype that
creates the plot using just SVG. I'll push it to my repo sometime
later today.
Hi,
I've pushed my work. The basic plot functionality is implemented along
with classes for the same. Currently it works only for numeric fields,
I'll add support for other data types after some testing. You can try
scenarios in 'sakila' database and search 'films' or 'film_actor'
table. 1. Let's say I choose film_actor, activate
actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see the
value I entered in the dialog.
But this scenario gives me a notice:
Notice in ./libraries/svg_plot/pma_scatter_plot.php#224
Undefined index:
Backtrace
./libraries/svg_plot/pma_scatter_plot.php#161:
PMA_Scatter_Plot->_prepareDataSet(
array,
integer 0,
array,
string ,
)
./libraries/svg_plot/pma_scatter_plot.php#176: PMA_Scatter_Plot->_svg()
./libraries/tbl_select.lib.php#373: PMA_Scatter_Plot->asSVG()
./tbl_zoom_select.php#131: PMA_SVG_scatter_plot(
array,
array,
)
I fixed this issue. The notice comes if you do not select a label, I added
a
default to it so the notice should not come now.
2. What should I enter as data label to have meaningful results? Please
give an example.
Actually, we had to show a label for each data point. So for example in
'film' table or 'actor' table 'name' could be a label for
points. I haven't
implemented showing the label yet, the selection just stores the label for
each point internally. I thought showing the label for now (without the zoom
feature) would make the plot very difficult to understand.
3. Did you find a table (in sakila) for which choosing
two columns and
generating a plot would make me recognize some kind of trend in the data?
As an example, on a copy of the film table I did
update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
I've added plotting string fields too, so some scenarios in sakila database
you
can check:
'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs
category
'sales_by_film_category' table, plot total_sales vs category
'payment' table, plot customer_id vs amount
--
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
10 Jun
10 Jun
8:42 a.m.
New subject: [Phpmyadmin-devel] Zoom Search
Ammar Yasir a écrit :
Hi,
1. Let's say I choose film_actor, activate actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see the
value I entered in the dialog.
But this scenario gives me a notice:
I fixed this issue. The notice comes if you do not select a label, I
added a default to it so the notice should not come now.
2. What should I enter as data label to have meaningful results? Please
give an example.
Actually, we had to show a label for each data point. So for example in
'film' table or 'actor' table 'name' could be a label for points.
I
haven't implemented showing the label yet, the selection just stores the
label for each point internally. I thought showing the label for now
(without the zoom feature) would make the plot very difficult to
understand.
3. Did you find a table (in sakila) for which choosing two columns and
generating a plot would make me recognize some kind of trend in the
data?
As an example, on a copy of the film table I did
update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
I've added plotting string fields too, so some scenarios in sakila
database you can check:
'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs
category
'sales_by_film_category' table, plot total_sales vs category
'payment' table, plot customer_id vs amount
Ammar,
OK, these scenarios work fine.
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how
do you plan to implement zooming, panning and clickable points?
If Highcharts works well, it would be easier for us to handle just one
library for charts.
--
Marc Delisle
http://infomarc.info
11 Jun
11 Jun
3:44 p.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Fri, Jun 10, 2011 at 6:12 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Ammar Yasir a écrit :
has
<a> and events also so clickable points can be implemented that way.
But i'll try highcharts now as tyron suggested.
Hi,
1. Let's say I choose film_actor, activate actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see the
value I entered in the dialog.
But this scenario gives me a notice:
I fixed this issue. The notice comes if you do not select a label, I
added a default to it so the notice should not come now.
2. What should I enter as data label to have meaningful results?
Please
give an example.
Actually, we had to show a label for each data point. So for example in
'film' table or 'actor' table 'name' could be a label for points.
I
haven't implemented showing the label yet, the selection just stores the
label for each point internally. I thought showing the label for now
(without the zoom feature) would make the plot very difficult to
understand.
3. Did you find a table (in sakila) for which choosing two columns
and
generating a plot would make me recognize
some kind of trend in the
data?
As an example, on a copy of the film table I did
update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
I've added plotting string fields too, so some scenarios in sakila
database you can check:
'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs
category
'sales_by_film_category' table, plot
total_sales vs category
'payment' table, plot customer_id vs amount
Ammar,
OK, these scenarios work fine.
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how
do you plan to implement zooming, panning and clickable points?
If Highcharts works well, it would be easier for us to handle just one
library for charts.
I would probably have used jquery plugins or write my own code for it. SVG --
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
16 Jun
16 Jun
4:09 p.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Sun, Jun 12, 2011 at 1:14 AM, Ammar Yasir <ammaryasir.88(a)gmail.com>wrote;wrote:
On Fri, Jun 10, 2011 at 6:12 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Hi,
I've used Highcharts to create the plot functionality. For now, it plots for
numeric fields only. it is zoomable (both in x and y) and also you can click
the data points to view the row. You can try scenarios like:
In sakila database:
-> In films table, try film_id ( < 100 ) vs rental_rate and choose
'title' as the label.
-> In films_actor table, try film_id vs actor_id.
etc..
Regards,
Ammar Yasir
Ammar Yasir a écrit :
has
<a> and events also so clickable points can be implemented that way.
But i'll try highcharts now as tyron suggested.
Hi,
1. Let's say I choose film_actor, activate actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see the
value I entered in the dialog.
But this scenario gives me a notice:
I fixed this issue. The notice comes if you do not select a label, I
added a default to it so the notice should not come now.
2. What should I enter as data label to have meaningful results?
Please
give an example.
Actually, we had to show a label for each data point. So for example in
'film' table or 'actor' table 'name' could be a label for points.
I
haven't implemented showing the label yet, the selection just stores the
label for each point internally. I thought showing the label for now
(without the zoom feature) would make the plot very difficult to
understand.
3. Did you find a table (in sakila) for which choosing two columns
and
generating a plot would make me recognize
some kind of trend in the
data?
As an example, on a copy of the film table I did
update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
I've added plotting string fields too, so some scenarios in sakila
database you can check:
'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs
category
'sales_by_film_category' table, plot
total_sales vs category
'payment' table, plot customer_id vs amount
Ammar,
OK, these scenarios work fine.
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how
do you plan to implement zooming, panning and clickable points?
If Highcharts works well, it would be easier for us to handle just one
library for charts.
I would probably have used jquery plugins or write my own code for it. SVG --
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
17 Jun
17 Jun
4:13 a.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Thu, Jun 16, 2011 at 10:09 PM, Ammar Yasir <ammaryasir.88(a)gmail.com> wrote:
On Sun, Jun 12, 2011 at 1:14 AM, Ammar Yasir
<ammaryasir.88(a)gmail.com>
wrote:
For the chart export to work you'll need to define the a js variable
in your php code like this:
<script type="text/javascript">
pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
</script>
...or maybe we could put this into header.inc.php?
On Fri, Jun 10, 2011 at 6:12 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Hi,
I've used Highcharts to create the plot functionality. For now, it plots for
numeric fields only. it is zoomable (both in x and y) and also you can click
the data points to view the row. You can try scenarios like:
In sakila database:
-> In films table, try film_id ( < 100 ) vs rental_rate and choose
'title' as the label.
-> In films_actor table, try film_id vs actor_id.
etc..
Ammar Yasir a écrit :
I would probably have used jquery plugins or write my own code for it. SVG
has <a> and events also so clickable points can be implemented that way.
But i'll try highcharts now as tyron suggested.
Hi,
1. Let's say I choose film_actor, activate actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see
the
value I entered in the dialog.
But this scenario gives me a notice:
I fixed this issue. The notice comes if you do not select a label, I
added a default to it so the notice should not come now.
2. What should I enter as data label to have meaningful results?
Please
give an example.
Actually, we had to show a label for each data point. So for example in
'film' table or 'actor' table 'name' could be a label for points.
I
haven't implemented showing the label yet, the selection just stores
the
label for each point internally. I thought showing the label for now
(without the zoom feature) would make the plot very difficult to
understand.
3. Did you find a table (in sakila) for which choosing two columns
and
generating a plot would make me recognize some kind of trend in the
data?
As an example, on a copy of the film table I did
update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
I've added plotting string fields too, so some scenarios in sakila
database you can check:
'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs
category
'sales_by_film_category' table, plot total_sales vs category
'payment' table, plot customer_id vs amount
Ammar,
OK, these scenarios work fine.
Any opinion on Tyron's suggestion about using Highcharts? Otherwise, how
do you plan to implement zooming, panning and clickable points?
If Highcharts works well, it would be easier for us to handle just one
library for charts.
Regards,
Ammar Yasir
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
--
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
4:23 a.m.
New subject: [Phpmyadmin-devel] Zoom Search
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200
Tyron Madlener <tyronx(a)gmail.com> napsal(a):
For the chart export to work you'll need to define
the a js variable
in your php code like this:
<script type="text/javascript">
pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
</script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does
not suggest it. We anyway use it for almost all data needs to be passed
to javascript and do not change during one session.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
20 Jun
20 Jun
9:02 a.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař <michal(a)cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200
Tyron Madlener <tyronx(a)gmail.com> napsal(a):
I would like to be able to add js vars dynamically. In the case of
server_variables.php I need to know whether the current user is a
superuser. Whereas in most other pages this information is not
required.
So instead of putting all possible vars there I'd rather prefer to
have only 4-5 variables hardcoded and others addable dynamically
through a function, lets call it PMA_AddJSVariable().
But having that in messages.php would means the browser cannot load
the file once and use the cached version after.
Also those variables might change in value, meaning the messages.php
also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
For the chart export to work you'll need to
define the a js variable
in your php code like this:
<script type="text/javascript">
pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
</script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does
not suggest it. We anyway use it for almost all data needs to be passed
to javascript and do not change during one session.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
9:27 a.m.
New subject: [Phpmyadmin-devel] Zoom Search
Ammar, when I replaced pChart I have added a method called
PMA_createChart() into function.js
I think we should use this method to create a chart, as it apply some
default settings to the chart (which you can overwrite however). This
way one can apply changes globally to all the charts.
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener <tyronx(a)gmail.com> wrote:
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař
<michal(a)cihar.com> wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200
Tyron Madlener <tyronx(a)gmail.com> napsal(a):
I would like to be able to add js vars dynamically. In the case of
server_variables.php I need to know whether the current user is a
superuser. Whereas in most other pages this information is not
required.
So instead of putting all possible vars there I'd rather prefer to
have only 4-5 variables hardcoded and others addable dynamically
through a function, lets call it PMA_AddJSVariable().
But having that in messages.php would means the browser cannot load
the file once and use the cached version after.
Also those variables might change in value, meaning the messages.php
also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
For the chart export to work you'll need to
define the a js variable
in your php code like this:
<script type="text/javascript">
pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
</script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does
not suggest it. We anyway use it for almost all data needs to be passed
to javascript and do not change during one session.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
3:25 p.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Mon, Jun 20, 2011 at 6:57 PM, Tyron Madlener <tyronx(a)gmail.com> wrote:
Ammar, when I replaced pChart I have added a method
called
PMA_createChart() into function.js
I think we should use this method to create a chart, as it apply some
default settings to the chart (which you can overwrite however). This
way one can apply changes globally to all the charts.
Okay, I'll look into it.
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener
<tyronx(a)gmail.com> wrote:
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař
<michal(a)cihar.com> wrote:
------------------------------------------------------------------------------
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200
Tyron Madlener <tyronx(a)gmail.com> napsal(a):
I would like to be able to add js vars dynamically. In the case of
server_variables.php I need to know whether the current user is a
superuser. Whereas in most other pages this information is not
required.
So instead of putting all possible vars there I'd rather prefer to
have only 4-5 variables hardcoded and others addable dynamically
through a function, lets call it PMA_AddJSVariable().
But having that in messages.php would means the browser cannot load
the file once and use the cached version after.
Also those variables might change in value, meaning the messages.php
also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
>
> --
> Michal Čihař | http://cihar.com | http://blog.cihar.com
>
> For the chart export to work you'll need to
define the a js variable
in your php code like this:
<script type="text/javascript">
pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
</script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does
not suggest it. We anyway use it for almost all data needs to be passed
to javascript and do not change during one session. EditLive
Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
25 Jun
25 Jun
5:50 a.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener <tyronx(a)gmail.com> wrote:
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař
<michal(a)cihar.com> wrote:
With such solution I could also avoid some inline JSON Code places.
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200
Tyron Madlener <tyronx(a)gmail.com> napsal(a):
I would like to be able to add js vars dynamically. In the case of
server_variables.php I need to know whether the current user is a
superuser. Whereas in most other pages this information is not
required.
So instead of putting all possible vars there I'd rather prefer to
have only 4-5 variables hardcoded and others addable dynamically
through a function, lets call it PMA_AddJSVariable().
But having that in messages.php would means the browser cannot load
the file once and use the cached version after.
Also those variables might change in value, meaning the messages.php
also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
For the chart export to work you'll need to
define the a js variable
in your php code like this:
<script type="text/javascript">
pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
</script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does
not suggest it. We anyway use it for almost all data needs to be passed
to javascript and do not change during one session.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
11 Jul
11 Jul
6:14 a.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Sat, Jun 25, 2011 at 12:50 PM, Tyron Madlener <tyronx(a)gmail.com> wrote:
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener
<tyronx(a)gmail.com> wrote:
Any objections to this?
On Fri, Jun 17, 2011 at 10:23 AM, Michal Čihař
<michal(a)cihar.com> wrote:
With such solution I could also avoid some inline JSON Code places.
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200
Tyron Madlener <tyronx(a)gmail.com> napsal(a):
I would like to be able to add js vars dynamically. In the case of
server_variables.php I need to know whether the current user is a
superuser. Whereas in most other pages this information is not
required.
So instead of putting all possible vars there I'd rather prefer to
have only 4-5 variables hardcoded and others addable dynamically
through a function, lets call it PMA_AddJSVariable().
But having that in messages.php would means the browser cannot load
the file once and use the cached version after.
Also those variables might change in value, meaning the messages.php
also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
For the chart export to work you'll need to
define the a js variable
in your php code like this:
<script type="text/javascript">
pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
</script>
...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does
not suggest it. We anyway use it for almost all data needs to be passed
to javascript and do not change during one session.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
9:44 p.m.
New subject: [Phpmyadmin-devel] Zoom Search
On Mon, Jul 11, 2011 at 3:44 PM, Tyron Madlener <tyronx(a)gmail.com> wrote:
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Sat, Jun 25, 2011 at 12:50 PM, Tyron Madlener
<tyronx(a)gmail.com> wrote:
With such solution I could also avoid some inline JSON Code places.
Any objections to this?
Hi,
I'm using PMA_createChart(settings) with my settings and If have some
numeric values for my xAxis, it overwrites them as using a timeline on xAxis
( the markers on the xAxis are also not visible).
git: http://repo.or.cz/w/phpmyadmin/ammaryasirr.git
On Mon, Jun 20, 2011 at 3:02 PM, Tyron Madlener
<tyronx(a)gmail.com>
wrote:
> On Fri, Jun 17, 2011 at 10:23 AM, Michal
Čihař <michal(a)cihar.com>
wrote:
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200
Tyron Madlener <tyronx(a)gmail.com> napsal(a):
> For the chart export to work you'll need to define the a js variable
> in your php code like this:
>
> <script type="text/javascript">
> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
> </script>
>
> ...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does
not suggest it. We anyway use it for almost all data needs to be passed
to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of
server_variables.php I need to know whether the current user is a
superuser. Whereas in most other pages this information is not
required.
So instead of putting all possible vars there I'd rather prefer to
have only 4-5 variables hardcoded and others addable dynamically
through a function, lets call it PMA_AddJSVariable().
But having that in messages.php would means the browser cannot load
the file once and use the cached version after.
Also those variables might change in value, meaning the messages.php
also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
>>
>> --
>> Michal Čihař | http://cihar.com | http://blog.cihar.com
>>
>>
------------------------------------------------------------------------------
EditLive Enterprise is the world's most
technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
12 Jul
12 Jul
7:45 a.m.
New subject: [Phpmyadmin-devel] Zoom Search
Le 2011-07-11 06:14, Tyron Madlener a écrit :
On Sat, Jun 25, 2011 at 12:50 PM, Tyron
Madlener<tyronx(a)gmail.com> wrote:
OK for me.
--
Marc Delisle
http://infomarc.info
On Mon, Jun 20, 2011 at 3:02 PM, Tyron
Madlener<tyronx(a)gmail.com> wrote:
Any objections to this?
On Fri, Jun 17, 2011 at 10:23 AM, Michal
Čihař<michal(a)cihar.com> wrote:
With such solution I could also avoid some inline JSON Code places.
Hi
Dne Fri, 17 Jun 2011 10:13:07 +0200
Tyron Madlener<tyronx(a)gmail.com> napsal(a):
> For the chart export to work you'll need to define the a js variable
> in your php code like this:
>
> <script type="text/javascript">
> pma_token = '<?php echo $_SESSION[' PMA_token ']; ?>';
> </script>
>
> ...or maybe we could put this into header.inc.php?
I think it should rather go to js/messages.php, though it's name does
not suggest it. We anyway use it for almost all data needs to be passed
to javascript and do not change during one session.
I would like to be able to add js vars dynamically. In the case of
server_variables.php I need to know whether the current user is a
superuser. Whereas in most other pages this information is not
required.
So instead of putting all possible vars there I'd rather prefer to
have only 4-5 variables hardcoded and others addable dynamically
through a function, lets call it PMA_AddJSVariable().
But having that in messages.php would means the browser cannot load
the file once and use the cached version after.
Also those variables might change in value, meaning the messages.php
also needs to be refreshed by the browser each time.
It might be better to have that in header.inc.php.
4764
days inactive
4798
days old
15 comments
4 participants
participants (4)
-
Ammar Yasir -
Marc Delisle -
Michal Čihař -
Tyron Madlener