August 12, 2010

sqlite 記帳資料庫

sqlite 記帳資料庫

嗯,我用很久了...

首先是 sqlite-manager http://code.google.com/p/sqlite-manager/

如果有用 firefox 的話

那就裝一下 http://sqlite-manager.googlecode.com/files/sqlitemanager-0.5.17.xpi

如果沒有

先抓 XULRunner https://developer.mozilla.org/en/XULRunner_1.9.2_Release_Notes

http://releases.mozilla.org/pub/mozilla.org/xulrunner/releases/1.9.2.8/runtimes/xulrunner-1.9.2.8.en-US.win32.zip

然後再抓 sqlite-manager

http://sqlite-manager.googlecode.com/files/sqlitemanager-xr-0.5.17-es-ES.zip

個別解壓縮

在 .\xulrunner-1.9.2.8.en-US.win32\xulrunner\ 資料夾中會有 xulrunner.exe 執行檔

右鍵建立捷徑

右鍵選捷徑內容

在捷徑標籤的目標欄位,加上 sqlite-manager 的 application.ini 位置

像是如果我的 application.ini 是在下面這一行的這個地方的話

C:\Documents and Settings\kfgg\My Documents\sqlitemanager-xr-0.5.17-es-ES\application.ini

那我的 xulrunner.exe 的捷徑目標欄就填

"C:\Documents and Settings\kfgg\My Documents\xulrunner-1.9.2.8.en-US.win32\xulrunner\xulrunner.exe"  "C:\Documents and Settings\kfgg\My Documents\sqlitemanager-xr-0.5.17-es-ES\application.ini"

加雙引號的原因是因為路徑中有空白的原故

接下來,點兩下捷徑就會跑出 sqlite-manager 視窗了

先選擇 Database -> New Database 建立新資料庫,填檔名、選位置

接下來匯入 sql,選 Database -> Import -> 點 SQL 標籤 -> Select File 選擇 sql 檔  -> UTF-8 -> OK

匯入完成

下面貼一下我用的帳單資料庫結構 sql,檔案記得存成 UTF-8

--------------------------------------------------
DROP TABLE IF EXISTS "main_class";
CREATE TABLE main_class (
    id INT UNSIGNED NOT NULL,
    name varchar(255) NOT NULL,
    PRIMARY KEY(id));
INSERT INTO "main_class" VALUES(1,'INCOME');
INSERT INTO "main_class" VALUES(2,'HOME EXPENSES');
INSERT INTO "main_class" VALUES(3,'TRANSPORTATION');
INSERT INTO "main_class" VALUES(4,'HEALTH');
INSERT INTO "main_class" VALUES(5,'CHARITY_GIFTS');
INSERT INTO "main_class" VALUES(6,'DAILY LIVING');
INSERT INTO "main_class" VALUES(7,'ENTERTAINMENT');
INSERT INTO "main_class" VALUES(8,'SAVINGS');
INSERT INTO "main_class" VALUES(9,'OBLIGATIONS');
INSERT INTO "main_class" VALUES(10,'SUBSCRIPTIONS');
INSERT INTO "main_class" VALUES(11,'MISCELLANEOUS');
INSERT INTO "main_class" VALUES(12,'SMART CARD');
DROP TABLE IF EXISTS "one_expenditure";
CREATE TABLE one_expenditure (
    year INT UNSIGNED NOT NULL,
    month INT UNSIGNED NOT NULL,
    day INT UNSIGNED NOT NULL,
    main_class_id INT UNSIGNED NOT NULL,
    sub_class_id INT UNSIGNED NOT NULL,
    amount INT NOT NULL,
    detail text);
DROP TABLE IF EXISTS "sub_class";
CREATE TABLE sub_class (
    main_class_id INT UNSIGNED NOT NULL,
    id INT UNSIGNED NOT NULL,
    name varchar(255) NOT NULL,
    PRIMARY KEY(main_class_id, id));
