Try using pragma read_uncommited=1; For my stuff I use the sqlite3_backup api to "copy" the database into another, or in memory - then read from memory normally.