mbkowns Posted October 1, 2008 Share Posted October 1, 2008 I have looked around these forums on how to use SQLite but some of my questions are not answer. If I want to use a SQLite database stored as a file and have multiple users using it is this possible? Is there anyway in GUI interface to build the database? Link to comment Share on other sites More sharing options...
Pain Posted October 1, 2008 Share Posted October 1, 2008 SQLite_Gui: http://www.autoitscript.com/forum/index.php?showtopic=17099 Link to comment Share on other sites More sharing options...
mbkowns Posted October 20, 2008 Author Share Posted October 20, 2008 I read there but I am not sure since people go back and forth on it. Can I write to the same database file with multiple users at the same time? Link to comment Share on other sites More sharing options...
PsaltyDS Posted October 21, 2008 Share Posted October 21, 2008 (edited) I read there but I am not sure since people go back and forth on it. Can I write to the same database file with multiple users at the same time? No. You can have it open by multiple users, and they can all read/select at the same time, but not write changes at the same time. There is a file lock mechanism that returns SQLite_Busy if concurrent changes are attempted. From the SQLite.au3 UDF: Global Const $SQLITE_BUSY = 5 ; /* The database file is locked */ If you expect the possibility of multiple users writing changes about the same time, check for $SQLITE_BUSY in the return and just repeat the change operation (i.e. UPDATE) after a random delay (say, 100 to 1000 msec). See SQLite FAQ for some warnings about MS Windows CIFS share bugginess. Edited October 21, 2008 by PsaltyDS Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now