Sqlite Commands in Terminal

(Shimen.Taiwan)

Recently, I need to use sqlite commands to check data for my android app. Thanks to the rooted android ROM, the shell environment is much useful than before. It's possible to use Tab key to auto complete filenames and directories, and I can use sqlite3 command directly in adb shell. It saved time from pulling the database file out back and forth.

However, it's been quite a while that I almost forgot how to deal with a sqlite database. The following link is a handy Url to help me on this:

http://www.sqlite.org/cli.html

To name a few:
.mode  // select different modes, eg, list, line, column

select * from tbl1; // select all from table tbl1

光華-蘋果3C電池專家 換 Macbook Pro 2011 電池的經驗

(Taidong.Taiwan)

終於受不了 MacBook Pro 沒有電池的情況下的龜速運轉，帶著電腦直奔光華商場。
沒想到，就是這個沒想到，
老闆之花了15分鐘不到就幫我把電池換好了。
而且在換電池的過程中，不斷地在跟我說電池要怎麼保養，
平常電腦要怎麼使用會比較好。
所以在我還沒站到腳酸時，電池就已經換好了，
老闆還順便用吸塵器清了風扇，用洗潔精擦了擦 MBP 的外觀和螢幕。

從這刻起，我的 macbook pro 2011 又是一尾活龍了！(而且是真的活龍)
忘了裝的是不是原廠的電池了，
不過看在老闆的服務這麼好的份上，
而且價錢又只有原廠的一半，
即使得要一年換一次電池我就甘願。

https://tw.user.bid.yahoo.com/tw/user/Y5622188506

MacBook Pro 電池壞了，電腦速度蠻超慢

(石門.桃園)

這個問題困擾我兩三個月了。由於電池壞了，整台 MBP 慢得跟十幾年前的電腦一樣，而且還是台裝了 SSD 的高檔貨。網路上看到大部分的文章都是說，要換顆電池，整台電腦又會變得頭好壯壯，但是，才買來兩年的電腦，我實在是不想再去花個幾千塊換電池。而且現在這台 MBP 幾乎都當成桌上型電腦在用了，也不會再移來移去，換顆電池的 CP 值實在是不高。

今天，在網路上找了一下，竟然有辦法可以在電池爛掉的情況下，讓它回復到原有的速度！這真是太好了！馬上試了一下，實際上只不過是把某個設定 CPU 何時該升降速，風扇該運轉的設定檔移走，讓系統找不到，整台電腦就不會那麼卡了。

有需要有人可以參考這個網址：
 http://www.rdoxenham.com/?p=259

Amazing tutorial about setting up git server on QNAP server

Wow, with this article's help, I set up git server on home NAS server.
Now, time to do some work.

http://wiki.qnap.com/wiki/Gitosis

Android Books

It's good to be able to wander in Safari's online shelves and pick up books that I am interested in. Though not having enough time coding, I still managed to quickly take glimpse over two Android books recently. One is 50 Android Hacks, and another one is Android Developer Tools Essential. Both are good to read and gave me some new nuance for my poor Android knowledge.

Google Reader is going into history today.

I've been using Google Reader for very very long time. It's the most important news resource and knowledge source for me. Now it will be closed soon. Kind of  sad that such a good service will no longer exist.

Get Rid of HTC Sync Manager autostart on Mac, and Android File Transfer Autostart

(Geneve.Swiss)

Tired of seeing autostart finder popups every time I plugged in my new hTc one into my mac. Here's a way to disable it:
1. Identify UUID:
   by using "diskutil info /Volumes/HTC\ Sync\ Manager
   you can get its volume UUID
2. sudo vifs
    add a line as below:

UUID=YOURVOLUMEUUID none hfs rw,noauto

= = = = =
As for disabling Android File Transfer app, you just need to rename file names of the so called Agent app:
1. /Users/user_name/Library/Application Support/Google/Android File Transfer
2. /Applications/Android File Transfer.app/Contents/Resources

REF:
http://blog.softwareispoetry.com/2013/05/disable-htc-syc-manager-autostarting.html