INSERT INTO "sub_class" VALUES(1,1,'Wages_Tips');
INSERT INTO "sub_class" VALUES(1,2,'Interest Income');
INSERT INTO "sub_class" VALUES(1,3,'Dividends');
INSERT INTO "sub_class" VALUES(1,4,'Gifts Received');
INSERT INTO "sub_class" VALUES(1,5,'Refunds_Reinbursements');
INSERT INTO "sub_class" VALUES(1,6,'Transfer From Savings');
INSERT INTO "sub_class" VALUES(1,7,'MISCELLANEOUS');
INSERT INTO "sub_class" VALUES(2,1,'Mortgage_Rent');
INSERT INTO "sub_class" VALUES(2,2,'Home_Rental Insurance');
INSERT INTO "sub_class" VALUES(2,3,'Electricity');
INSERT INTO "sub_class" VALUES(2,4,'Gas_Oil');
INSERT INTO "sub_class" VALUES(2,5,'Water_Sewer_Trash');
INSERT INTO "sub_class" VALUES(2,6,'Phone');
INSERT INTO "sub_class" VALUES(2,7,'Cable_Satellite');
INSERT INTO "sub_class" VALUES(2,8,'Internet');
INSERT INTO "sub_class" VALUES(2,9,'Furnishings_Appliances');
INSERT INTO "sub_class" VALUES(2,10,'Lawn_Garden');
INSERT INTO "sub_class" VALUES(2,11,'Maintenance_Supplies');
INSERT INTO "sub_class" VALUES(2,12,'Improvements');
INSERT INTO "sub_class" VALUES(2,13,'Other');
INSERT INTO "sub_class" VALUES(3,1,'Vehicle Payments');
INSERT INTO "sub_class" VALUES(3,2,'Auto Insurance');
INSERT INTO "sub_class" VALUES(3,3,'Fuel');
INSERT INTO "sub_class" VALUES(3,4,'Bus_Taxi_Train Fare');
INSERT INTO "sub_class" VALUES(3,5,'Repairs');
INSERT INTO "sub_class" VALUES(3,6,'Registration_License');
INSERT INTO "sub_class" VALUES(3,7,'Other');
INSERT INTO "sub_class" VALUES(4,1,'Health Insurance');
INSERT INTO "sub_class" VALUES(4,2,'Doctor_Dentist');
INSERT INTO "sub_class" VALUES(4,3,'Medicine_Drugs');
INSERT INTO "sub_class" VALUES(4,4,'Health Club Dues');
INSERT INTO "sub_class" VALUES(4,5,'Life Insurance');
INSERT INTO "sub_class" VALUES(4,6,'Veterinarian_Pet Care');
INSERT INTO "sub_class" VALUES(4,7,'Other');
INSERT INTO "sub_class" VALUES(5,1,'Gifts Given');
INSERT INTO "sub_class" VALUES(5,2,'Charitable Donations');
INSERT INTO "sub_class" VALUES(5,3,'Religious Donations');
INSERT INTO "sub_class" VALUES(5,4,'Other');
INSERT INTO "sub_class" VALUES(6,1,'Groceries');
INSERT INTO "sub_class" VALUES(6,2,'Personal Supplies');
INSERT INTO "sub_class" VALUES(6,3,'Clothing');
INSERT INTO "sub_class" VALUES(6,4,'Cleaning');
INSERT INTO "sub_class" VALUES(6,5,'Education_Lessons');
INSERT INTO "sub_class" VALUES(6,6,'Dining_Eating Out');
INSERT INTO "sub_class" VALUES(6,7,'Salon_Barber');
INSERT INTO "sub_class" VALUES(6,8,'Pet Food');
INSERT INTO "sub_class" VALUES(6,9,'Other');
INSERT INTO "sub_class" VALUES(7,1,'Videos_DVDs');
INSERT INTO "sub_class" VALUES(7,2,'Music');
INSERT INTO "sub_class" VALUES(7,3,'Games');
INSERT INTO "sub_class" VALUES(7,4,'Rentals');
INSERT INTO "sub_class" VALUES(7,5,'Movies_Theater');
INSERT INTO "sub_class" VALUES(7,6,'Concerts_Plays');
INSERT INTO "sub_class" VALUES(7,7,'Books');
INSERT INTO "sub_class" VALUES(7,8,'Hobbies');
INSERT INTO "sub_class" VALUES(7,9,'Film_Photos');
INSERT INTO "sub_class" VALUES(7,10,'Sports');
INSERT INTO "sub_class" VALUES(7,11,'Outdoor Recreation');
INSERT INTO "sub_class" VALUES(7,12,'Toys_Gadgets');
INSERT INTO "sub_class" VALUES(7,13,'Vacation_Travel');
INSERT INTO "sub_class" VALUES(7,14,'Other');
INSERT INTO "sub_class" VALUES(8,1,'Emergency Fund');
INSERT INTO "sub_class" VALUES(8,2,'Transfer to Savings');
INSERT INTO "sub_class" VALUES(8,3,'Retirement');
INSERT INTO "sub_class" VALUES(8,4,'Investments');
INSERT INTO "sub_class" VALUES(8,5,'Education');
INSERT INTO "sub_class" VALUES(8,6,'Smart Card Prepaid');
INSERT INTO "sub_class" VALUES(8,7,'Other');
INSERT INTO "sub_class" VALUES(9,1,'Student Loan');
INSERT INTO "sub_class" VALUES(9,2,'Other Loan');
INSERT INTO "sub_class" VALUES(9,3,'Credit Card Debt');
INSERT INTO "sub_class" VALUES(9,4,'Alimony_Child Support');
INSERT INTO "sub_class" VALUES(9,5,'Federal Taxes');
INSERT INTO "sub_class" VALUES(9,6,'State_Local Taxes');
INSERT INTO "sub_class" VALUES(9,7,'Other');
INSERT INTO "sub_class" VALUES(10,1,'Newspaper');
INSERT INTO "sub_class" VALUES(10,2,'Magazines');
INSERT INTO "sub_class" VALUES(10,3,'Dues_Memberships');
INSERT INTO "sub_class" VALUES(10,4,'Other');
INSERT INTO "sub_class" VALUES(11,1,'Bank Fees');
INSERT INTO "sub_class" VALUES(11,2,'Postage');
INSERT INTO "sub_class" VALUES(11,3,'Other');
INSERT INTO "sub_class" VALUES(12,1,'Bus_Taxi_Train Fare');
INSERT INTO "sub_class" VALUES(12,2,'Groceries');
INSERT INTO "sub_class" VALUES(12,3,'Dining_Eating Out');
CREATE VIEW "列出主類別每個月的總支出" AS SELECT main_class.name as m_name,
    one_expenditure.year as year,
    one_expenditure.month as month,
    total(one_expenditure.amount) as total_main_class_expenditure,
    total(one_expenditure.amount) / total_expenditure_per_month * 100 as total_expenditure_percentage
