[Tips] SQLite: unable to open database file

最近寫一些小的web service需要存取SQLite,發現在CLI模式下測試正常,可是透過web存取時出現

Warning: sqlite_query() [function.sqlite-query]: unable to open database file in ...

改了code裡面存取的權限後依然不行,

sqlite_open(db, 0666, error)

最後才發現web server要有整個directory的write permission

reference: SQLite3: Unable to Open Database File