2014/05/25

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
 



2014/05/10

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

(Taidong.Taiwan)

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

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

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