from one_expenditure, main_class,
    (SELECT year as t_year,
         month as t_month,
         count(one_day_sum) as day_count,
         avg(one_day_sum) as average_expenditure_a_day_per_month,
         sum(one_day_sum) as total_expenditure_per_month
     from
         (SELECT one_expenditure.year as year,
              one_expenditure.month as month,
              one_expenditure.day,
              sum(one_expenditure.amount) as one_day_sum
          from one_expenditure
          where main_class_id != 1 and main_class_id != 12
          group by year, month, day)
     group by year, month
     order by year, month)
where main_class_id = main_class.id and year = t_year and month = t_month
group by year, month, main_class.id
order by year, month, main_class.id;
CREATE VIEW "列出副類別每個月每天的平均支出" AS SELECT m_name,
    s_name,
    year,
    month,
    count(one_day_sum) as day_count,
    avg(one_day_sum) as average_expenditure_a_day_per_month
from
    (SELECT main_class.name as m_name,
        sub_class.name as s_name,
        one_expenditure.year as year,
        one_expenditure.month as month,
        one_expenditure.day,
        sum(one_expenditure.amount) as one_day_sum
    from one_expenditure, main_class, sub_class
    where one_expenditure.main_class_id = main_class.id and
        one_expenditure.sub_class_id = sub_class.id and
        sub_class.main_class_id = main_class.id
    group by year, month, day, main_class.id, sub_class.id)
group by year, month, m_name, s_name
order by year, month, m_name, s_name;
CREATE VIEW "列出副類別每個月每筆的平均支出" AS SELECT main_class.name as m_name,
    sub_class.name as s_name,
    one_expenditure.year as year,
    one_expenditure.month as month,
    count(one_expenditure.amount) as item_count,
    avg(one_expenditure.amount) as average_expenditure_an_item_per_month
