lmorchard - Pebbling Club 🐧🪨

wesql/wesql: WeSQL is an innovative MySQL distribution that adopts a compute-storage separation architecture, with storage backed by S3 (and S3-compatible systems). It can run on any cloud, ensuring no vendor lock-in.

github.com
2024-11-27T23:50:46.223Z
databases dev mysql s3 aws

Notes

WeSQL is an innovative MySQL distribution that adopts a compute-storage separation architecture, with storage backed by S3 (and S3-compatible systems). It can run on any cloud, ensuring no vendor lock-in.

Unfurl

{ "expires": 1732837843861, "status": 200, "bodyLength": 330964, "author": "wesql", "date": null, "description": "WeSQL is an innovative MySQL distribution that adopts a compute-storage separation architecture, with storage backed by S3 (and S3-compatible systems). It can run on any cloud, ensuring no vendor l…", "image": "https://opengraph.githubassets.com/2fdd4daab660d768f037ecc2d6e9b6bf576c43b06144c0610f7ce21a3b733c91/wesql/wesql", "logo": "https://github.com/fluidicon.png", "publisher": "GitHub", "title": "GitHub - wesql/wesql: WeSQL is an innovative MySQL distribution that adopts a compute-storage separation architecture, with storage backed by S3 (and S3-compatible systems). It can run on any cloud, ensuring no vendor lock-in.", "url": "https://github.com/wesql/wesql", "feed": null, "iframe": null, "lang": "en", "video": null, "audio": null, "duration": 1100 }
BrewBlogger Version 2.3.2 - The Browser-Based Homebrew Logging Solution

www.brewblogger.net
2012-09-03T23:43:12.000Z
homebrewing php mysql web metablogging blog imported:pinboard

Notes

BrewBlogger 2.3.2 is a easy to set up, easy to use, browser-based homebrew logging and calculation suite. It is a PHP/MySQL-based system that provides today's brewer not only a fast and easy way to record their brewing activities, recipes, and awards, but also forum to share their zymurgistic efforts and expertise with the homebrewing community around the world.

Unfurl

