Hi everybody this is my fist message on this list.
Well, i know that my subject sounds a little stupid, by the way sqlite3 evolution trys to performe better ACID. But i want to force blocking the db file while my aplication is running. I'm using sqlite for session cache, i don't want that a user change my sqlite db with other instance of my app, or using sqlite command line. On this moment i'm using "begin exclusive", to block. The real problem is that my aplication is a GUI aplication and y use the event loop to notify errors; when an error occurs sqlite3 end my transaction then by a litle interval of time the db is unblocked before my error event recreate the exclusive transaction. There is a better way to block, or my solution don't have any sence. Thanks ! All your answer are wellcomed !
