How To Run Third-Party USB Ethernet Adaptors with Your Apple Macbook Notebook

Ever since Apple started trimming down the ports on their Macbook notebooks, there’s been an increasing demand for adaptors to make up for the lack of connectivity. Today, I found out that I needed to access my Asus wireless router to set it up for a new ISP that I subscribed to. Unfortunately, I only had a third-party, non-Apple ethernet adaptor. In this case, it was a USB ethernet dongle from Lenovo. When I plugged it into my Macbook, nothing

Continue Reading

How To Open .jar Files Automatically in Mac OSX

A random program that I installed reset the default application (Java) for .jar files on my Macbook, and to reset the behaviour in Mac OSX took a bit more work than I thought. Turns out the “Java Launcher” isn’t in the list of applications that you can select from, in the “Open With…” list. You’ll need to select “Open With”, choose “Other”, and browse to the following: /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java Ensure that it’s set to “Always Open With”, and you should

Continue Reading

Which is Better: Creatine Capsules or Creatine Powder?

Creatine monohydrate may be one of the most common muscle building supplements available out there, but there are so many questions about it. The most studied type of creatine is creatine monohydrate, and it is widely accepted for its performance and value for money. One such question is: what form of creatine is best? The most common forms of creatine are powder and capsules. No conclusive evidence exists to say which form is better, but considering that the stomach digests

Continue Reading

Multivitamin 101: How To Select the Best Multivitamin

I’ve recently been getting interested in bio-hacking, or the process of combining biology with hacking. It’s a fancy term that encompasses things like eating clean, sleeping right, adopting good posture, putting yourself in uncomfortable situations, and so on. One of the things that I’m experimenting with is with supplements, and I’m still in the process of refining what my supplement stack is. However, the core of my supplement stack has got to be a multivitamin. Why A Multivitamin Is Useful

Continue Reading

How To Buy and Sell Forex Pairs

The first currency is the base currency. The second currency is the settlement currency. E.g. for the USD/SGD pair: If you wanted to obtain Singapore Dollars (SGD), you would SELL the USD/SGD pair. If you wanted to obtain United State Dollars (USD), you would BUY the USD/SGD pair. In forex trading and in brokers such as Interactive Brokers, this would be the way you’d convert from one currency to another.

How To Use Wildcard Characters in MySQL statements

You’ll need to make use of wildcard characters to perform powerful searches in MySQL. The 2 wildcard characters that you can use in “LIKE”-queries in MySQL are: % which matches 0 or more characters _ which matches exactly one character To search for a date, you can use a query like the following, which gives you everything that happened from 10 to 19 August of 2015, between 9:01am to 9:09am. SELECT * FROM `yourTable` WHERE `datetime` LIKE ‘2015-08-1_ 09:0%’

How to correctly display CSV files (Excel 2013)

Excel 2013 has an issue displaying files in CSV format that other versions of Excel doesn’t seem to have. To fix this, you’ll just need to open the CSV file with any text editor (like Notepad), and add the following as the first line: sep=, This sets the comma (or any other character that you need) as the separator. Now just save and close the file from your text editor, and then open it with Excel 2013.

Sliding Sidebar