It seems that sqlite won't allow me to create a temporary view in a read-only db. Am I missing something? If it's TEMPORARY, I figured db connection mode shouldn't matter.
I even specified "PRAGMA temp_store = MEMORY" -- it didn't help.
Is there a reasonable alternative to using views? 开发者_如何转开发
You can create a temporary view that references data in the main db.
CREATE VIEW temp.userview AS select userid, firstname, lastname from main.usertbl;
Then access the view like such...
SELECT * from temp.userview;
精彩评论