from one_expenditure, main_class, sub_class
where one_expenditure.main_class_id = main_class.id and
    one_expenditure.sub_class_id = sub_class.id and
    sub_class.main_class_id = main_class.id
group by year, month, main_class.id, sub_class.id
order by year, month, main_class.id, sub_class.id;
CREATE VIEW "列出副類別每個月的總支出" AS SELECT main_class.name as m_name,
    sub_class.name as s_name,
    one_expenditure.year as year,
    one_expenditure.month as month,
    total(one_expenditure.amount) as total_sub_class_expenditure,
    total(one_expenditure.amount) / total_expenditure_per_month * 100 as total_expenditure_percentage
from one_expenditure, main_class, sub_class,
    (SELECT year as t_year,
         month as t_month,
         count(one_day_sum) as day_count,
         avg(one_day_sum) as average_expenditure_a_day_per_month,
         sum(one_day_sum) as total_expenditure_per_month
     from
         (SELECT one_expenditure.year as year,
              one_expenditure.month as month,
              one_expenditure.day,
              sum(one_expenditure.amount) as one_day_sum
          from one_expenditure
          where main_class_id != 1 and main_class_id != 12
          group by year, month, day)
     group by year, month
     order by year, month)
where one_expenditure.main_class_id = main_class.id and
    one_expenditure.sub_class_id = sub_class.id and
    sub_class.main_class_id = main_class.id  and
    year = t_year and month = t_month
group by year, month, main_class.id, sub_class.id
order by year, month, main_class.id, sub_class.id;
CREATE VIEW "列出每個月的總支出與每天平均支出" AS SELECT year,
    month,
    count(one_day_sum) as day_count,


April 21, 2009

News rss feeds

AFPBB News - 総合新着記事100 - - http://feeds.afpbb.com/afpbbnews
AP Top Headlines At 4:10 a.m. EDT - http://hosted.ap.org/lineups/TOPHEADS-rss_2.0.xml?SITE=FLDAY&SECTION=HOME
AP Top International News At 4:10 a... - http://hosted.ap.org/lineups/WORLDHEADS-rss_2.0.xml?SITE=NEYOR&SECTION=HOME
asahi.com - http://rss.asahi.com/f/asahi_newsheadlines
BBC News | News Front Page | World Edition - http://newsrss.bbc.co.uk/rss/newsonline_world_edition/front_page/rss.xml
BBC News | World | UK Edition - http://newsrss.bbc.co.uk/rss/newsonline_uk_edition/world/rss.xml
CNN.com - http://rss.cnn.com/rss/cnn_topstories.rss
CNN.com - WORLD - http://rss.cnn.com/rss/edition_world.rss
Google News - http://news.google.com.tw/news?ned=us&hl=en&output=rss
Google ニュース 日本版 - トップニュース - http://news.google.com.tw/news?ned=jp&hl=ja&topic=h&num=3&output=rss
Google 新聞 台灣版 - http://news.google.com.tw/news?pz=1&ned=tw&hl=zh-TW&output=rss
J-CASTニュース - http://www.pheedo.jp/f/jcast_news_2
jiji.comアクセスランキング - http://www.jiji.com/rss/ranking.rdf
NYT Home Page - http://feeds.nytimes.com/nyt/rss/HomePage
NYT World - http://feeds.nytimes.com/nyt/rss/World
Reuters: International News - http://feeds.reuters.com/reuters/worldNews
Reuters: Top News - http://feeds.reuters.com/reuters/topNews
Reuters: トップニュース - http://feeds.reuters.com/reuters/JPTopNews
Reuters: ワールド - http://feeds.reuters.com/reuters/JPWorldNews
udn最新報導 - http://udn.com/udnrss/latest.xml
Yahoo! News: Top Stories - http://rss.news.yahoo.com/rss/topstories
Yahoo!ニュース - 海外 - CNN.co.jp - http://headlines.yahoo.co.jp/rss/cnn_c_int.xml
Yahoo!奇摩新聞-即時新聞 - http://tw.news.yahoo.com/rss/realtime
yam天空新聞 - 即時 - http://n.yam.com/RSS/Rss_all.xml
YOMIURI ONLINE(読売新聞)ニュースランキング - http://rss.yomiuri.co.jp/f/yolranking30
国際 - アサヒ・コム - http://rss.asahi.com/f/asahi_international
毎日jp-ニュース速報(総合) - http://mainichi.pheedo.jp/f/mainichijp_flash
毎日jp-掘り出しニュース - http://mainichi.jp/rss/etc/horidashi.rss


