Converting a large text file into an sqlite database

Sometimes we need to deal with large text files that are more than some text editors can handle. I recently have to convert a large text file containing a list of words which contains more than 600,000 lines.  The file size was just under 100MB and to open it with a text editor was an exercise in frustration.  Continue reading Converting a large text file into an sqlite database

Fix the annoying Android File Transfer bug on the Macbook

Have you been working on an app and you decided to deploy your android app to your phone, only to find out that when you plug the phone into one of the USB ports, the Android File Transfer app pops up and then you find that your built-in keyboard and trackpad does not work? Or worse, have you ever wanted to just charge your phone only to find out that you computer’s keyboard and trackpad stops working when you plug the phone into the USB port? Continue reading Fix the annoying Android File Transfer bug on the Macbook