# 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/ygq5k6a
SQLITE 問題整理**
前言用過 sqlite 的朋友都知道,在數據庫目錄會有 xxx.db 文件,你可能看到過,其實數據庫不只有 xxx.db,有時候還會有 xxx.db-shm、xxx.db-wal、xxx.db-journal 等文件,你有想過這些文件的作用是什麼嗎?還有使用數據庫時,偶爾會報 SQLITEBUSY 或者 SQLITELOCKED 的錯誤,你知道是因爲什麼導致的嗎?請看正文。知識點db-shm、db ⌘ Read more