On 19 Nov 2013, at 6:00am, Joshua Grauman <jnf...@grauman.com> wrote:

> sqlite3_open_v2("sqlite3.database.filename");
> sqlite3_exec("BEGIN IMMEDIATE");
> file.open("sqlite3.database.filename");
> file.readAll();
> file.close();
> sqlite3_exec("ROLLBACK");
> sqlite3_close();
> 
> So does this look like I should always read/write the database properly?

That looks like it should work.  Make sure that your defaults for file.open() 
don't try to lock the file.

I would probably use "END" rather than "ROLLBACK".  SQLite will know that you 
didn't make any changes and will probably execute exactly the same code, but I 
don't like seeing "ROLLBACK" unless something went wrong.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to