{ "image": "http://bluehost-cdn.com/media/user/suspended_account/_bh/beback-soon.png", "logo": "https://t1.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://brewblogger.net/&size=128", "url": "http://www.brewblogger.net/", "lang": "en", "failed": true, "failedAt": 1728194839401, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
MySQL Bugs: #56696: server stalls during truncate table for innodb

bugs.mysql.com
2012-02-12T00:42:24.000Z
mysql bug via:kellan imported:pinboard

Notes

Found this via kellan. Wow, and I *just* hit this issue yesterday on a MySQL 5.1 instance

Unfurl

{ "image": "http://bugs.mysql.com/images/mysql_100x52-64.gif", "logo": "https://bugs.mysql.com/favicon.ico", "title": "MySQL Bugs: #56696: server stalls during truncate table for innodb", "url": "http://bugs.mysql.com/bug.php?id=56696", "failed": true, "failedAt": 1728194965172, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds", "expires": 1728364875460, "status": 200, "bodyLength": 18604, "duration": 4027 }
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 }
Enabling Vertical (\G) Output in the MySQL Client | Slaptijack

slaptijack.com
2009-10-28T18:26:43.000Z
mysql tips databases imported:pinboard

Notes

"One problem with the MySQL command line client is that queries with lots of columns tend to wrap crazily based on your terminal size. To overcome this, you can get a vertical output by terminating your queries with \G instead of ;. I find this format extremely helpful in cases where I know only one row will be returned. "

Unfurl

{ "failed": true, "failedAt": 1728195507383, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
Spock Proxy

spockproxy.sourceforge.net
2008-12-11T01:14:52.000Z
spock mysql sql scaling webdev database proxy imported:pinboard

Notes

"Spock Proxy supports range-based horizontal paritioning of a large MySQL database. The proxy intercepts SQL queries from the client, sends queries to the correct databases based on how the database is partitioned, then aggregates the results from each database and returns them to the client as a regular MySQL result set. "

Unfurl

{ "failed": true, "failedAt": 1728195537422, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds", "expires": 1728365925550, "status": 200, "bodyLength": 26764, "image": "http://spockproxy.sourceforge.net/images/proxy_schema.png", "logo": "https://sourceforge.net/favicon.ico", "title": "Spock Proxy", "url": "http://spockproxy.sourceforge.net/", "duration": 6285 }
A Bunch of Great Strategies for Using Memcached and MySQL Better Together | High Scalability

highscalability.com
2008-08-06T20:37:00.000Z
mysql memcached webdev caching performance tips imported:pinboard

Notes

"The primero recommendation for speeding up a website is almost always to add cache and more cache. And after that add a little more cache just in case. Memcached is almost always given as the recommended cache to use. What we don't often hear is how to effectively use a cache in our own products. MySQL hosted two excellent webinars (referenced below) on the subject of how to deploy and use memcached."

Unfurl

{ "failed": true, "failedAt": 1728195567378, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
Install and configure MySQL 5 with MacPorts | 2 tablespoons

2tbsp.com
2008-04-14T22:51:32.000Z
osx mysql macports imported:pinboard

Unfurl

{ "failed": true, "failedAt": 1728195587427, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds", "expires": 1728366041596, "status": 200, "bodyLength": 25339, "image": "https://2tbsp.com/sites/default/themes/twotbsp/logo.png", "logo": "https://2tbsp.com/sites/default/themes/twotbsp/favicon.ico", "publisher": "2 tablespoons", "title": "Install and configure MySQL 5 with MacPorts | 2 tablespoons", "url": "http://2tbsp.com/articles/2007/09/25/install-and-configure-mysql-5-macports", "lang": "en", "duration": 6681 }
Design details of Audiogalaxy.com’s high performance MySQL search engine | Spiteful.com

www.spiteful.com
2008-03-04T19:52:53.000Z
audiogalaxy mysql search webdev imported:pinboard

Notes

"At peak times, the search engine needed to handle 1500-2000 searches every second against a MySQL database with about 200 million rows."

Unfurl

{ "failed": true, "failedAt": 1728195587494, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
TagSchema - MySQLForge Wiki

forge.mysql.com
2008-02-04T21:45:12.000Z
tags mysql databases socialsoftware imported:pinboard

Notes

Noticing one thing missing from most tagging schemes: Preservation of the order of tags as entered with the item. Seems minor, but it's actually important for capturing intent.

Feed

Unfurl

{ "failed": true, "failedAt": 1728195597456, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds", "expires": 1728366073956, "status": 200, "bodyLength": 33989, "logo": "https://labs.mysql.com/common/themes/sakila/favicon.ico", "title": "MySQL", "url": "http://forge.mysql.com/wiki/TagSchema", "feed": "http://forge.mysql.com/mysql.rss", "lang": "en", "duration": 8531 }
Introduction and QuickStart | The Open Source Journal

portal.itauth.com
2007-10-29T22:22:16.000Z
fuse loggerfs linux xml mysql imported:pinboard

Notes

"It seamlessly passes log data through the file system and directly into a database. Unlike existing log parsers, which often run periodically and scan the entire file for changes, LoggerFS takes a unique approach by masking the database backend with a fi

Unfurl

{ "failed": true, "failedAt": 1728195617441, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
Amazon Web Services Blog: MySQL Interface to Amazon S3

aws.typepad.com
2007-04-12T14:22:42.000Z
s3 amazon mysql webdev webservices databases imported:pinboard

Notes

"Independent developer Mark Atwood has been working on a MySQL interface to Amazon S3."

Unfurl

{ "failed": true, "failedAt": 1728195657440, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
TurboDbAdmin, presented by TurboAjax Group

www.turboajax.com
2005-11-07T22:37:12.000Z
ajax mysql php webdev imported:pinboard

Notes

"A single-page solution for exploring and editing databases from a browser."

Unfurl

{ "failed": true, "failedAt": 1728195777492, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
apache friends - xampp

www.apachefriends.org
2005-10-28T15:14:43.000Z
lamp mysql apache php perl imported:pinboard

Notes

"XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl."

Unfurl

{ "failed": true, "failedAt": 1728195777646, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }
Then each went to his own home - Does del.icio.us scale?

www.pui.ch
2005-08-31T14:03:26.000Z
del.icio.us database mysql tagging tags imported:pinboard

Notes

"MySQL is just not built for large tag-systems. It just doesn't scale. It does scale up to 1 Million items but delicious does have far more posts."

Unfurl

{ "failed": true, "failedAt": 1728195790045, "failedError": "TimeoutError: Promise timed out after 10000 milliseconds" }

0 - 50 of 15 items

10 25 50 100 250