lmorchard - Pebbling Club 🐧🪨

SQL pie chart | code.openark.org

code.openark.org
2010-01-26T23:20:08.000Z
holygod insanity sql piecharts what visualization database mysql ascii art imported:pinboard

Notes

"Shown below is a (single query) SQL-generated pie chart. I will walk through the steps towards making this happen, and conclude with what, I hope you’ll agree, are real-world, useful usage samples."

Feed

Embed

Unfurl

{ "failed": true, "failedAt": 1728195497391, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds", "expires": 1728365813787, "status": 200, "bodyLength": 88370, "author": "giovanni", "date": "2009-08-12T10:49:41.000Z", "description": "My other half says I’m losing it. But I think that as an enthusiast kernel developer she doesn’t have the right to criticize people. (“I like user space better!” – she…", "image": "https://s0.wp.com/i/blank.jpg", "logo": "https://code.openark.org/favicon.ico", "publisher": "code.openark.org", "title": "SQL pie chart", "url": "https://code.openark.org/blog/mysql/sql-pie-chart", "feed": "https://code.openark.org/blog/feed", "iframe": "<blockquote class=\"wp-embedded-content\" data-secret=\"S0znHeGZwO\"><a href=\"https://code.openark.org/blog/mysql/sql-pie-chart\">SQL pie chart</a></blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https://code.openark.org/blog/mysql/sql-pie-chart/embed#?secret=S0znHeGZwO\" width=\"600\" height=\"338\" title=\"“SQL pie chart” — code.openark.org\" data-secret=\"S0znHeGZwO\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"></iframe><script>\n/**\n * WordPress inline HTML embed\n *\n * @since 4.4.0\n * @output wp-includes/js/wp-embed.js\n *\n * Single line comments should not be used since they will break\n * the script when inlined in get_post_embed_html(), specifically\n * when the comments are not stripped out due to SCRIPT_DEBUG\n * being turned on.\n */\n(function ( window, document ) {\n\t'use strict';\n\n\t/* Abort for ancient browsers. */\n\tif ( ! document.querySelector || ! window.addEventListener || typeof URL === 'undefined' ) {\n\t\treturn;\n\t}\n\n\t/** @namespace wp */\n\twindow.wp = window.wp || {};\n\n\t/* Abort if script was already executed. */\n\tif ( !! window.wp.receiveEmbedMessage ) {\n\t\treturn;\n\t}\n\n\t/**\n\t * Receive embed message.\n\t *\n\t * @param {MessageEvent} e\n\t */\n\twindow.wp.receiveEmbedMessage = function( e ) {\n\t\tvar data = e.data;\n\n\t\t/* Verify shape of message. */\n\t\tif (\n\t\t\t! ( data || data.secret || data.message || data.value ) ||\n\t\t\t/[^a-zA-Z0-9]/.test( data.secret )\n\t\t) {\n\t\t\treturn;\n\t\t}\n\n\t\tvar iframes = document.querySelectorAll( 'iframe[data-secret=\"' + data.secret + '\"]' ),\n\t\t\tblockquotes = document.querySelectorAll( 'blockquote[data-secret=\"' + data.secret + '\"]' ),\n\t\t\tallowedProtocols = new RegExp( '^https?:$', 'i' ),\n\t\t\ti, source, height, sourceURL, targetURL;\n\n\t\tfor ( i = 0; i < blockquotes.length; i++ ) {\n\t\t\tblockquotes[ i ].style.display = 'none';\n\t\t}\n\n\t\tfor ( i = 0; i < iframes.length; i++ ) {\n\t\t\tsource = iframes[ i ];\n\n\t\t\tif ( e.source !== source.contentWindow ) {\n\t\t\t\tcontinue;\n\t\t\t}\n\n\t\t\tsource.removeAttribute( 'style' );\n\n\t\t\tif ( 'height' === data.message ) {\n\t\t\t\t/* Resize the iframe on request. */\n\t\t\t\theight = parseInt( data.value, 10 );\n\t\t\t\tif ( height > 1000 ) {\n\t\t\t\t\theight = 1000;\n\t\t\t\t} else if ( ~~height < 200 ) {\n\t\t\t\t\theight = 200;\n\t\t\t\t}\n\n\t\t\t\tsource.height = height;\n\t\t\t} else if ( 'link' === data.message ) {\n\t\t\t\t/* Link to a specific URL on request. */\n\t\t\t\tsourceURL = new URL( source.getAttribute( 'src' ) );\n\t\t\t\ttargetURL = new URL( data.value );\n\n\t\t\t\tif (\n\t\t\t\t\tallowedProtocols.test( targetURL.protocol ) &&\n\t\t\t\t\ttargetURL.host === sourceURL.host &&\n\t\t\t\t\tdocument.activeElement === source\n\t\t\t\t) {\n\t\t\t\t\twindow.top.location.href = data.value;\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t};\n\n\tfunction onLoad() {\n\t\tvar iframes = document.querySelectorAll( 'iframe.wp-embedded-content' ),\n\t\t\ti, source, secret;\n\n\t\tfor ( i = 0; i < iframes.length; i++ ) {\n\t\t\t/** @var {IframeElement} */\n\t\t\tsource = iframes[ i ];\n\n\t\t\tsecret = source.getAttribute( 'data-secret' );\n\t\t\tif ( ! secret ) {\n\t\t\t\t/* Add secret to iframe */\n\t\t\t\tsecret = Math.random().toString( 36 ).substring( 2, 12 );\n\t\t\t\tsource.src += '#?secret=' + secret;\n\t\t\t\tsource.setAttribute( 'data-secret', secret );\n\t\t\t}\n\n\t\t\t/*\n\t\t\t * Let post embed window know that the parent is ready for receiving the height message, in case the iframe\n\t\t\t * loaded before wp-embed.js was loaded. When the ready message is received by the post embed window, the\n\t\t\t * window will then (re-)send the height message right away.\n\t\t\t */\n\t\t\tsource.contentWindow.postMessage( {\n\t\t\t\tmessage: 'ready',\n\t\t\t\tsecret: secret\n\t\t\t}, '*' );\n\t\t}\n\t}\n\n\twindow.addEventListener( 'message', window.wp.receiveEmbedMessage, false );\n\tdocument.addEventListener( 'DOMContentLoaded', onLoad, false );\n})( window, document );\n</script>\n", "lang": "en", "duration": 8285 }

0 - 50 of 1 items

10 25 50 100 250