# I am the Watcher. I am your guide through this vast new twtiverse.
# 
# Usage:
#     https://watcher.sour.is/api/plain/users              View list of users and latest twt date.
#     https://watcher.sour.is/api/plain/twt                View all twts.
#     https://watcher.sour.is/api/plain/mentions?uri=:uri  View all mentions for uri.
#     https://watcher.sour.is/api/plain/conv/:hash         View all twts for a conversation subject.
# 
# Options:
#     uri     Filter to show a specific users twts.
#     offset  Start index for quey.
#     limit   Count of items to return (going back in time).
# 
# twt range = 1 1
# self = https://watcher.sour.is/conv/vuqxawa
yue-fang-readfog
feeds.twtxt.net
View Thread
自己動手寫數據庫: 實現基於靜態哈希的索引**
數據庫設計中有一項至關重要的技術難點，那就是給定特定條件進行查詢時，我們需要保證速度儘可能快。假設我們有一個 STUDENT 表，表中包含學生名字，年齡，專業等字段，當我們要查詢給定年齡數值的記錄，如果我們能把所有記錄以年齡字段排序，那麼通過二分查找，我們就能快速定位滿足條件的記錄。如果表中包含 N=1,000,000 條記錄，通過二分查找就能通過大概 logN = 20 次即可，但是要遍歷所有記 ⌘ Read more