March 8, 2009

梅竹總錦標

98 清大 6:4
http://zh.wikipedia.org/w/index.php?title=%E6%A2%85%E7%AB%B9%E8%B3%BD&variant=zh-tw

來清大六年,終於看到梅竹賽拿總錦標了!

超爽的啊!

不過,今年的梅竹並不算完美。

男籃的技術犯規事件,令人不快。

話說今天的正式賽賽程還真的全勝耶!

真是佩服!

沒有遺憾了!

終於可以安心畢業了!


February 9, 2009

老鼠會


January 16, 2009

剪刀、石頭、布


January 7, 2009

DOM Inspector

Introduction to the DOM Inspector
http://brownhen.com/DI/

[翻譯中][CrazyLion] 介紹DOM Inspector
http://forum.moztw.org/viewtopic.php?t=3747

Ajax Gossip: DOM Inspector
http://caterpillar.onlyfun.net/Gossip/AjaxGossip/DOMInspector.html

我用的是 Firefox 裡的那個

為了 CSS 才用的

找 id, 找 class

超方便的啊!

用過就知道!


December 27, 2008

無心插柳柳橙汁

終於突破啦!

以為已經完全沒機會了的說!

爽!

http://jeff7744.pixnet.net/album/photo/102398812


December 24, 2008

哈哈

原來如此


December 17, 2008

雜感

