Author Archives: J.D. H.

Ordering the Oculus Rift Development Kit 2 (DK2)

I received a tasty email in my inbox this morning, The Oculus Rift 2 is up for preorder!!! However, upon attempting to place my order I encountered some wonkiness in their ordering system (using both Chrome and Opera). Thankfully I eventually figured out how to place my order: After you enter your shipping/billing info, you should eventually make it to a screen that looks like a final ordering screen. But if you scroll down it looks like there no ‘order’

Access MySQL server over SSH tunnel using Navicat

Today was my first time to access a MySQL server over a SSH tunnel in Navicat. After a bit of trial and error I was finally able to achieve success 🙂 Here are the main things I learned: #1 On the client machine running Navicat, use the same credentials that you would use if you were at the console of the remote server. In this case localhost and port 3306 #2 On the SSH tab, use the remote server’s IP

SD cards for the Yoga 2 Pro that don’t stick out as much

In general, the Yoga 2 Pro is an excellent upgrade over the original Yoga 13. One of the few drawbacks of the Pro 2 is that Lenovo made it so normal SD cards stick out (rather than sitting flush like on the original Yoga). Thankfully, there are some shorter SD cards that meant to at least partially resolve this issue. You can find some more info at the links below:   PNY StorEDGE 128GB Flash Memory Expansion Module (P-MEMEXP128U1-EF): Computers &

Amazon Prime price increase to $99 a year

I received this in my inbox this morning: We are writing to provide you advance notice that the price of your Prime membership will be increasing. The annual rate will be $99 when your membership renews on August 28, 2014. Even as fuel and transportation costs have increased, the price of Prime has remained the same for nine years. Since 2005, the number of items eligible for unlimited free Two-Day Shipping has grown from one million to over 20 million.

Replace () / . characters in phone numbers with dashes (MySQL database)

If you have a MySQL database containing phone number records in varying formats, you may want to standardize them. New records can easily be handled by checking data entry against your desired format (via JS or whatever method you like). However, existing records must be dealt with. That is where an UPDATE statement combined some handy MySQL functions can assist us: // Replace forward slash with dash UPDATE db_phonenumbers SET phone_field = REPLACE(phone_field, ‘/’, ‘-‘) // Replace close parenthesis with