Ok, thanks again for the tips, I'll change the ROLLBACK to END.
I'm assuming if I open the file read-only it shouldn't lock, right? I'm
using Qt, but I send it a read-only parameter which I assume translates
into something like a POSIX open("filename", O_RDONLY);
Josh
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
