• Auto scaling, scaled SQL graphs concluded

    July 28, 2009

    I wasn't sure I was to go this far. After catching breath the following have been added to Generic, auto scaling, scaled SQL graphs, and these will conclude my current hacks: Displaying X-axis min/max values. Support for Y-axis values precision. Support for pre-defined scale range. The addition of the above makes for presentable, usable graphs. […]

  • Generic, auto scaling, scaled SQL graphs

    July 27, 2009

    In Rotating SQL graphs horizontally, I have shown how to rotate an ASCII SQL graph into horizontal position. I was dissatisfied with some parts of the solution, which I will show now how to fix: I had to manually scale the graph values so as to fit nicely into screen. I had to rely on […]

  • Rotating SQL graphs horizontally

    July 24, 2009

    We all love graphs. We all love SQL hacks. We all know the SQL hack which displays a character-based graph (example follows for those unfamiliar). But we all love horizontal graphs, not vertical ones. We are used to the X axis being horizontal, Y being vertical. Not vice versa. In this post I'll present a […]

  • The DB problem inherent to dynamic web pages

    July 20, 2009

    When building web sites, a popular demand is a maximum page load time. For example, many would require < 0.5 seconds (or even less) for major pages loading time. Of course, there are numerous factors for page load time: network, caching, web servers, scripting language/code, database access and more. Naturally I want to discuss the […]

  • Character sets: latin1 vs. ascii

    July 8, 2009

    Unless specified otherwise, latin1 is the default character set in MySQL. What I usually find in schemes are columns which are either utf8 or latin1. The utf8 columns being those which need to contain multilingual characters (user names, addresses, articles etc.), and latin1 column being all the rest (passwords, digests, email addresses, hard-coded values etc.) […]

 
Powered by Wordpress and MySQL. Theme by openark.org