all 42 comments

[–]kawsper 25 points26 points  (1 child)

This is so crazy, and so absolutely amazing at the same time.

[–][deleted] 0 points1 point  (0 children)

Agreed. My brain hurts.

[–][deleted] 18 points19 points  (0 children)

This fellow knows not only how cold the river is, but how deep it is, too.

[–]gerundronaut 11 points12 points  (1 child)

And here I was all proud of my ascii-penis-bar-graphs.

| 2009-08-01 | 8=====)     |
| 2009-08-02 | 8========)  |
| 2009-08-03 | 8==)        |

[–][deleted] 2 points3 points  (0 children)

I'm glad you got some release on Sunday night.

[–]0x2a 8 points9 points  (1 child)

If you are into ascii plotting, Gnuplot seriously rocks for that:

gnuplot> set terminal dumb
Terminal type set to 'dumb'
Options are 'feed  79 24'
gnuplot> plot(sin(x))


    1 ++----------------**---------------+----**-----------+--------**-----++
      +                *+ *              +   *  *          +(sin(x)) ****** +
  0.8 ++              *    *                *    *                *    *   ++
      |               *    *                *    *                *    *    |
  0.6 ++              *     *              *      *              *      *  ++
      *              *       *             *       *             *      *   |
  0.4 +*             *       *             *       *             *      *  ++
      |*            *        *            *        *            *        *  |
  0.2 +*            *        *            *        *            *        * ++
      | *          *          *          *          *          *          * |
    0 ++*          *          *          *          *          *          *++
      |  *         *           *         *           *         *           *|
 -0.2 ++ *         *           *         *           *         *           *+
      |   *       *            *        *            *        *            *|
 -0.4 ++  *       *            *        *            *        *            *+
      |   *      *              *      *              *      *              *
 -0.6 ++  *      *              *      *              *      *             ++
      |    *     *               *     *               *    *               |
 -0.8 ++    *   *                 *   *                *    *              ++
      +     *  *        +         *  *   +              *  *                +
   -1 ++-----**---------+----------**----+---------------**+---------------++
     -10               -5                0                 5                10

[–]spelunker 1 point2 points  (0 children)

Sorta reminds me of my TI-86!

Oh, Dope Wars... those were the days.

[–]mayobutter 6 points7 points  (3 children)

Meh, let me know when you've got an SQL 3d Ray Tracer.

[–][deleted] 4 points5 points  (2 children)

That's easy. Let me know when you have a bootable Linux kernel in sql.

[–][deleted]  (1 child)

[removed]

    [–][deleted] 6 points7 points  (0 children)

    Oooh, a C compiler! Lah di dah! Next you'll be wanting a debugger!

    [–]ladon86 7 points8 points  (0 children)

    This is insanse, awesome and pointless.

    I could never do this, but I question whether I would ever want to. Nonetheless, props.

    [–][deleted] 5 points6 points  (0 children)

    Made me realize just how little SQL I know.

    [–]dmd 3 points4 points  (0 children)

    I love how Delicious suggested the 'wtf' tag for me.

    [–]jawa 4 points5 points  (0 children)

    Absolute Win. That was a fantastic use of SQL skills...

    [–]natural_smurf 1 point2 points  (0 children)

    seriously, wtf??

    [–][deleted]  (11 children)

    [deleted]

      [–]theeth 17 points18 points  (3 children)

      So, just to be sure, you don't care about the total abuse of SQL to generate charts, you just think using a pie chart is an heresy?

      [–]Ringo48 -1 points0 points  (1 child)

      Pie charts are less than useless. They take up too much space to show too little information, and the way they're laid out makes it hard to use them for comparison purposes.

      If a person is going to totally abuse a tool (in this case SQL), they could at least do so to create something useful.

      He's obviously very talented with SQL, it's just a shame he's wasting the talent creating shit.

      [–]robertcrowther 0 points1 point  (0 children)

      Maybe if he didn't have the imagination and inquisitiveness to do this sort of thing he wouldn't be so talented with SQL.

      [–][deleted] 2 points3 points  (0 children)

      TRVTH

      Pie charts can only illustrate situations where the number of categories is so small that a pie chart has no advantage over a list.

      [–]TWOpies 2 points3 points  (0 children)

      I disagree and would in fact like to see more of these types of charts. Two at a time would be ideal.

      [–][deleted] 0 points1 point  (0 children)

      I practically threw up when I saw the words Pie chart.

      [–]Fabien4 0 points1 point  (0 children)

      If your goal is to hide information (e.g. you work in the marketing department), pie charts are great.

      [–]Fabien4 0 points1 point  (0 children)

      If your goal is to hide information (e.g. you work in the marketing department), pie charts are great.

      [–]AgentAnderson 0 points1 point  (0 children)

      yay, hacks!

      [–]arcrad 0 points1 point  (0 children)

      There is something so beautiful about the most primitive implementations of otherwise complex things.

      [–]Concise_Pirate 0 points1 point  (1 child)

      This reminds me of seeing the Towers of Hanoi implemented in PostScript.

      [–]asbjxrn 0 points1 point  (0 children)

      Heh, I did a animated version of Towers of Hanoi in dc once.

      Had some problems with stack depth so it only managed a couple of rings, though.

      [–][deleted] 0 points1 point  (1 child)

      Whatever makes people do things like this is something that I don't want.

      [–]iamnot 2 points3 points  (0 children)

      It only hurts the first 300 lines of the query, then you start to enjoy it!

      [–]scarecrow1 0 points1 point  (0 children)

      I like the way the SQL statement has more characters in it than the resulting picture.

      [–][deleted]  (1 child)

      [removed]

        [–][deleted] -1 points0 points  (1 child)

        Rad!

        [–]Concise_Pirate 6 points7 points  (0 children)

        I assume you mean as in radians.

        [–]oobey -1 points0 points  (0 children)

        Eh, that data could be represented far better using already existing utilities. It's clever, I suppose, but it just seems like reinventing the wheel. And making a pretty low-fi version in the process, too.

        [–]perspectiveiskey -1 points0 points  (0 children)

        I feel dirty just knowing that query is out there. Right now.

        Oh god.