Nuffing.com

The king’s genes also raise some royally embarrassing questions about the legitimacy of the Tudors who ended his reign.
via National Geographic News
DNA Confirms: Here Lieth Richard III, Under Yon Parking Lot

Shopping for clothes that actually fit is downright agonizing—especially for women, when a size 8 varies so ridiculously across clothing brands. Find Your Fit might help put an end to this shopping frustration.

The webapp takes your measurements and compares them to retailers’ published size charts, then shows you the brand and size that would fit you best. You can click on the retailer name to see how your body outline coincides (and varies) with the retailers’.

The tool’s not perfect, because unless you’re very lucky, retailers’ measurements won’t fit all three measurements for you perfectly, but it does show you the closest option from its database of brands. In the example above, Anthropologie’s size 10 size chart lists a 38" bust measurement, 30-32" for the waist, and 40" for the hips. Banana Republic’s size 10 measurements are 37" bust, 30" waist, and 40" hips.

In some cases—if one measurement is much greater or smaller than the others, for example, or all three measurements are nearly the same—you’ll have a harder time finding a perfect match, thanks to designers’ emphasis on a not-so-universal hourglass shape (when in doubt, it looks like the app tries to fit your hip and bust size before the waist). You can still use the tool, though, to check out how the brands’ clothes might possibly fit you.

Find Your Fit also has a "recommended clothing items" feature, which pulls in clothes listed on eBay via Pic Click’s visual search.

Find Your Fit

via Lifehacker
Find Your Fit Shows Women’s Clothing Sizes by Brands That Fit You Best

via kottke.org
Master blacksmith forges a beautiful knife

Researchers have discovered overwhelming evidence that a skeleton found under a parking lot in Leicester, England, belonged to King Richard III. … Continued

The post DNA proves parking lot skeleton is Richard III appeared first on Futurity.

via Futurity
DNA proves parking lot skeleton is Richard III

(NSFW: Language) Plinkett – the creepy film critic behind the hilarious and on point Star Wars prequels reviews – weighs in on the teaser for Star Wars: The Force Awakens, reminding us of its ultimate purpose: marketing.
via The Awesomer
Mr. Plinkett: Star Wars VII Teaser

The ubiquitous sawhorse is a staple of most workshops. This one isn’t fancy, but it gets the job done quickly and cheaply.

Building this sawhorse requires materials that you can easily find on most job sites or in your home workshop. All you need is a few 2x4s and some nails (or screws). In particular, you’ll need:

• 8 – 30″ 2x4s for the legs
• 6 – 32.5″ 2x4s for the "I" beam

These lengths can be adjusted to your preference, as long as the height of the legs match.

You can churn these out quickly with a nail gun, but if you want something more stable use 3" galvanized deck screws.

Start by assembling your "I" beam which will serve as the base and center point for your sawhorse. Use four screws to attach each section, as shown below:

Then place the legs directly under the top of the sawhorse and screw or nail it into the "I" beam using a square pattern.

When you’re done, they should look like this:

That’s all it takes! Feel free to decorate your drab sawhorses as needed. These are painted gold. Tip: To create a softer surface, staple carpet pieces to the top of the sawhorse.

How To Build Sawhorses | Charles & Hudson

via Lifehacker
​Build Stackable Sawhorses from Scrap Lumber in Under 10 Minutes

British techno-satire Black Mirror is now streaming on US Netflix, and everyone should watch Charlie Booker’s thoughtful, funny, taut, and terrifying anthology series if you haven’t already.

Black Mirror a smart update on The Twilight Zone‘s paranoid anxiety-dissection hour. What comes across as overly broad on paper (politician/pig sex, Rupert Everett, a plot that can more or less accurately be described as "What if our eyeballs had instant memory replay?") is sharp onscreen. Each of the six standalone episodes is executed as a relentlessly intelligent meditation on the myopia technology can induce.

An addition reason to binge-stream: Jon Hamm is starring in the upcoming Black Mirror Christmas special, so you might as well get caught up before it airs. [Netflix]

via Gizmodo
Netflix Is Now Streaming Black Mirror, the Best Show About Technology 

 The boxed copy sales model for professional software is dead, and increasingly companies are realizing that charging certain customers at all doesn’t make much sense. Microsoft figured it out, and Autodesk is expanding the pool of people who get free access to include all students, teachers and schools at academic institutions around the world. That’s in addition to the U.S., where… Read More

via TechCrunch
Autodesk Software Now Free For Schools And Students Everywhere

