tag:blogger.com,1999:blog-15319370.post5646878138542592170..comments2024-03-05T11:16:00.846+01:00Comments on Roland Bouman's blog: More fun visualizing MySQL Database Sizerpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-15319370.post-64196555272288895072010-09-26T06:31:33.150+02:002010-09-26T06:31:33.150+02:00Well, I got it down to 15K because it's not a ...Well, I got it down to 15K because it's not a general purpose solution. I've only coded what features I need for mycheckpoint.<br />BTW, the code could have been much smaller if I didn't insist of long, readable names for functions and class variables, which don't get minified.<br /><br />I do not have pie charts (yet?), but have scatter plots: <br />http://code.openark.org/forge/wp-content/uploads/2010/09/r190/mcp_sql00/sv_report_html_24_7.html<br /><br />But these are actually two different pieces of code.<br /><br /><br />(PS I think a comment I've posted a couple of weeks ago has gone lost)Shlomi Noachhttps://www.blogger.com/profile/11874165719204714241noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-43931209680129132052010-09-06T10:10:40.908+02:002010-09-06T10:10:40.908+02:00Hi Shlomi!
yeah this looks really nice, good job...Hi Shlomi! <br /><br />yeah this looks really nice, good job! <br /><br />Looks like you're using your own graph solution now? It's really impressive you got it down to 15k, good job :) Can you do Pie charts too, or is it mostly time-series based? (not that that is a problem, just curious...)rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-81281967685162285152010-09-06T09:45:27.922+02:002010-09-06T09:45:27.922+02:00Still reviving this post ;)
Take a look at this
...Still reviving this post ;) <br /><br />Take a look at this<br /><a href="http://code.openark.org/forge/wp-content/uploads/2010/09/r190/mcp_sql00_samples/sv_report_html_brief.html" rel="nofollow">sample page</a>, which uses my own openark-charts; they make for a very low footprint (15K), and can read basic Google-API urls.Shlomi Noachhttp://openark.orgnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-41900632149338661952010-02-23T09:20:03.013+01:002010-02-23T09:20:03.013+01:00Shlomi, well if only need the time charts, and you...Shlomi, well if only need the time charts, and you want it to be self contained, I'd go for dycharts too. Thanks again for the tip.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-79408091691212551312010-02-23T07:24:03.793+01:002010-02-23T07:24:03.793+01:00Thanks.
I'm very interested in a self containe...Thanks.<br />I'm very interested in a self contained solution.<br />Including jquery from some common web server (like google) is not a problem, really.<br /><br />Both solutions offer far more ease of use than using Google Charts, which I'm doing now.<br /><br />ShlomiShlomi Noachhttp://openark.orgnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-71377440042483358932010-02-22T22:38:28.708+01:002010-02-22T22:38:28.708+01:00Oh, I should add - both flot and dygraphs both req...Oh, I should add - both flot and dygraphs both requre excanvas in case you care for IE compatibility.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-84433435660578175782010-02-22T22:37:18.582+01:002010-02-22T22:37:18.582+01:00That's a nice one too. Thanks!
As for lightw...That's a nice one too. Thanks! <br /><br />As for lightweight and dependencies: I guess it depends on how you look at it. This dygraphs lib is 46kb, which is pretty good for what it provides. But flot.pack.js is 32 kb, a bit smaller still. <br /><br />Granted, flot depends on jQuery, so we should add jQuery's weight to get an absolute weight. However, popular wisdom dictates that you should not host your own jQuery, instead, include one from google (see http://code.google.com/apis/ajaxlibs/documentation/#jquery). The idea is that more and more apps use this, ensuring it's already in the browser cache. (this is assuming that download time is the largest contributor to page slowness)<br /><br />Anyway - I don't think it is going to matter a lot either way, but this sure looks like a worthwile alternative to flot, so thanks for pointing it out.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-67422916625543730112010-02-22T21:55:17.681+01:002010-02-22T21:55:17.681+01:00I'm looking into a more lightweight solution: ...I'm looking into a more lightweight solution: http://danvk.org/dygraphs<br /><br />These only provide time-series charts, which is all I need. The good part is that it's a single 45KB include which can easily be embedded in any HTML page.<br />flot requires a lot of dependencies, if I'm not mistaken.<br /><br />Both are BSD/MIT, which is very good.<br /><br />ThanksShlomi Noachhttp://openark.orgnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-51673996117042187962010-02-22T08:49:26.466+01:002010-02-22T08:49:26.466+01:00Shlomi, flot is pretty good. Depends on jQuery, an...Shlomi, <a href="http://code.google.com/p/flot/" rel="nofollow">flot</a> is pretty good. Depends on jQuery, and if you need IE support, you need canvas emulation too (i can dig up where to find that but I am sure its in the flot documentation too)rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-24294397636405486302010-02-22T07:17:50.673+01:002010-02-22T07:17:50.673+01:00Indeed, there are many JS solution. Do you have an...Indeed, there are many JS solution. Do you have any recommendation?Shlomi Noachhttp://openark.orgnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-33685506345767205172010-02-21T19:59:58.713+01:002010-02-21T19:59:58.713+01:00Thanks Shlomi,
yeah I just noticed that the other...Thanks Shlomi,<br /><br />yeah I just noticed that the other day. Still, there are so many js visualization libs around, and most of them don't require you to post your data to a server at all. I'm going to go with those.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-11656297455774176302010-02-21T12:46:46.349+01:002010-02-21T12:46:46.349+01:00Update: Google charts now supports POST!
http://co...Update: Google charts now supports POST!<br />http://code.google.com/apis/chart/docs/post_requests.html<br /><br />Feb. 2010Shlomi Noachhttp://openark.orgnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-52622596444732626792009-10-31T20:19:12.012+01:002009-10-31T20:19:12.012+01:00Shlomi, thanks. I did notice this fomat, but other...Shlomi, thanks. I did notice this fomat, but other silly limitations (number of pixels) just made me stop looking into it further.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-91867175145702998952009-10-31T18:38:04.512+01:002009-10-31T18:38:04.512+01:00Hi Roland,
Changing from textual format to simple...Hi Roland,<br /><br />Changing from textual format to simple format may significantly reduce URL length. Instead of:<br />&chd=t:0,27,26,25,60,61<br />it's possible to write:<br />&chd=s:AaZY89<br /><br />See:<br />http://code.google.com/apis/chart/formats.html#simple<br /><br />ShlomiShlomi Noachhttp://openark.orgnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-80493565085582426612009-03-28T08:58:00.000+01:002009-03-28T08:58:00.000+01:00Hi Shlomi!partitioning is a nice idea, I think th...Hi Shlomi!<BR/><BR/>partitioning is a nice idea, I think that would be possible with some effort.<BR/><BR/>POST would not work, I mean, it would get you the image, but I think the <img> tag and thinks like CSS background-image all use GET anyway. So POST would only allow you to download the image, you would still need to hostit somewhere and i think that at that point you are better of using one of the many potherrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-41054527560874809422009-03-27T11:38:00.000+01:002009-03-27T11:38:00.000+01:00Hi Roland,Overall URL length can easily grow to th...Hi Roland,<BR/><BR/>Overall URL length can easily grow to thousands of characters for common databases. I wonder how easy it would be to "partition" the graph into several images, which can then be combined to form the desired image.<BR/>I'll give it a thought, though obviously this is a big patch for a very simple problem (which Google can solve by allowing POST method, which they don't).Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-65867674718680003372009-03-27T00:18:00.000+01:002009-03-27T00:18:00.000+01:00Hi Ronald, insane! Thanks for posting a comment ;)...Hi Ronald, insane! Thanks for posting a comment ;)<BR/><BR/>Yeah, I agree with both of you. I wrote in my previous post that I would never consider google charts for a serious db monitoring solution because of the obvious limitations. <BR/><BR/>Personally, I think Google Charts has a great feature ahead of it for showing online poll results - that kind of thing. For more serious charting there are already good solutions available, but I do think the learning curve for those is a bit steeper.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-15680661141144916542009-03-26T21:20:00.000+01:002009-03-26T21:20:00.000+01:00nice piece of sql Rolland , neverthless the max si...nice piece of sql Rolland , neverthless the max size of the querystring could be a problem :( .<BR/><BR/>thanks.@insan3https://www.blogger.com/profile/07656501468731944232noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-33596986078554280132009-03-26T21:18:00.000+01:002009-03-26T21:18:00.000+01:00nice piece of sql Roland, i can see a 'GET' maximu...nice piece of sql Roland, i can see a 'GET' maximum LENGTH limitation.@insan3https://www.blogger.com/profile/07656501468731944232noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-12148332757751934482009-03-26T18:33:00.000+01:002009-03-26T18:33:00.000+01:00Not bad. The limitations are a little annoying.I a...Not bad. The limitations are a little annoying.<BR/>I also would like to see multi point line charts.Ronald Bradfordhttps://www.blogger.com/profile/16170615042077930093noreply@blogger.com