Generated (Virtual) Columns in MySQL 5.7 (labs)

MySQL Performance Blog

About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed) Columns. The…

29 April 2015

Indexing 101: Optimizing MySQL queries on a single table

MySQL Performance Blog

I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was simple: the wrong indexes were added and so the execution plan was poor. Here are guidelines to help you optimize various kinds of single…

27 April 2015

Boolean parameters to API functions considered harmful (2011)

Hacker News

one line of code at a time Can you spot the bug in the following code? _xhr.open(options.type, options.url, options.sync); The problem is that the last param to xhr.open is whether the xhr is async. Ouch. Turns out, this code was written intentionally,…

15 April 2015

8 reasons to use 1Password that don't involve storing passwords

Macworld

Available for Mac, iOS, Windows, and Android, 1Password is a must-have for desktop and mobile users seeking equal parts online security and convenience. But there’s far more to this software than its single-purpose name might imply. 1Password owners…

14 April 2015

SSLMate – Buy SSL certs from the command line

Hacker News

Secure your website the easy way. SSLMate makes it easy to buy, deploy, and manage your SSL certs. Get SSL certificates from the command line in under 60 seconds. No complicated openssl commands or copy-and-pasting certificate bundles.…

9 April 2015

pquery binaries with statically included client libs now available!

MySQL Performance Blog

After we released pquery to the community, and as we started logging bug reports with pquery testcases, it quickly became clear that pquery binaries with statically compiled-in client libraries would be of great convenience, both for ourselves and for the…

9 April 2015

Mac 911: How to erase your Mac's hard drive the right way

Macworld

When you sell or donate a Mac or give it to a family member, it’s best to make a clean break: wipe the puppy clean, reinstall the latest version of OS X, and hand off a system that you’re not worried has remnants of yourself on it. But how can you be sure?…

9 April 2015

Why Netflix is embracing Python over Java

Hacker News

Netflix is increasingly turning to Python over Java to power certain aspects of its video-streaming service, such as generating and processing alerts, boosting resilience, securing transactions, producing deployable AMIs (Amazon Machine Images), and for…

8 April 2015

Show HN: Kaiwa, a Modern Open-Source XMPP Web Client

Hacker News

Inspired by the best and built for XMPP, Kaiwa is a beautiful web-based client for the only standardized chat protocol. Combined with Prosody, one of the best XMPP servers out there, Kaiwa provides an unparalleled XMPP experience, on par…

8 April 2015