Storing SHA1 hash values in MySQL

And I also wouldn’t store the value the SHA1 is returning. Because it uses just 4 bit per character and thus would need 160/4 = 40 characters. But if you use 8 bit per character, you would only need a 160/8 = 20 character long field.

So I recommend you to use BINARY(20) and the UNHEX function to convert the SHA1 value to binary.

Easy Popover Footnotes in WordPress

I am an avid reader of The Magazine , and one of the first things you will notice when reading any issue is the clever handling of footnotes in their pieces. Commonly you will find these links to footnotes either inline or in the form of a tappable button with a symbol in it (in their case, a star) embedded throughout The Magazine’s thought-provoking paragraphs. Whenever you tapped one of these links, something kind of unique happened. Instead of being whisked away to the bottom of the page, the content of these footnotes would pop up instantly over the text in a modal window.

 

For Mobile Messaging, GIFs Prove to Be Worth at Least a Thousand Words

When Ms. Dikeou recently wanted a friend to stop sending her pictures of food, she responded with a GIF — an animated image known as a graphics interchange format — of Christina Aguilera rolling her eyes, waving her hand and soundlessly mouthing “PLEASE STOP.” Ms. Dikeou’s mobile messages are now often textless, replaced by clips of Harry Potter applauding, or excited toddlers opening birthday presents. Her favorite one features the ensemble cast of “Seinfeld” elatedly dancing, which she sent upon hearing that a friend was coming into town.

.. Just as smartphones drove the rise of emoji, mobile devices are propelling GIFs into a more widespread form of instant visual-messaging. Tumblr, the blogging site, said it had 23 million GIFs posted to its site every day. In March, Facebook began supporting GIFs, with more than five million of the animations sent daily through its messaging app. Slack, the workplace collaboration start-up, says it counts more than two million GIF integrations each month.