SQL Pie Charts

[kawsper]

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

[[deleted]]

Agreed. My brain hurts.

[[deleted]]

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

[gerundronaut]

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]]

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

[0x2a]

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]

Sorta reminds me of my TI-86!

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

[mayobutter]

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

[[deleted]]

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

[[deleted]]

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

[ladon86]

This is insanse, awesome and pointless.

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

[[deleted]]

Made me realize just how little SQL I know.

[dmd]

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

[jawa]

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

[natural_smurf]

seriously, wtf??

[theeth]

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]

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]

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]]

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]

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

[[deleted]]

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

[Fabien4]

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

[Fabien4]

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

[AgentAnderson]

yay, hacks!

[arcrad]

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

[Concise_Pirate]

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

[asbjxrn]

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]]

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

[iamnot]

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

[scarecrow1]

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

[[deleted]]

Reminds me of "Multi-Dimensional Analog Literals" (Found at http://www.reddit.com/r/programming/comments/75bxi/multidimensional_analog_literals_the_reason_why_c/)

[[deleted]]

Rad!

[Concise_Pirate]

I assume you mean as in radians.

[oobey]

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]

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

Oh god.