Jump to content
Sign in to follow this  
mbkowns

SQLite Walkthrough

Recommended Posts

mbkowns

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?

Share this post


Link to post
Share on other sites
mbkowns

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?

Share this post


Link to post
Share on other sites
PsaltyDS

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.

:P

Edited 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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.