0000000: 3030 3030 3030 303a 2033 3033 3020 3330 0000000: 3030 30
0000010: 3330 2033 3033 3020 3330 3361 2032 3036 30 3030 303a 206
0000020: 3220 3333 3337 2033 3332 3020 3631 3336 2 3337 3320 6136
0000030: 2020 3030 3030 3030 303a 2062 3337 3320 0000000: b373
0000040: 6136 0d0a 3030 3030 3031 303a 2036 3436 a6..0000010: 646
0000050: 3220 3230 3631 2033 3433 3720 3336 3230 2 2061 3437 3620
0000060: 2036 3233 3320 3631 3333 2032 3036 3120 6233 6133 2061
0000070: 3334 3631 2020 6462 2061 3437 3620 6233 3461 db a476 b3
0000080: 6133 2061 3461 0d0a 3030 3030 3032 303a a3 a4a..0000020:
0000090: 2033 3332 3020 3632 3333 2036 3436 3620 3320 6233 6466
00000a0: 3230 3633 2033 3533 3720 3337 3230 2036 2063 3537 3720 6
00000b0: 3133 3620 3634 3632 2020 3320 6233 6466 136 6462 3 b3df
00000c0: 2063 3537 3720 6136 6462 0d0a 3030 3030 c577 a6db..0000
00000d0: 3033 303a 2032 3032 3020 3265 3733 2032 030: 2020 2e73 2
00000e0: 6532 6520 3265 3736 2032 6532 6520 3265 e2e 2e76 2e2e 2e
00000f0: 3265 2032 6532 6520 3265 3737 2020 2020 2e 2e2e 2e77
0000100: 2e73 2e2e 2e76 2e2e 2e2e 2e2e 2e77 0d0a .s...v.......w..
0000110: 3030 3030 3034 303a 2032 6532 6520 3064 0000040: 2e2e 0d
0000120: 3061 2033 3033 3020 3330 3330 2033 3033 0a 3030 3030 303
0000130: 3120 3330 3361 2032 3036 3120 3334 3337 1 303a 2061 3437
0000140: 2020 2e2e 2e2e 3030 3030 3031 303a 2061 ....0000010: a
0000150: 3437 0d0a 3030 3030 3035 303a 2033 3632 47..0000050: 362
0000160: 3020 3631 3631 2036 3236 3120 3230 3631 0 6161 6261 2061
0000170: 2033 3433 3420 3338 3230 2036 3133 3120 3434 3820 6131
0000180: 3334 3331 2020 3620 6161 6261 2061 3434 3431 6 aaba a44
0000190: 3820 6131 3431 0d0a 3030 3030 3036 303a 8 a141..0000060:
00001a0: 2032 3036 3120 3336 3632 2033 3332 3020 2061 3662 3320
00001b0: 3631 3334 2036 3233 3020 3230 3632 2036 6134 6230 2062 6
00001c0: 3236 3620 3332 3230 2020 2061 3662 3320 266 3220 a6b3
00001d0: 6134 6230 2062 6266 3220 0d0a 3030 3030 a4b0 bbf2 ..0000
00001e0: 3037 303a 2036 3233 3820 3635 3631 2032 070: 6238 6561 2
00001f0: 3032 3020 3265 3736 2032 6532 6520 3265 020 2e76 2e2e 2e
0000200: 3438 2032 6534 3120 3265 3265 2020 6238 48 2e41 2e2e b8
0000210: 6561 2020 2e76 2e2e 2e48 2e41 2e2e 0d0a ea .v...H.A....
0000220: 3030 3030 3038 303a 2032 6532 6520 3265 0000080: 2e2e 2e
0000230: 3265 2032 6532 6520 3064 3061 2033 3033 2e 2e2e 0d0a 303
0000240: 3020 3330 3330 2033 3033 3220 3330 3361 0 3030 3032 303a
0000250: 2020 2e2e 2e2e 2e2e 2e2e 3030 3030 3032 ........000002
0000260: 303a 0d0a 3030 3030 3039 303a 2032 3036 0:..0000090: 206
0000270: 3120 3635 3635 2033 3632 3020 3633 3335 1 6565 3620 6335
0000280: 2036 3636 3420 3230 3631 2033 3733 3420 6664 2061 3734
0000290: 3636 3230 2020 2061 6565 3620 6335 6664 6620 aee6 c5fd
00002a0: 2061 3734 6620 0d0a 3030 3030 3061 303a a74f ..00000a0:
00002b0: 2036 3133 3420 3334 3338 2032 3036 3220 6134 3438 2062
00002c0: 3333 3634 2036 3632 3020 3633 3335 2033 3364 6620 6335 3
00002d0: 3733 3720 3230 3631 2020 6134 3438 2062 737 2061 a448 b
00002e0: 3364 6620 6335 3737 2061 0d0a 3030 3030 3df c577 a..0000
00002f0: 3062 303a 2033 3933 3420 3636 3230 2036 0b0: 3934 6620 6
0000300: 3133 3120 3334 3338 2032 3032 3020 3265 131 3438 2020 2e
0000310: 3265 2032 6532 6520 3265 3466 2020 3934 2e 2e2e 2e4f 94
0000320: 6620 6131 3438 2020 2e2e 2e2e 2e4f 0d0a f a148 .....O..
0000330: 3030 3030 3063 303a 2032 6534 3820 3265 00000c0: 2e48 2e
0000340: 3265 2032 6537 3720 3265 3466 2032 6534 2e 2e77 2e4f 2e4
0000350: 3820 3064 3061 2033 3033 3020 3330 3330 8 0d0a 3030 3030
0000360: 2020 2e48 2e2e 2e77 2e4f 2e48 2e2e 3030 .H...w.O.H..00
0000370: 3030 0d0a 3030 3030 3064 303a 2033 3033 00..00000d0: 303
0000380: 3320 3330 3361 2032 3033 3020 3634 3330 3 303a 2030 6430
0000390: 2036 3132 3020 3230 3230 2032 3032 3020 6120 2020 2020
00003a0: 3230 3230 2020 3033 303a 2030 6430 6120 2020 030: 0d0a
00003b0: 2020 2020 2020 0d0a 3030 3030 3065 303a ..00000e0:
00003c0: 2032 3032 3020 3230 3230 2032 3032 3020 2020 2020 2020
00003d0: 3230 3230 2032 3032 3020 3230 3230 2032 2020 2020 2020 2
00003e0: 3032 3020 3230 3230 2020 2020 2020 2020 020 2020
00003f0: 2020 2020 2020 2020 2020 0d0a 3030 3030 ..0000
0000400: 3066 303a 2032 3032 3020 3230 3230 2032 0f0: 2020 2020 2
0000410: 3032 3020 3230 3230 2032 3032 3020 3230 020 2020 2020 20
0000420: 3230 2032 3032 3020 3265 3265 2020 2020 20 2020 2e2e
0000430: 2020 2020 2020 2020 2020 2020 2e2e 0d0a ....
0000440: 3030 3030 3130 303a 2030 6430 6120 2020 0000100: 0d0a
0000450: 2020 2020 2020 2020 2020 2020 2020 2020
0000460: 2020 2020 2020 2020 2020 2020 2020 2020
0000470: 2020 2e2e 0d0a ....