The stripped down stored procedure shown below will accept any Data Manipulation Language statement as its parameter and automatically log the statement and create table backup copies before the statement is executed. The logging functionality is similar to MySQL’s binary log but exclusive to DML statements and is useful for table data recovery operations, such as undoing the last table data change or to revert databases back to a certain point in time. All this is done exclusively using stored routines (procedures and functions).Its assumed that the databases and tables that will be used are already formed to specific business requirements since DDL statements will not be logged by the stored procedure. Though logging of table data changes can also be achieved using triggers, it is not practical to alter each and every trigger of every table if there are numerous tables to consider. Using a stored procedure allows the functionality to be portable to any existing database since no alteration is needed.DELIMITER $$DROP PROCEDURE IF EXISTS `$DML` $$CREATE DEFINER=`root`@`localhost` PROCEDURE `$DML`( IN dmlString TEXT)$dml: BEGIN DECLARE clearLogs BOOLEAN DEFAULT TRUE; DECLARE backupAllDB BOOLEAN DEFAULT TRUE; DECLARE dmlFilter BOOLEAN DEFAULT TRUE; DECLARE EXIT HANDLER FOR SQLWARNING, SQLEXCEPTION, NOT FOUND ROLLBACK; SET dmlString = TRIM(dmlString); IF (dmlString LIKE (‘UNDO%’)) THEN CALL $UNDO(dmlString); LEAVE $dml; END IF; initialize: BEGIN DECLARE selectStmtBackupAllDB  TEXT; IF ( IF(( EXISTS( SELECT * FROM `information_schema`.`TABLES` WHERE (`TABLE_SCHEMA` = ‘$backup’)) ), 1, 0) ) THEN LEAVE initialize; END IF; CREATE DATABASE `$backup`; CREATE TABLE `$backup`.`history` ( `dmlStringId` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `user` VARCHAR(255) NOT NULL, `dmlString` TEXT NOT NULL, `timestamp` TIMESTAMP NOT NULL DEFAULT NOW(), PRIMARY KEY (`dmlStringId`) ) ENGINE = InnoDB; CREATE TABLE `$backup`.`tableref` ( `tableRefId` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `dbName` VARCHAR(64) NOT NULL, `tableName` VARCHAR(64) NOT NULL, `tableAlias` VARCHAR(64) NOT NULL, `backupOf` INTEGER UNSIGNED, PRIMARY KEY (`tableRefId`) ) ENGINE = InnoDB; IF (backupAllDB) THEN SET selectStmtBackupAllDB = "SELECT T.`TABLE_SCHEMA`, T.`TABLE_NAME` FROM `information_schema`.`TABLES` T WHERE (`TABLE_SCHEMA` != ‘information_schema’) AND (`TABLE_SCHEMA` != ‘mysql’) AND (`TABLE_SCHEMA` != ‘performance_schema’) AND (`TABLE_SCHEMA` != ‘$backup’) AND (`TABLE_NAME` NOT LIKE ‘dynamic_cursor%’)"; ELSE SET selectStmtBackupAllDB = "SELECT T.`TABLE_SCHEMA`, T.`TABLE_NAME` FROM `information_schema`.`TABLES` T WHERE (`TABLE_SCHEMA` =  DATABASE()) AND (`TABLE_NAME` NOT LIKE ‘dynamic_cursor%’)"; END IF; CALL dynamicCursor( selectStmtBackupAllDB, ‘initialize’, @NULL, logging ); END initialize; IF (dmlFilter) AND (dmlString NOT LIKE (‘INSERT%’)) AND (dmlString NOT LIKE (‘UPDATE%’)) AND (dmlString NOT LIKE (‘DELETE%’)) AND (dmlString NOT LIKE (‘REPLACE%’)) AND (dmlString NOT LIKE (‘SELECT%’)) AND (dmlString NOT LIKE (‘SHOW%’)) THEN SET dmlString = NULL; END IF; START TRANSACTION; SET @dmlStringStmt = dmlString; PREPARE dmlStringStmt FROM @dmlStringStmt; EXECUTE dmlStringStmt; DEALLOCATE PREPARE dmlStringStmt; COMMIT; IF (dmlString LIKE (‘SELECT%’)) OR (dmlString LIKE (‘SHOW%’)) THEN LEAVE $dml; ELSE INSERT `$backup`.`history` VALUES (DEFAULT, USER(), dmlString, DEFAULT); END IF;END $dml $$DELIMITER ;The stored procedure is part of a small project, Safe DML, $DML().
via Planet MySQL
Automatic Logging of Table Data Changes and Creation of Backups via a Stored Procedure