November 28, 2008

當飛機碰上亂流


November 10, 2008

反序

大概不會有人發現

不過那也不重要

就當作是新的思考方式

雖然不變的還是不變


October 26, 2008

十月

快結束了


October 20, 2008

七圈

也不是非常累啦...

我想應該是鞋子的關係...

腳小痛...


August 31, 2008

Mozilla Labs Ubiquity

Introducing Ubiquity
http://labs.mozilla.com/2008/08/introducing-ubiquity/

Ubiquity 0.1 User Tutorial
https://wiki.mozilla.org/Labs/Ubiquity/Ubiquity_0.1_User_Tutorial

Mozilla發表Ubiquity計畫 要讓混搭應用更簡單
http://www.ithome.com.tw/itadm/article.php?c=50633

神奇的功能!


August 13, 2008

Xming

Xming X Server for Windows
http://sourceforge.net/projects/xming

Xming 簡易使用說明
http://www.cs.nctu.edu.tw/help/xming.html


July 29, 2008

Google map - 台灣國道即時影像


June 18, 2008

Firefox 3

Firefox 3 !! - 2008/6/18 AM 2:16 GMT+8

+24 hours

Spread Firefox | Download Day 2008
http://www.spreadfirefox.com/en-US/worldrecord/

目前七百萬
http://f12.wretch.yimg.com/jeff7744/4/o1434896047.jpg?jtBeBwn6zK1LDYN792QotIdDGz9gDIKf.XBX6N5awpice4gMCAavxQ87



話說 Firefox 3 書籤是用 SQLite 來存的

於是

SQLite Manager
http://code.google.com/p/sqlite-manager/

這東西就好用啦!

雖然我只是用來刪書籤上的圖示...


補一下

Firefox 3 開 Gmail 暴力快啊啊啊!!!


May 23, 2008

Google File System

http://en.wikipedia.org/wiki/Google_File_System

BigTable

MapReduce

Hadoop

Cloud storage


May 14, 2008

Fedora 9

[root@ip088161 ~]# uname -r
2.6.25-14.fc9.i686

這次也是用 yum 升級...

果然很累...

這次為了解 yum 的 Missing Dependency Error

完全是在亂踹指令...

yum upgrade 完 reboot 後 Xen 還掛掉...

當下完全無法遠端登入

今天到實驗室修...

結果發現只能用 console...

修個刁...

不過至少可以遠端登入了

現在 startx 出現的 error 看起來像修好了

明天再去看看介面

下面的指令別亂試...

電腦炸了自行負責...


---------------------------------------------
Error: Missing Dependency: libldap-2.3.so.0 is
needed by package cups-1.3.7-2.fc8.i386

解:

yum erase cups

yum erase cups-libs

yum install cups

rpm -Uvh ftp://ftp.isu.edu.tw/pub/Linux/Fedora/
linux/releases/9/Fedora/i386/os/Packages/
cups-libs-1.3.7-1.fc9.i386.rpm --force

yum upgrade

---------------------------------------------
startx 時:
(EE) No devices detected

解:

yum erase xorg-x11-drv-openchrome

yum install xorg-x11-drivers

rpm -Uvh ftp://ftp.isu.edu.tw/pub/Linux/Fedora/
linux/releases/8/Everything/i386/os/Packages/
xorg-x11-drv-via-0.2.2-4.fc8.i386.rpm

rpm -e xorg-x11-drv-via

Xorg -configure
跑完上面這行,它會告訴你可以跑面下面那一行

X -config /root/xorg.conf.new
如果 top 有看見 X 應該就好了

mv /root/xorg.conf.new /etc/X11/xorg.conf

reboot


May 7, 2008

Switch console

Ctrl + Alt + function key (F1 - F7)



unlog_NVPO 0